Connecting SSRS 2016 to Oracle 12C

• Andrew McGimpsey

  SSC Veteran

  Points: 227

  More actions

  October 6, 2016 at 3:09 am

  #330329

  Hi folks,

  We are looking at providing dashboard and reporting functionality in our application using SSRS 2016. The application data we would be reporting on is sitting within Oracle 12C. Looking at the relevant MSDN page on SSRS connectivity, I can't seem to see any mention of 12C...

  https://msdn.microsoft.com/en-gb/library/ms159219.aspx

  Does anyone know if this is possible?

  Thanks in advance for any replies.

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  October 6, 2016 at 3:08 pm

  #1905278

  You need to install ODAC 12c for your environment to get the latest drivers.

  Here is a walkthru on doing it for a 64-bit SQL:

  https://blogs.msdn.microsoft.com/dbrowne/2013/10/02/creating-a-linked-server-for-oracle-in-64bit-sql-server/

  Sue