ETL Application for diverse datasources

ETL Application for diverse datasources

Cancelled

Job Description

We have Three different Production DataBase Source
1.Oracle 7(on Unix),
2.Microsoft Sql - 2012 and
3.FoxPro Datafiles.

Our Staging destination Staging Database server that is Microsoft SQL 2012
(Dev01). We plan to replicate all of the required tables from above three diverse sources (Oracle 7, SQL2012 and FoxPro datafiles) database into MS-SQL Server 2012 (target Database Dev01).

Source Production database info:
1. Oracle 7 contain 60+ tables that need to be replicated at 10 min of interval Target Dev01.
2. MS Sql 2012 contain 40+ tables that need to be replicated at 5 min of interval into Ms-Sql 2012(Target Database Dev01).

3. FoxPro datafiles: 5 data files, each file belong to a table and need to be 10min replicated into Ms-Sql 2012(Target Database Dev01)