Reg: JDBC using Oracle or SQL Serever

[Former Member]

Hi!

This is Amar. Actually I completed the Scenario using File to JDBC by using Data Base Microsoft Access. But My task is I need to use link JDBC scenario to Oracle or SQL Server instead of Microsoft Access.

So kindly provide Procedure steps to be follow for doing that

[Former Member · Accepted solution]

Hello Amar,

To work on MS-SQL Server or Oracle Server you need to install the corresponding server first. Also you have to install JDBC driver on your system.

Once you install the corresponding things then go thru the procedure mentioned in the following blog:

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

Regards,

Subhasha

[Former Member]

Ya finally I got it

[Former Member]

Hi,

There isn't much difference btweeen using MS-ACCESS and OR SQL doesn't make much of a difference apart from changes in theJDBC Driver and Connection paramreters.

<b>Cheers,

*RAJ*</b>

[Former Member]

For JDBC Adapter you need to deploy the particular driver, in order to enable XI talk to your DB.It is not required in case of MS Access.

For SQL

http://msdn.microsoft.com/data/ref/jdbc/

Also have a look at the following to install these driver in XI

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

Rest you have already done the configurations.They will be all same.

FILE to JDBC Adapter using SAP XI 3.0

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

Configuring the Receiver JDBC Adapter

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

XML SQL Format and Native XML Format

Get back if you get any specific doubt.

Thanks

[Former Member]

Hi,

See this,

http://help.sap.com/saphelp_nw04s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm

/people/varadharajan.krishnasamy/blog/2007/02/27/configuring-jdbc-connector-service-to-perform-database-lookups

/people/jegathees.waran/blog/2007/03/02/oracle-table-functions-and-jdbc-sender-adapter

/people/saravanakumar.kuppusamy2/blog/2005/01/19/rdbms-system-integration-using-xi-30-jdbc-senderreceiver-adapter

To connect to an Oracle DB, the Oracle Driver needs to be installed. The driver to be used depends on the JAVA version that you are using to access the XI server.

classes12.zip / classes12.jar driver is compatible with Java 1.2 and Java 1.3 only, but not with Java 1.4. To get

this support upgrade current driver to latest oracle drivers (ojdbc14.jar)

Please download oracle jdbc driver (ojdbc14.jar ) and install in J2EE engine from this link-

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html

This PDF can help you on the steps involved to install the JDBC driver.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-964...

and if you want to use jdbc adapter you have to deploy jdbc driver for the oracle, to know more about it go thru this link:

https://websmp202.sap-ag.de/~sapdownload/011000358700003994312004E/HowTo_ConfigExtAdapters.pdf

Read thru this document first:

https://websmp101.sap-ag.de/~sapdownload/011000358700003994312004E/HowTo_ConfigExtAdapters.pdf

I hope it helps you solve your problem.

Regards,

Akshay.

Message was edited by:

Akshay Jamgaonkar

Message was edited by:

Akshay Jamgaonkar

Message was edited by:

Akshay Jamgaonkar

null