Combine data from a few locations using Kettle

In Progress Posted Apr 21, 2010 Paid on delivery
In Progress Paid on delivery

Combine 3 retail stores Sales data to one central location. And then delete the old data from original tables

The source Database is based on Advantage Database server Tables [url removed, login to view]

The target tables would keep the same structure and the same database.

Some primary keys would have to be changed in order it should stay unique

Looking to implement this solution using Pentaho Data Integration with meta data.

Getting this bid would also have to guide me how to setup Pentanho / kettle

the source and target tables are in 4 Locations on a VPN Windows OS

(this is not the same job as my other job)

Files and detals of project on

[url removed, login to view]

User compcentral

Pass Central123 (C is in Caps)

Data Processing Microsoft Pentaho SQL

Project ID: #667180

About the project

8 proposals Remote project Active May 13, 2010