Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SAP ODBC driver

Status
Not open for further replies.
toon10

toon10

Programmer
Joined
Mar 26, 2004
Messages
303
Location
DE
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
 
Sort by date Sort by votes
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
 
Upvote 0 Downvote
Thanks for replying.

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

Thanks again
Andrew
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
Sorry, 4BAPI Reader or S4U Connector can be found at

"In three words I can sum up everything I've learned about life: it goes on."
- Robert Frost 1874-1963
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

dgillz
  • Locked
  • Question Question
SAP Business One version 9.00.058 - What database?
Replies
0
Views
466
dgillz
dgillz
charbrad
  • Locked
  • Question Question
SAP 4.0B
Replies
0
Views
450
charbrad
charbrad
careymw
  • Locked
  • Question Question
SAP Business Objects Platform 4 - Information Design Tool Question
Replies
0
Views
427
careymw
careymw
Checking
  • Locked
  • Question Question
ODBC Driver needed to connect SAP (residing MSSQL Server) to MSACCESS
Replies
0
Views
432
Checking
Checking
jeneci0
  • Locked
  • Question Question
SAP VIM by OpenText
Replies
0
Views
550
jeneci0
jeneci0

Part and Inventory Search

Sponsor

Back
Top