Solved

SAP and ODBC links

Posted on 2016-08-19
2
116 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 35

Accepted Solution

by:
PatHartman earned 250 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 37

Assisted Solution

by:Geert Gruwez
Geert Gruwez earned 250 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

777 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