topic Re: Oracle Direct Query - Couldn't Connect in Report Server

Oracle Direct Query - Couldn't Connect

Anonymous — Sun, 04 Oct 2020 09:32:37 GMT

Hi Guys,

I have to fetch the Data from oracle Data base(Direct Query ), so installed ODAC in PBI front end server and Connected to Oracle its working fine in Desktop but not is Power Bi report server portal.

I Have connected by using below string. please assist me to connect from PBIRS

IP:Port/service Name

Thanks,

Rav

Re: Oracle Direct Query - Couldn't Connect

Anonymous — Sun, 04 Oct 2020 15:26:29 GMT

Please find following

https://docs.microsoft.com/en-us/sql/reporting-services/report-data/oracle-connection-type-ssrs?view=sql-server-ver15#64-bit-drivers-for-the-report-servers

Re: Oracle Direct Query - Couldn't Connect

sevenhills — Tue, 06 Oct 2020 20:36:45 GMT

Assume, you have installed the Oracle drivers (if not, a bunch of to do list - https://docs.microsoft.com/en-us/sql/reporting-services/report-data/oracle-connection-type-ssrs?view=sql-server-ver15)

Install the software "Oracle Client" / Drivers
Configuration for the database (tnsnames.ora).
Ping the oracle server from PBIRS server
Use the username and password to access the database.
Optional: RDP to PBIRS and use the Power BI Desktop of PBIRS version and try to make connection

Typical connection string in the data source

DATA SOURCE=<Data source name>

Optional: You can also try the below in the connection string:

Data Source= (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=<HOSTNAME>) (PORT=1521))
(CONNECT_DATA= (SERVICE_NAME=<SERVICENAME>) ) )