Database Integration Between platforms

Question

0.00/5 (No votes)

See more:

Hi guys, did anybody know what kind of software or application database integration techniques between DB2 and MSSQL??

hi, I'm looking for third-party software/application to handle a scheduled data transfer from an AS400 file to a SQL Server table. It pulled data from AS400 to SQL Server 2005. Beside I also can access, insert and update data to a SQL server table. It uses industry standard plug-ins and can easily integrate with third party interfaces. Easily integrates with other applications or middleware. We would like to be able to use this data in a SQL Server database as well, so we'd like to have nightly updates from the AS400 to our SQL table to synch up the data. Regards aleesya

[Edit - Added the information you put in a comment to the question]

Posted 21-Nov-11 14:00pm

Reena Aleesya

Updated 22-Nov-11 5:36am

Kschuler

v2

Add a Solution

Comments

Sergey Alexandrovich Kryukov 21-Nov-11 20:34pm

What is the problem, exactly?
--SA

Reena Aleesya 21-Nov-11 20:41pm

hi,
I'm looking for third-party software/application to handle a scheduled data transfer from an AS400 file to a SQL Server table. It pulled data from AS400 to SQL Server 2005. Beside I also can access, insert and update data to a SQL server table. It uses industry standard plug-ins and can easily integrate with third party interfaces. Easily integrates with other applications or middleware. We would like to be able to use this data in a SQL Server database as well, so we'd like to have nightly updates from the AS400 to our SQL table to synch up the data.
Regards
aleesya

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dylan Morley · Answer 1 · 2011-11-22T05:47:00

Hi,

We work with AS400s extensively in our company, I just use SSIS in conjunture with the iSeries data transfer options and rxferpcb.exe (e.g C:\Program Files\IBM\Client Access\rxferpcb.exe)

RXFERPCB details[^]

You can use standard SSIS, but we found that performance is much better when using RXFERPCB

Basically, you extract data from your AS400 using RXFERPCB to create a local .CSV file. Then, you can use standard SSIS text transform to move the data into SQL Server. This is by far the fastest method of AS400 -> SQL Server ETL we have found

Nice article here

http://blog.stevienova.com/2009/05/20/etl-method-fastest-way-to-get-data-from-db2-to-microsoft-sql-server/[^]