SAP ODBC driver

[toon10]

Hi

I'm a visual basic programmer (for my sins) and at present, all my applications that rely on SAP data are coming via a text file. Basically, the user has to run a SAP transaction to export the file and then when my apps are running, import the text file before the data can be used. This works but obviously as the data is not live, it relies on the users making regular exports and imports from SAP to my apps.

Is there an ODBC driver available for SAP which means I can map to the live SAP data via apps? Are there any potential problems with doing so?

Thanks
Andrew

 

[hoinz]

Hi,

I don't think that there is an ODBC driver available for SAP.
But I am sure there is an ODBC driver available for the database your SAP is sitting on. This can be Oracle, or MS SQL, or ...
You may access your transparent SAP tables by database tools. Unfortunately this does not apply to cluster tables.
SAP recommends to use ODBC only for reading, but not for writing data to your system.
For further information have a look at SAP note 81854.

hope this helps

 

[toon10]

Thanks for replying.

All I need is a read only connection to get data out. I'll look into it.

Thanks again
Andrew

 

[DaOtH]

Toon
Take a look at the 4BAPI Reader, might be useful or at least give you a direction.

I chose(was not allowed actually) not to use it.
Main reason was that their is no direct control out of SAP on when and how much data is pulled out.

WHat i now do is teaming up with SAP Business Warehouse.
SAP R/3 updates BW, and consequently i run BW web templates that are downloaded to a server with the BW Download manager.

After that i import them into the database (SQL 2000 in my case).

Hope it helps.

"In three words I can sum up everything I've learned about life: it goes on."
- Robert Frost 1874-1963

 

[DaOtH]

Sorry, 4BAPI Reader or S4U Connector can be found at

https://www.software4you.com/

"In three words I can sum up everything I've learned about life: it goes on."
- Robert Frost 1874-1963