File to JDBC

[Former Member]

hey guys

i m trying file-to-JDBC scenario and i only have access to MSAccess as a database,is it possible to connect MSAcess via SAP XI and if its possible what JDBC driver name should i use in the communication channel.

thanx

ahmad

[Former Member · Accepted solution]

Hi,

It is possible to connect to MS-ACCESS db. Also you dont need to deploy any additional JDBC drivers to access MS-ACCESS.

JDBC Driver : sun.jdbc.odbc.JdbcOdbcDriver

Connection : jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\path\demo.mdb

Regards,

JaiShankar

[Former Member · Accepted solution]

thanx guys

appreciate ur immense help

ahmad

[Former Member · Accepted solution]

one more thing,i was goin through the blog File to JDBC /people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30 by Mr.Anirban Ghatak,its an excellant blog but i m a bit confused about the receiver datatype,my concern is why do we need an element 'action' of category 'attribute', can't we make the receiver data type same as sender data type?

thanx

ahmad

[Former Member · Accepted solution]

HI,

The JDBC adapter converts the datatype you have created in to a database request that is understood by the database. That is the reason why you create a datatype in the XML SQL fromat.

Refer this link you will understand.

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

Regards,

Sudheer.

[bhavesh_kantilal · Accepted solution]

Hi,

The receiver Datatype when dealing with databases and JDBC adapter should be of a specific format so that the data can converted into an SQL statement by the JDBC adapter.

In the case of Insertion , the format wil be like how Anirban has shown in his blog.

In the case of others, the format is on this link,

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

Meanwhile, while creating the datatype, ACTION is an attribute.

To do this, in your datatype editor, instead of clicking Insert Element, you should select INSERT ATTRIBUTE.

Regards,

Bhavesh

[Former Member · Accepted solution]

Hi Ahmad,

In receiver side, you can either select,insert or update. To specify the type of operation "action" attribute is needed.

Regards,

Uma

[Former Member · Accepted solution]

thanx guys

appreciate your help

[Former Member]

Hi,

JDBC Driver : sun.jdbc.odbc.JdbcOdbcDriver

Connection : jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ= D:\USERS\OPS\OPS.mdb ;

Regards,

Sudheer.

[bhavesh_kantilal]

Hi,

This blog has all the details,

/people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn

No need to install an External Driver for the same.

Regards,

Bhavesh