Q
Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

DB2 Information Integrator

I currently have VB 6.0 applications that access Oracle databases and write the data to an iSeries. We have a growing need to access Oracle data and would like to move away from the VB applications and use RPG with embedded SQL. It looks like DB2 Information Integrator would be a good solution, but I am not sure exactly what is needed. Is the full suite of products needed? I also need to broaden this to access data on SQL Servers.

The iSeries is a model 830 with three processors. One quote I got indicated that three replication products are needed, two connectors are needed, and a developer's license for each programmer. Is this correct?

DB2 Information Integrator (DB2 II) would be a good fit for your situation.

I agree that you need two connectors. The replication products would only be needed if you want to be able to synchronize data between the different platforms in addition to accessing non-DB2 data with embedded SQL. I don't know why you would need a developer's license for each programmer. Your embedded SQL programmers don't even need to know that DB2 II exists.

The Heterogeneous Data Access white paper has some examples showing how to use DB2 II. You can view the white paper here.

==================================
MORE INFORMATION ON THIS TOPIC
==================================

Visit the ITKnowledge Exchange and get answers to your DB2 questions fast.

Check out this Search400.com Featured Topic: Expert advice on DB2

Search400.com's targeted search engine: Get relevant information on DB2/400.

The Best Web Links: Tips, tutorials and more.

This was last published in November 2004

Dig Deeper on DB2 UDB (universal databases)

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close