Perquisites for jdbc adapter

[Former Member]

Hi,

can any body tell me what are the Perquisites in order to do use jdbc adapter in either sender or receiver.

Perquisites may be installing driver progarms etc.

i have an little knowledze on how to design and configure jdbc adapter.

regards,

Pradeep A.

[Former Member]

Hi,

Check this Adapter configuration guide:

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

Thanks,

Boopathi

[Former Member]

Hi

JDBC Driver Deployment Guide...

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/70ffd890-0201-0010-708f-d5dad2df...

Also if you are using MS Access you not need to deploy any driver, for all other Databases you need it.

The table from which you are picking entries or putting entries should be created.

Use this for a basic JDBC scenario

FILE to JDBC Adapter using SAP XI 3.0

Thanks

[former_member193376]

Hi

This should answer your question

JDBC is a technical Adapter provided by SAP.

Pre-requisites for JDBC Adapter is

Install JDBC drivers on XI Server

Follow the bellow guide on how to install

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/xi/xi-how-to-guide...

Configuration of JDBC Adapter for SQL Server

JDBC Driver = com.microsoft.jdbc.sqlserver.SQLServerDriver

Connection = jdbc:microsoft:sqlserver://hostname:<port>;DatabaseName=<DBName>

UserID and Password.

If the connection is not working find the correct port number.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/40b92770-db81-2a10-8e91-f747188d...

Configuring the Sender JDBC Adapter

http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/1d/756b3c0d592c7fe10000000a11405a/content.htm

Http://help.sap.com/saphelp_nw2004s/helpdata/en/22/b4d13b633f7748b4d34f3191529946/frameset.htm

Configuring the Receiver JDBC Adapter

http://help.sap.com/saphelp_nw2004s/helpdata/en/b0/676b3c255b1475e10000000a114084/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/6d36d51d-0b01-0010-b3aa-9cb...

Thanks

Saiyog

[Former Member]

Hi ,

Kindly get the compatible drivers provided by the Vendor.

Mainly the JDK Version on which driver supports because it should be Jdk 1.4.x as XI runs on JDK 1.4

If it is below see if vendor gives comptabile drivers that runs on JDK 1.4

see if sapnote is provided.

this is basic check.

Kindly check website of the Vendor for more on this

reward point if useful

regards

Srini

Edited by: Venkateswarlu Srinivas on Jul 18, 2008 4:50 PM

[former_member181962]

Hi Pradeep,

Have you gone through this link?

This has a section for the prerequisites:

http://help.sap.com/saphelp_nw2004s/helpdata/en/b0/676b3c255b1475e10000000a114084/content.htm

REgards,

Ravi

[Former Member]

Hey

Please search SDN before posting your queries.

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

There are loads of other information too which you can find via search.

Thanx

Aamir