SQL Server Analysis Services with Oracle

  • 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

  • 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.

  • 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.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply