Create a Pentaho Data Integration job to sync from .mdb to mysql database
$250-750 AUD
In Progress
Posted about 11 years ago
$250-750 AUD
Paid on delivery
The access database has 39 tables. I need to connect to access database through system DSN odbc driver. Need to be able to run job every 15 minutes.
Need one way sync from acess --> mysql. Reverse sync would be handy if it can be done easily but is not important at this stage.
The mysql table should have the same structure as the access table, with primary and foreign keys correctly added.
I can provide mdb file on request for quoting purposes.
Kind Regards
Steven Bliss
Pentaho Kettle specialized and ETL expert here. I can create the Kettle Transformation for you to meet the 15 minutes target. Please let me know how many millions rows of data you have. Lets continue in PM.
Hi, I have 4+ years experience in Pentaho tools. I have done many BI projects using Pentaho. Please go through private message for more detail. Thanks..
Hi, I have experience in SQL and various tool including pentaho in BI and can be potential asset for your project. Please check your message box for more details.