Regarding JDBC Adapter

[Former Member]

Hello Experts,

If i want to perform File to JDBC Scenario, Is it require any pre-requisite for JDBC Adapter configuration.

Thank you

[Former Member · Accepted solution]

Hi ravi kumar chandragiri ,

The following websites will answer u'r question:

JDBC is a technical Adapter provided by SAP.

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

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...

SAP XI Utilize SAP Adapters to connect to heterogenous systems

https://wwwn.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/3fc4bd90-0201-0010-68bd-ab931b0...

[Former Member]

HI,

File to JDBC:-

For Configuring jDBC adapter -

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

To do Jdbc scenarios initially we have to install jdbc drivers in the XI server to get connected to the database . and specify the connection details in the jdbc communication channel.

Regards,

Pradeep

[Former Member]

Hi,

You need to have your JDBC drivers installed in the SAP XI server and you can start configuring the JDBC details with the driver and the connection parameters.

Regards,

Nithiyanandam

[Former Member]

Hi,

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...

Regards

Seshagiri

[Former Member]

Hi,

The Prerequisite for JDBC adapter :

-Access to a database system or any other database that provides

JDBC drivers, to write the data into DB.

-The Driver should be deployed in the Server.

-Configure User in the SQL enterprise manager tool or similar tool for any other databases

[former_member238007]

Hi,

Yes, it is necessary to follow the structure of the JDBC to insert the data into the database else throws exception, but as UPDATE command is mandatory you should use it, if you dont want to any updation just type <TEST> there in the Update column.

follow this links it will be very useful

Receiver Structure

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

JDBC Discussions

Step By Step Process

regards,

Kishore

[Former Member]

hi

ref this

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/a04cd6f9-9eb0-2a10-07b8-a0fc6e88...