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

121,875 total views, 8 views today

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

facebook comments:

4 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

  3. daftar Sabung ayam s128 says:

    Valuable information. Fortunate me I discovered your web site unintentionally,
    and I am surprised why this accident didn’t came about earlier!

    I bookmarked it.

  4. Vincent says:

    Please let me know if you’re looking for a article writer for your site.
    You have some really great posts and I think I would be a
    good asset. If you ever want to take some of the load off, I’d absolutely
    love to write some material for your blog in exchange for a link back to mine.
    Please blast me an e-mail if interested. Kudos!

Leave a Reply to daftar Sabung ayam s128

Time limit is exhausted. Please reload CAPTCHA.