topic Connect External Database SQL server from ABAP in Application Development and Automation Discussions

Connect External Database SQL server from ABAP

venkateswaran_k — Thu, 31 May 2012 15:49:18 GMT

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

Re: Connect External Database SQL server from ABAP

Former Member — Thu, 31 May 2012 15:58:38 GMT

Check SAP Help below.

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

Re: Connect External Database SQL server from ABAP

former_member222709 — Fri, 01 Jun 2012 05:06:59 GMT

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.

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.