April 6, 2011 at 2:23 am
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
May 6, 2011 at 3:25 pm
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.
May 8, 2011 at 8:26 am
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy