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 2
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
123,155 total views, 4 views today
Follow
April 14th, 2015 04:11
Hello, we are now connect configuration and you the same question, don’t know you is how to solve?
January 24th, 2017 23:58
Hello:
We would like to know if we can create a connection to an external MySql Database using transaction DBCO or DBACOCKPIT.
Regards
Juan
October 9th, 2018 00:30
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.
February 23rd, 2019 05:25
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!