on 08-03-2006 10:09 AM
Hi,
We have a scenario for testing database connectivity with AS400 via JDBC drivers.
And we have already tried with MSSQL JDBC drivers.
The sap document on external drivers JDBC and JMS provides only for some database..
Is there any way to identify the jar files for each and every database individually.any documents to find the list for external JDBC with respect to each database...
Kindly help
Gopalakrishnan M
Hi,
For AS400, we can use File based integration. The AS400 creates a flat file which is read by SAP XI File adapter and sent through regular processing.
There are two types of DB2 JDBC Drivers are avialble.
1.The "Native" JDBC driver.
Driver:com.ibm.db2.jdbc.app.DB2Driver
Sub protocol:db2
Ex.jdbc:db2:localhost/COLLECTIONNAME
2.The "Toolbox" JDBC driver.
Driver:com.ibm.as400.access.AS400JDBCDriver
Sub protocol:as400
Ex.jdbc:as400://MACHINENAME/COLLECTIONNAME
We can integrate AS400 systems using JT400 classes from IBM, in a different middleware. These classes also have JDBC drivers, which you can use in the JDBC adapter but I would suggest to write your own adapter using JT400 Direct Record access classes. These are much faster than JDBC.
Ofcourse, you can also use the JMS and file adatper as other option as well.
And to access any Database from XI, the corresponding driver has to be deployed on your XI server.
For info on how the drivers have to be installed, check these links,
Also Refer to the documentation on the URL
http://as400bks.rochester.ibm.com/html/as400/v4r5/ic2924/index.htm?info/java/rzaha/jdbc.htm
There is a new tool available at Service Marketplace which makes it easy to deploy JDBC / JMS driver.
the URL is
https://websmp105.sap-ag.de/~sapdownload/011000358700007048402005E/HowInstallExternalDriver.zip
Check out the drivertool utility in this zip.
While using the AS/400 Toolbox for java, instead of AS/400 DevKit4Java, you will find this IBM page very useful.
http://as400bks.rochester.ibm.com/html/as400/v4r5/ic2924/info/java/rzahh/jdbc.htm
Also have a look at: http://publib.boulder.ibm.com/iseries/v5r2/ic2924/index.htm?info/rzahh/javadoc/JDBCProperties.html
It is clear from this document that, First you have to deploy with SDM the corresponding Drivers.
For example say,
com.ibm.as400.access.AS400JDBCDriver
Then in your configuration Channel you have to use this string:
jdbc:as400://"Your IP":446/"Your Schema";date format=iso;date separator=-
I hope this info helps......
Regards,
Abhy
Message was edited by: Abhy Thomas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
Log in to AS400 DB's website and see for the Driver info. You will get the driver to be used to connect to the database and then install the same on your XI.
Regards,
bhavesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If you are aware of the types of JDBC drivers, XI makes use of the Type 4 i.e. Thin drivers which are full Java Implementation type drivers. The responsibility of providing such a driver is of the database vendor and you should check the database documentation. If you google enough then you'll find many sites listing drivers for different databases but you get it only as a official download version
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.