Categories
- All Categories
- 70 Oracle Analytics News
- 7 Oracle Analytics Videos
- 13.9K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 38 Oracle Analytics Trainings
- 56 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 2 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
RPD Connection TNS when multiple environments
Hi All
We have three different environments and every environment has different TNS
DEV
This is used for the development of RPD and analytics by the Software engineers
QA
This is used for the testing by quality assurance department
Production
This is used by the end users i.e. managers, supervisors etc.
Whenever we deploy RPD from one environment to another environment we have to manually change the Data source name as highlighted below.
Is there a way to define TNS at some file and RPD automatically read it?
Answers
-
If you look into the documentation you will see that Oracle has specific commands to manage this when moving from one environment to the next:
0 -
Thanks for the help, may be I am doing something wrong that's why unable to resolve the issue, After reading documents I did as following --- please highlight where I am wrong and how to use JSON file
- Write the command with datamodel.sh which open the file as shown in Fig.1, saved the file in directory without any modification
- updateconnectionpool again without any modification because there was nothing which I could understand
- I tried datamodel.cmd as shown in Fig.3, maybe this is requirement but I don't know how to use the output file.
Fig.1, listconnectionpool when written comman
Fig.2, write the updateconnection pool, it again opened the file
After fig.2, I am stuck what is the next step
Fig.3, When I write command with datamodel.cmd then below result appear in command prompt--- maybe this is my required file I can put credentials but don't know how to use
0 -
You can put your DSN entries into a repository variable called something like "DB_CONNECTION" and set it to "DEV" (or whatever the string is - I don't know your environment).
The you can just use the variables command listrpdvariables.
Then you change the JSON to say "QA" instead of DEV.
Then you run updaterpdvariables and put the new variable value in to the RPD.
Done.
That's how the process works.
And for about the 10th time: Get some proper training! It's questionable at best to work your way through things without the proper basics.
0 -
So is your question answered? Or is it still open?
0 -
Hopefully, I shall update you till monday, currently working
0 -
Still working, I shall write the complete steps once completed
0 -
That's it
0
