Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

DSN connection across different environments

Hie Guys,

A database has 3 different servers for DEV, TEST & PROD. Now, while creating a DSN for the Universe, do you have to create a DSN for each environment (Dev, Test & Prod) ? How does this work? Could anyone please help me understand the concept? Thanks.

Former Member
replied

Hi

If you have three SQl servers (Dev,Test,Prod ) and three bo servers (Dev,Test,Prod )   you need to create three different DSN connections in Dev SQL.

IN THE DEV SERVER

1. Create DSN connection (Dev DSN Connection) in  the Dev SQL to connect Dev SQL to BO Dev and then develop the universe.

2. Create another DSN connection (Test DSN Connection)  in the Dev SQL to connect Test SQL to Test BO Dev

3. Create another DSN connection (Prod DSN Connection)  in the Dev SQL to connect Prod SQL to Prod BO Dev

Then while promoting to Test environment, you need to send universe along with connection, but in the connection you need to change the Dev SQL connection to Test SQL connection ((Test DSN Connection)  (Select the connection -> Click on change connection)

Then while promoting to Prod environment, you need to send universe along with connection, but in the connection you need to change  to Prod SQL connection (Prod DSN Connection) 

And once the universe and connection are promoted successfully come back to Dev and change the connection to Dev SQL (Dev DSN Connection)

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question