SQL server 2014 MultidimensionalProject with oracle database

• vijay.1794

  SSC Journeyman

  Points: 80

  More actions

  February 16, 2015 at 4:33 am

  #398022

  Hi All,

  I am very new to sql server and SSDT.

  I need to create reports for the application that build in ORACLE database. I have installed the oracle client in the server but now we needs to connect the oracle database for the analysis services(MultidimensionalProjecs).

  I am using SQL server 2014 and oracle 11g as database.

  I have created the data source for the busniess intelligence--> report server project but not able to create data source for the analysis services, kindly help with your inputs.

  Thanks

  Vijay Verma

• vijay.1794

  SSC Journeyman

  Points: 80

  More actions

  February 16, 2015 at 5:47 am

  #1777799

  Hi All,

  I got the solution.

  Provider : Oracle Provide for OLE Db.

  In server name instance name of Oracle dabase.

  provide username and password to connect with the dabase..

  Go for test connection.

  Done.:-)

  Thanks

  Vijay Verma