sync data between MySQL and Postgresql

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?
shaunwinginAsked:
Who is Participating?
 
johanntagleCommented:
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
 
johanntagleCommented:
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
 
shaunwinginAuthor Commented:
Ok. How can I get the sample data from postgresql to MySql
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

Start This Course
 
johanntagleCommented:
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
 
shaunwinginAuthor Commented:
Tx. Its the sample data that was an issue for us...
0
 
johanntagleCommented:
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
 
shaunwinginAuthor Commented:
I've also my own data that wish to transfer - how can I import data to Postgre?
0
 
johanntagleCommented:
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
 
shaunwinginAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.

Advertise Here