Your question, your audience. Choose who sees your identity—and your question—with question security.
Solved
sync data between MySQL and Postgresql
Posted on 2013-01-06
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?
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?
5-
4
9 Comments
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
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:330
That's as far as I've gone so far =)
In the data source definition you set Driver to com.mysql.jdbc.Driver and URL to something like jdbc:mysql://localhost:330
That's as far as I've gone so far =)
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
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
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
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
Featured Post
Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.
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.
Join & Write a Comment Already a member? Login.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
- Databases
- AWS
- MySQL Server
- MongoDB
- NoSQL Databases
- Percona
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, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment.
To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses
Course of the Month5 days, 6 hours left to enroll
569 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.