At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!
COURSE of the MONTH
15 days, 3 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
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?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
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
Active today
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
This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster.
To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB.
To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month15 days, 3 hours left to enroll
771 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.