JDBC connection to ODBC connection

[Former Member]

Hi Experts,

We have a requirement as follows:

A legacy system which is a database system. Data is store in structured files. We need to send data from the legacy system to XI and back to SAP. For this, we will access this by an ODBC connection from XI.

Can anyone tell me, in order to do so, can we do a JDBC connection to ODBC connection? Please explain if this is possible or provide us with a solution to achieve this requirement.

Thanks in advance.

Best regards,

Tushit

[Former Member]

ignore my previous post, my thoughts is other way around.

Mybe you need to explore the possibility of using file adapter, usually legacy system can export data to files,

Liang

Edited by: Liang Ji on Feb 21, 2008 8:02 PM

[Former Member]

Hi, Tush:

I believe that right way to achieve your requirment is using ABAP proxy.

An ABAP report needed to read your structured file contents, maintain a intertal table to get all the values. then

call the method execute_asynchronous of the proxy, send message to XI integration engine to do a mapping or routing.

Regards !

Liang

[Former Member]

Hi Tushit,

JDBC is fine for ur Legacy System.

But why u want to use ODBC for SAP??

U can use IDOC or RFC or Proxies.

Thanks,

Maheshwari