Where I need to deploy my RPD

Question

Hello Experts,

I need one guidance as below (I am not expert in OAC):

I have my data warehouse/data mart layer on Server A and OAC on server B.

I guess I have to  deploy my RPD (physical layer needs to point to tables in data mart at server A) at server B only and point to Server A with connection pool?

I guess I can not deploy RPD unless OAC is installed at server A.

Thanks,

Gianni Ceresa · Answer

Actually, not sure your option 2) really works with OAC. I don't have an OAC up and running right now to test, I know that the "downloadrpd" parameter does work, but the upload maybe doesn't because you will not know all the parameters to use. Still not a big deal as there are the other 2 ways: via the admintool directly or via the console in OAC.

Gianni Ceresa · Answer

And the doc says you can also do it via the console in OAC, the 3 ways should work and will do the same job.

Option 2) can be performed by your own local laptop/desktop PC where you installed the Admin tool: it comes with datamodel.cmd

Try it and you will see if all works. But as you have alternative methods, not a big deal...

Sangeeta Pandey · Answer

https://community.oracle.com/tech/apps-infra/discussion/comment/16804326#Comment_16804326

Thanks Gianni, this is very useful.

last question-

I can upload/deploy RPD at OAC by both means as below?

1) Connect through client tool and upload as you mentioned above.

2) Deploy/upload in offline mode like below:

./datamodel.sh uploadrpd -I /tmp/rpd/oha-3.19.1.0.0.rpd -W .........................

I guess only thing is that we need access to OAC server to be able to opt for option 2?

Thanks