Access SAP Database Tables

[Former Member]

Hello SAP Gurus,

We use SAP 6.0 as our accounting system and will be creating custom reports in SQL for internal reporting purpose. Is there a way we can create a direct interface between SAP and SQL by pulling database tables from SAP?

Thank you in advance. I appreciate your time.

Jay

[former_member184473]

Hello Jay,

If your system has ABAP stack you can use DBCON and if it is Java only you can use UDConnect.

Check note 1601608 for further information.

Regards,

Eduardo Rezende

[former_member188883]

Hi Jay,

It should be possible through remote database connection configuration.

What is the database on which SAP is running ?

Regards,

Deepak Kori

[Former Member]

Hi Deepak,

Thank you for prompt reply. Our SAP database system is MS SQL and release version is 10.00.1787

Please let me know the next steps and if I have to set-up remote database connection configuration.

Thanks,

Jay

[former_member188883]

Hi Jay,

Refer the link below to setup remote database connection in MSSQL

http://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server...

Hope this helps.

Regards,

Deepak Kori