topic Re: Connect to Oracle 12c with Scheduled refresh in Report Server

Connect to Oracle 12c with Scheduled refresh

Anonymous — Thu, 04 Feb 2021 18:38:14 GMT

For Power BI Report Server, has anyone made a Power BI viz that connects to Oracle and successfully put in a scheduled refresh? If so, what does the connection string look like?

Re: Connect to Oracle 12c with Scheduled refresh

lbendlin — Fri, 05 Feb 2021 18:40:16 GMT

We use TNSNAMES.ORA (same on all gateway cluster members) and then the connection string is simply the TNS entry.

Re: Connect to Oracle 12c with Scheduled refresh

Anonymous — Fri, 05 Feb 2021 18:43:41 GMT

Just to be clear lbendin, in the Connection String text box, the only thing in there is the tns entry. Nothing else. Correct?

Re: Connect to Oracle 12c with Scheduled refresh

lbendlin — Fri, 05 Feb 2021 19:25:34 GMT

correct

Re: Connect to Oracle 12c with Scheduled refresh

josef78 — Fri, 05 Feb 2021 23:05:09 GMT

Yes, it is depends what connector you are used.

If you are using "Oracle database" you must install Oracle ODAC component on RS server (ODP.NET 4).

In connection string you can use same string as you using in tnsnames. Or you can use only tns alias, in this case you must defined TNS_ADMIN enviroment variable pointing to directory of your tnsnames.ora