SAP and ODBC links

Can you make an ODBC link to SAP and pull data into access?

IF it is possibly, can you explain how to do it?
ssblueAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
PatHartmanConnect With a Mentor Commented:
You could if the PTB would allow it but they never will.  Linking to SAP is no different from linking to any other ODBC database.  I think Oracle is the preferred database engine these days but it could be SQL Server or DB2 depending on your installation.

When dealing with SAP, you will almost certainly have to make a request for a "report".  Then every day you can import that data to a temporary database and use it.  Of course the problem with this is it is always day old data.
1
 
Geert GConnect With a Mentor Oracle dbaCommented:
the majority will be on ms sql, oracle and db2
but the preferred database will be Hana

into access ?
you want to build a better ERP system with that ?

i know sap consultants are expensive, but the solution will be alot better than anything you can make with access

ask a sap consultant to export a csv file with the data you need
it will be less of a hassle

besides, the it department probably won't approve or allow what you want to do
1
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.