|
You have a couple of options. If your IT staff has Java skills, one approach would be to write Java code that uses type 4 JDBC drivers to access the Oracle database, massage the data, and populate the iSeries DB2 databases.
If your company is lacking Java skills or would prefer another method, you might want to consider Websphere Information Integrator (Formerly DB2 Information Integrator - DB2 II). When you need to access a non-DB2 data source from an iSeries program written in any high-level programming language, DB2 II is a great solution. Be warned that it does require the data access to be performed with an SQL-based interface such as CLI, embedded SQL, or JDBC. For more information on DB2 Information Integrator and other methods of accessing non-DB2 data sources, view the white paper "Heterogeneous Data Access for iSeries Applications"
Regarding the FTP question, you can use FTP to pull data from a Solaris server. You would first want to export the Oracle data into a delimited format and than FTP the delimited data to the iSeries server and then use the CPYFRMIMPF CL command.
There are also third-party data replication products that support going from Oracle to DB2 UDB for iSeries. ==================================
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.
|
