RPD Connection TNS when multiple environments

Rai Qaiser Hussain

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?

Christian Berg-0racle

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:

https://docs.oracle.com/middleware/12212/biee/BIEMG/GUID-42FA5E06-F29B-411D-9424-3276368F7188.htm#conn_list_pool_cmd

https://docs.oracle.com/middleware/12211/biee/BIEMG/GUID-13B665FC-46BA-4356-A777-08FB484BBB5C.htm#list_repos_var_cmd

Rai Qaiser Hussain

Hi @Christian Berg

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

1. Write the command with datamodel.sh which open the file as shown in Fig.1, saved the file in directory without any modification
2. updateconnectionpool again without any modification because there was nothing which I could understand
3. 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

Christian Berg-0racle

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.

Christian Berg-0racle

So is your question answered? Or is it still open?

Rai Qaiser Hussain

Hopefully, I shall update you till monday, currently working

Rai Qaiser Hussain

Still working, I shall write the complete steps once completed

Christian Berg-0racle

That's it