DB2 database connection via JDBC ?

[michel_dekimpe]

All,

Does anybody know all the steps to setup a connection to a DB2 database ?

Is this also possible via JDBC sender adaptor ?

Thanks.

Regards, Michel

[Former Member · Accepted solution]

Hi,

please have a look here:

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f04ce027-934d-2a10-5a8f-fa0b1ed4...

http://help.sap.com/saphelp_nw04/helpdata/en/22/b4d13b633f7748b4d34f3191529946/frameset.htm

Regards

Patrick

[dharamveer_gaur2]

Hi

To connect with any database weather MS SQL Server, Oracle or DB2 you have to Use JDBC adapter of XI/PI.

Only Driver and connection parameter would be diffrent.

For DB2

Driver:com.ibm.db2.jdbc.app.DB2Driver

jdbcUrl=jdbc:db2://hostadres:portno/databasename

[michel_dekimpe]

Anybody has another idea ?

Thanks.

[Former Member]

Hi,

maybe my first answer was not precise enough.

If you want connect PI with a database you (always) use the JDBC Adapter.

Read from database -> Sender Adapter

Write to database -> Receiver Adapter

The detailed configuration is explained in SAP Help (provided by my second link above).

Prerequisite is that you have installed the driver for your database. This is explained in a How-To-Guide (second link above).

Hope it's clear now.

Regards

Patrick