How can I read SQL server tables from the iSeries?
The iSeries supports connection to other databases using DRDA. Because the SQL server (and oracle) does not support DRDA requests, it is not possible to do a simple "connect" to the SQL server.
* Use Java: Install a pure JDBC driver on the iSeries and use a Java program to connect to the SQL server. This requires you to code Java, but it is FREE and does not require any extra software. We "wrapped" the Java code for some of our customers (that means the customer uses RPG to call our Java that does the JDBC work).
* Buy, install and implement a product to help you. Some products:
* rpg2sql from RJS.
* Attunity connect from Attunity
* IBM's DB2 information integrator
You would use the same technique to connect to an SQL server
MORE INFORMATION ON THIS TOPIC
Ask your systems management questions--or help out your peers by answering them--in our live discussion forums.
The Best Web Links: Tips, tutorials and more.
Check out this Search400.com Featured Topic: Networking and the iSeries
PC/Windows connectivity expert Shahar Mor is available to answer your toughest networking questions. Ask Shahar a question or read his previously answered questions here.
Dig Deeper on Physical connections to iSeries
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.