×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

SAP ODBC driver

thread649-1109060

SAP ODBC driver

SAP ODBC driver

(OP)
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

RE: SAP ODBC driver

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

RE: SAP ODBC driver

(OP)
Thanks for replying.

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

Thanks again
Andrew

RE: SAP ODBC driver

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

RE: SAP ODBC driver

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login
Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close