Where I need to deploy my RPD

Sangeeta Pandey

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

As you are talking about OAC (a cloud product), what is "Server A"? It's a database of some kind, ok, but what exact kind of database and where is it?

Keeping it short, you can't install OAC on "Server A", mainly because you don't decide where to install OAC: you ask for an instance and you receive the instance. You don't have access to the server where it runs etc.

But if your sources are accessible directly (either publicly or via private network in the cloud), there isn't a problem, just configure the connection pools with the correct connection string.

If your sources aren't directly accessible as "a source" (database connection for example), you need to use another component acting as gateway.

Have a look at https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsds/connect-premise-data-sources.html

Sangeeta Pandey

https://community.oracle.com/tech/apps-infra/discussion/comment/16804304#Comment_16804304

Thanks Gianni for your help.

Data Mart/Physical tables are on Oracle 19c Data base at one linux server which is directly accessible as it is part of same cloud region. Only thing is that it is different server/host. I have OAC instance on cloud as well. My requirement is to generate all kind of reports (BIP, BI Ansers and DV) using this OAC instance and data sourced from the Data Mart. I have one RPD created using tables in data Mart. I need to base my all kind of reports on this RPD. I know that I need to deploy RPD first to be able to start using it.

I guess I can deploy RPD only at server where OBIEE/OAS/OAC is installed ?

Is that correct?

In my case there is no OBIEE and no OAS but it is OAC instance.

Where and how can I deploy my RPD?

Thanks,

Gianni Ceresa

The RPD is a piece of OAC, so it can only be deployed in OAC and not in any kind of database.

For the how, the doc covers all that.

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsmd/upload-data-models-file-rpd-using-console.html

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsmd/upload-data-model-cloud.html

Sangeeta Pandey

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

Gianni Ceresa

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...

Gianni Ceresa

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.