cancel
Showing results for 
Search instead for 
Did you mean: 

Connecting R/3 tables using oledb/odbc from SQL/Access

Former Member
0 Kudos

Hi at all!

How and what I need to connect to R/3 database and run queries from SQL/Access?

Thanks

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

did anybody tried to etablish a own enterprise service registry and use it with the ese? what is needed to get it online? I would like to use custom developed webservices from our sapteam.

regards,

Stefan Seeland

Edited by: Stefan Seeland on Sep 22, 2008 5:33 PM

Former Member
0 Kudos

Hi,

I don't think that connecting directly to the SAP database is the way to go, it's also unsupported by SAP from what I know.

Instead of this use Web Services or the SAP Connector for Microsoft .NET or Enterprise Services or XI/PI or BizTalk or ... and read the data out by using standard SAP interfaces like BAPI, RFC, or Enterprise Services and store the information in SQL/Access. You can also use the .NET Data Provider for SAP Businss Suite and SQL Server Reporting Services or in case you want to connect to SAP BW the .NET Data Provider for NetWeaver BI in order to read data out of SAP and store it in SQL Server for further reporting.

- Juergen

Edited by: Jürgen Daiberl on Sep 8, 2008 3:05 PM