Feb 12 2014

Create DB Connection From SAP to External Databases

Category: SAP BasisFatih Acar @ 15:16

That scenario is required that we need to fetch data from the customer’s existing third party application. For example the customer is having some websites where the enquiries are being stored. Or The company employees who are on tour log their requests for leave in the portal. In such case we may have to provide an interface between their existing application to the upcoming SAP system. It is possible that the system is using a different database altogather. So in that situation how a connectivity is established between the SAP database and External Application database.

You can create connection to external database with below processes.

1 – Connection check from SAP to External Database

You have to access external database from SAP network. You can check firewall, telnet configuration.


2 – Create Database Connection on SAP

Tcode > DBACOCKPIT

Also you can use DBCO tcode to create connection.

SAP Externel DB Connection 1

SAP Externel DB Connection 1

SAP Externel DB Connection 2

SAP Externel DB Connection 2

SAP Externel DB Connection 3

SAP Externel DB Connection 3

You can test connection. If you get an error like ORA-28547 because of database NLS Charactersets are not match. You have to install oracle instant client full version on SAP system. You have to download from SAP web site. After you installed oracle client full version, you can connect to database without error.

SAP Externel DB Connection 4

SAP Externel DB Connection 4

108,625 total views, 30 views today

Tags: SAP Basis, SAP DBCO Connection, Sap System Administration, System Administration

facebook comments:

2 Responses to “Create DB Connection From SAP to External Databases”

  1. ben says:

    Hello, we are now connect configuration and you the same question, don’t know you is how to solve?

  2. Juan Manuel Naranjo A. says:

    Hello:

    We would like to know if we can create a connection to an external MySql Database using transaction DBCO or DBACOCKPIT.

    Regards

    Juan

Leave a Reply

Time limit is exhausted. Please reload CAPTCHA.