Solved

SAP and ODBC links

Posted on 2016-08-19
2
153 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 37

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Azure Functions is a solution for easily running small pieces of code, or "functions," in the cloud. This article shows how to create one of these functions to write directly to Azure Table Storage.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

688 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