Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
Ranjith418
Contributor

I will explain step by step procedure to create a DB connect connection from SAP BW to external oracle database.

We can have different external database connection to BW like oracle, SQL, DB2, SAP DB etc.

Go to Rsa1 tcode in the BW system as below

Go to source systems in left pane and do right click and click create

Select database system as below

Go to Bd54 tcode

Create logical system similar to highlighted one below. This logical system is a reference and will be used in RSA1 tcode.

Give MPTORA(which ever logical system related to the scenario) in logical system and source system description in RSA1.

and we get below screen

Fill details like DBMS will be ORA for oracle or MSS for SQL server etc

user id and password we can get it from BW team or from the requester. This user id and password will be used to lo-gin to the external database.

connection info field will contain the parameter to be used while connecting to the external database.

we need to maintain the details in tnsnames.ora file under /oracle/SID/112*/network/admin. Sample tns file below.

Save in above screen and go back

Hit back in above screen

Source system connection created. Right click and do test, the result should be success.

Possible errors:

1. When tnsnames.ora file is not maintained, we will get below error

Connection info was not maintained so got the above issue.

2. If the user id and password is wrong, we will get below error.

2 Comments
Labels in this area