Install and configure Oracle ODBC drivers

[Professor]

Hello everyone,,
I'm having the dangedest time finding and installing the Oracle ODBC drivers. I'm trying to write a report on data that lives in our only Oracle DB. I have a working SQL statement, but I just can't figure out how to get the ODBC drivers setup.

I have the instant client downloaded and installed, but it said I need to run netca to configure the listener. I couldn't find that on Oracle's website, though; and the "client" install didn't seem to do what I needed. What am I missing?

Also, if there's an easier way, I'm all ears. I just need a way to connect Microsoft's SSRS with Oracle.

Thanks!

[RuskinF]

I can help you with connecting Microsoft SSRS with Oracle.
First, please check the edition of your SQL server 2016, if you used express, Oracle data source is not supported in SSRS because express edition only works with local data which Oracle is not.

To retrieve report data from an Oracle database, your administrator must install Oracle client tools and .NET Data Provider for Oracle. This data provider uses the Oracle Call Interface (OCI) from Oracle 8i Release 3 as provided by Oracle Client software. The client application version must be 8.1.7 or later. This data provider must be installed in the server machine (and client machine for SSDT-BI). Until it is installed in the server it will not be loaded/displayed by SSRS.