SQL Server Analysis Services with Oracle

• oana_zvincu

  SSC Veteran

  Points: 223

  More actions

  April 6, 2011 at 2:23 am

  #389211

  Hello there,

  I'm new on this forum, so nice to meet you all:-).

  Now, I have a huge database implemented using Oracle 11g. I also started learning Microsoft SQL Server Analysis Services in order to generate dynamic reports. Can you please tell me if it is possible for me to integrate Oracle with SQL Server analysis services? If so, please tell me how can I integrate these two.

  Thank you,

  Oana

• DNA_DBA

  SSCrazy Eights

  Points: 9144

  More actions

  May 6, 2011 at 3:25 pm

  #1321324

  This can be done directly by creating a data source against the Oracle database. You'll need to install some Oracle drivers on your Analysis Services server first - these can be downloaded from the Oracle web site (eg: Oracle Provider for OLE DB).

  You can then access the data in Oracle either through views or the tables. Alternatively you could create the datawarehouse in SQL Server and pull the required data from Oracle using SSIS.

• PaulB-TheOneAndOnly

  SSC Guru

  Points: 66772

  More actions

  May 8, 2011 at 8:26 am

  #1321461

  Agreed. SQL Server Analysis Services integration with Oracle is a well documented subject.

  You may want to start by checking Microsoft documentation on the matter, like... http://technet.microsoft.com/en-us/library/aa964120(SQL.90).aspx

  _____________________________________
  Pablo (Paul) Berzukov

  Author of Understanding Database Administration available at Amazon and other bookstores.

  Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.