Connecting SAP on Microsoft SQL to an External Oracle Database Server

During a recent bit of consulting I was asked to connect SAP to various External Databases. SAP impressed me with its Multi-Connect feature and I thought it worthy of a couple of quick videos.

If you’re already running SAP on Oracle then you can skip to Step 5

Step 1: Download the database library. Under Kernel Patches and make sure you select the database version you want to connect to in this example Oracle.
Matt Bartlett
Matt Bartlett

Step 2:
Unpack and copy the library itself dboraslib.dll to your application instances kernel folders. In the video I leveraged the instance.lst file to get SAP to do this for me as part of the SAP startup sapcpe process.

Step 3: Download and unpack the Oracle Client Tools
Matt Bartlett

Step 4: Install the Client Tools. Select Runtime or Administrator
(InstantClient on its own is not enough)Matt Bartlett

Step 5: Configure Oracle Net Manager to point to our External Oracle ServerMatt BartlettAs the client tools are installed its very simple to test the connection using tnspingMatt Bartlett

Step 6: In SAP transaction SM30 table maintenance for DBCON. Add the connection using the connection name we just created in Oracle Net Manager.Matt Bartlett

Step 7: Code away. You can download my sample ABAP program here.

If you’re looking for this the other way around connecting from Oracle to Microsoft SQL see – http://www.mattbartlett.co.uk/connecting-sap-on-oracle-to-an-external-microsoft-sql-db

Chapter 8 of SAP Administration – Practical Guide contains more information about how to configure database connections:

 

 

2 thoughts on “Connecting SAP on Microsoft SQL to an External Oracle Database Server

  1. Thanks Matt,
    We have already connected to external SQL Server using DBCON. However, we were looking for connecting to external Oracle Database through our SAP which is on SQL.
    Your document proved to be a exact guide to us.
    Thanks again.
    Regards,
    Firoz.

  2. Thanks Matt,
    We have already connected to external SQL Server using DBCON. However, we were looking for connecting to external Oracle Database through our SAP which is on SQL.
    Your document proved to be an exact guide to us.
    Thanks again.
    Regards,
    Firoz.

Leave a Reply to Firoz Cancel reply

Your email address will not be published. Required fields are marked *