7 Replies Latest reply on Mar 6, 2019 2:26 PM by Christian Berg

RPD Connection TNS when multiple environments

Rai Qaiser Hussain Feb 27, 2019 5:09 AM

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

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?

1. Re: RPD Connection TNS when multiple environments

Christian Berg Feb 27, 2019 7:38 AM (in response to Rai Qaiser Hussain)

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
Like Show 0 Likes(0)

Actions
2. Re: RPD Connection TNS when multiple environments

Rai Qaiser Hussain Feb 27, 2019 2:35 PM (in response to Christian Berg)
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

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
Like Show 0 Likes(0)

Actions
3. Re: RPD Connection TNS when multiple environments

Christian Berg Feb 27, 2019 6:03 PM (in response to Rai Qaiser Hussain)

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.
1 person found this helpful
Like Show 0 Likes(0)

Actions
4. Re: RPD Connection TNS when multiple environments

Christian Berg Feb 28, 2019 2:56 PM (in response to Rai Qaiser Hussain)

So is your question answered? Or is it still open?
Like Show 0 Likes(0)

Actions
5. Re: RPD Connection TNS when multiple environments

Rai Qaiser Hussain Mar 1, 2019 6:37 AM (in response to Christian Berg)

Hopefully, I shall update you till monday, currently working
Like Show 0 Likes(0)

Actions
6. Re: RPD Connection TNS when multiple environments

Rai Qaiser Hussain Mar 6, 2019 1:03 PM (in response to Rai Qaiser Hussain)

Still working, I shall write the complete steps once completed
Like Show 0 Likes(0)

Actions
7. Re: RPD Connection TNS when multiple environments

Christian Berg Mar 6, 2019 2:26 PM (in response to Rai Qaiser Hussain)

That's it
Like Show 1 Likes(1)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.