Oracle Driver Installation for SSIS, SSRS & Power BI Connectivity with Oracle Database Server.

How to Connect SSIS, SSRS and Power BI Server to Oracle DB Server using Oracle Drivers?

Installation of oracle driver is Little bit tricky but you can install it by following below steps for Oracle driver Installation:

Step 1: First, you have to remove the Oracle driver which you have installed in the system previously.

Step 2: After that reboot system.

Step 3: Download this setup from Oracle WebSite:

https://www.oracle.com/database/technologies/oracle18c-windows-180000-downloads.html(32 or 64 bit any one of this will work).

Kindly Note That Visual Studio is require for proper installation of oracle drivers

I have downloaded setup file and i have kept it on my server. You can download the setup file and keep it in  your system anywhere you like.

Step 4: After executing the setup.exe, following cmd screen will be shown. Let the process complete, it will go ahead automatically.

Step 5: Select the language accordingly.

Step 6: Create a folder in C Drive as ORACLE32(for 32bit) or ORACLE64(for 64bit)

Select the following location in Oracle Base and then it will automatically set location for Software location directory based on the Oracle base location provided.

Step 7: Select user as required. I will select Windows Built-in Account.

Step 8: Select the features required. Mostly select all except the sample ODAC files.

Step 9: In this step, you may be asked to setup Visual Studio before going ahead.This visual studio error can also occur after the setup of SSDT. There is a different visual studio setup available for this.

Do the visual studio setup and re-run this setup again , the error wont be available

.

Step10: Pre-requisite checks

Step 11: Summary

Step 12: After the installation completes, visit the following link :

https://docs.microsoft.com/en-us/sql/reporting-services/report-data/oracle-connection-type-ssrs?view=sql-server-ver15


Follow step mention in above link for SSRS, SSIS & Power BI Server for oracle driver configuration or just follow Step 13 mention below 

Step 13: Perform this steps after oracle client setup.

This concludes the Oracle 18c Client Setup.After this try  to connect with Oracle database from SSIS, SSRS and Power BI Server.

I hope this article was helpful to you in the oracle driver configuration.If you have any issues kindly mention in the comment and I will try to solve your problem.