?
Solved

SAP and ODBC links

Posted on 2016-08-19
2
Medium Priority
?
160 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 38

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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
In this article, we’ll look at how to deploy ProxySQL.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

741 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