Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Microsoft SSAS and Oracle

725004Apr 16 2010 — edited Jan 13 2012

I have to build a data warehouse that brings about quick benefits realization. Though we are evaluating enterprise class EDW/ETL/BI tools and methodologies, we have an immediate need to deliver a simple data warehouse to the business. I am looking to utilizing what we already own in our environment - Oracle RDBMS, Microsoft SQL Server etc. My current plan is to use Microsoft's SSAS [sql server 2008] to connect to a central data repository on an Oracle 11g database. The data source will be the Oracle database and I will use SSAS as the tool to build OLAP cubes. Is this a recommended approach? Has anybody done this?

Also, I would like to store the Cube and aggregations in one source - Oracle. I understand that ROLAP might be slow and have other disadvantages compared to a MOLAP or HOLAP, but at this time we do most of our application development with Oracle being our underlying data repository. I would like to utilize SSAS to quickly build a cube and then store the results in the Oracle database. What issues do you see with this approach? Also, are there any white papers or books on SSAS working with Oracle.

Any help would be highly appreciated.

Thank you!

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 10 2012

Added on Apr 16 2010

#and, #data, #data-warehousing, #olap, #oracle

5 comments

4,441 views