Aggregation Manager support ORACLE

Topics: Resolved
Feb 25, 2010 at 3:25 PM

Does Aggregation Manager support ORACLE to add Aggregation from Query Log?

Did I check the documentation? No, I was unable to locate it?

Did I check the forum? Yes, the latest was 2007 about dimension health check, where it says it will support Oracle, is this the same?

Did I try connecting? Yes, I am unable connect to ORACLE, I receive a unable to connect network error.

 

Thank you very much for your time and help.

 

Nick

Coordinator
Feb 25, 2010 at 4:01 PM

Note the following quote at this link: http://msdn.microsoft.com/en-us/library/cc917676.aspx

"Note: Although the dialog box does not prevent you from pointing to another relational database, the only supported database type is SQL Server."

So I don't think SSAS supports putting a query log in Oracle.

As far as BIDS Helper, we have never tested it, so it probably doesn't work. Aggregation Manager is completely different from Dimension Health Check, so don't assume that just because Dimension Health Check supports Oracle that Aggregation Manager will.

Sorry. I would suggest you copy those rows into a SQL Server table.