Solved

sync data between MySQL and Postgresql

Posted on 2013-01-06
9
577 Views
Last Modified: 2013-01-07
Say,
We wish to use JasperReportsServer 5, which seems to support postgresql as default.
Our data is in MySql 5 on Linux server.
Is there a simple way to sync the data between the 2?
0
Comment
Question by:shaunwingin
  • 5
  • 4
9 Comments
 
LVL 24

Expert Comment

by:johanntagle
ID: 38750024
I think you should just configure Jasper to use mysql datasource.  That will be a way lot easier.  Go to section 4.1 of http://community.jaspersoft.com/documentation/jasperreports-server-administration-guide-v500
0
 

Author Comment

by:shaunwingin
ID: 38750058
Ok. How can I get the sample data from postgresql to MySql
0
 
LVL 24

Expert Comment

by:johanntagle
ID: 38750134
I don't believe you need to.  Jasper supports multiple data sources so you just add a mysql data source.  You will need to download the mysql jdbc driver from http://dev.mysql.com/downloads/connector/j/ and extract the jar file to the apache-tomcat/lib directory, restart tomcat (I just used the ctlscript.sh script to restart everything.)

In the data source definition you set Driver to com.mysql.jdbc.Driver and URL to something like jdbc:mysql://localhost:3306/test

That's as far as I've gone so far =)
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:shaunwingin
ID: 38750145
Tx. Its the sample data that was an issue for us...
0
 
LVL 24

Expert Comment

by:johanntagle
ID: 38750160
Again you can keep the postgresql data source with the sample data, then just add a mysql data source for your real data.  No need to transfer data from postgresql to mysql or vice-versa
0
 

Author Comment

by:shaunwingin
ID: 38750219
I've also my own data that wish to transfer - how can I import data to Postgre?
0
 
LVL 24

Expert Comment

by:johanntagle
ID: 38750597
Think you should file that as a separate question and provide details what exactly you want to do i.e. what is the format of the data, etc
0
 

Author Comment

by:shaunwingin
ID: 38750640
Can one have links to 2x data sources in JasperReportsServer? Please elaborate
Again you can keep the postgresql data source with the sample data, then just add a mysql data source for your real data.  No need to transfer data from postgresql to mysql or vice-versa
0
 
LVL 24

Accepted Solution

by:
johanntagle earned 500 total points
ID: 38750675
Follow the instructions in the documentation I mentioned above and you will realize you can add a mysql data source (and more) without removing the default postgresql data source.
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In this article, I will by showing a nice little trick for MySQL similar to that of my previous EE Article for SQLite (http://www.sqlite.org/), A SQLite Tidbit: Quick Numbers Table Generation (http://www.experts-exchange.com/A_3570.htm…
Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (http://dev.mysql.com/doc/refm…
Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

815 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now