Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SAP and ODBC links

Posted on 2016-08-19
2
Medium Priority
?
181 Views
Last Modified: 2016-08-20
Can you make an ODBC link to SAP and pull data into access?

IF it is possibly, can you explain how to do it?
0
Comment
Question by:ssblue
2 Comments
 
LVL 40

Accepted Solution

by:
PatHartman earned 1000 total points
ID: 41763001
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
 
LVL 38

Assisted Solution

by:Geert Gruwez
Geert Gruwez earned 1000 total points
ID: 41763169
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

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question