We help IT Professionals succeed at work.
Get Started

[Best Practice] Sync data from iSeries DB2 to SQL server (for cognos staging DB)

2,746 Views
Last Modified: 2013-11-15
hi all

I am looking for best practice to create a staging environment for COGNOS.
our situation is like this:
The main database is located on as AS400 DB2 (developed with synon). We do not want Cognos to read directly from this DB, so we want to create an intermediate db on SQL server for cognos to read.
The question is what is the best practice to get all necessary tables from DB2 on sql server (IDS, program, stored procedures, cognos framework, etc) considering that during that process we need to apply several rules & formulas creating new "calculated fields". Also some tables are quite big more than 20mil rows, whats is the best way to keed this tables synced on SQL server (changes might occur on existing data). Finaly the field names on DB2 are something like FDSERTD and they need to be renamed to something that makes sense (keep in mind that the description (in DB2) of the fields  works fine)

million thanx in advance
George
Comment
Watch Question
Top Expert 2010
Commented:
This problem has been solved!
Unlock 1 Answer and 6 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE