Skip to Content
avatar image
Former Member

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

Hi at all!

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

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Sep 08, 2008 at 10:03 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 22, 2008 at 03:28 PM

    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

    Add comment
    10|10000 characters needed characters exceeded