DSN connection across different environments
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.
Sreenivasulu Dasari replied
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)