Connect External Database SQL server from ABAP

[venkateswaran_k]

Dear All,

I have an requirement to fetch the data from third party application (having their data in SQL Server database).  This application is running in a different server but on a same network.  I need to fetch data and calculate some value and update in the SAP system. 

I understand that we can do it through DBCON settings at SAP end.

However, i need some clear steps and pre-requisites from BASIS side as well in order to have completeness.

  viz.  Any DLL or SAR files to be extracted

         Any settings at BASIS side to allow external connections etc

Can some one give input please.

Regards,

Venkat

[Former Member]

Check SAP Help below.

http://help.sap.com/abapdocu_702/en/abenadbc.htm

[former_member222709]

Hi Venkat,

Some simple and common info:

1. DLL files will be needed to connect to SAP and execute RFC/BAPI from the SQL system whereas DBCON will help you to define connection details of connecting to SQL DB from SAP.

OR

2. If you want to process a transaction in SAP via RFC/BAPI you will need the DLL whereas to read data or write data to SQL system then DBCON will be useful.

3. Ask the BASIS Team to verify any firewalls that may deny access to SAP IP.

Regards, Pranav.