Analytics 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!

How to configure ODI 11.1.1.9 topology to fetch data from microsoft analysis services?

BlueHorseOct 10 2017 — edited Nov 10 2017

Dear ODI Community Experts

I have a requirement to use ODI 11.1.1.9 to connect and read data from microsoft analysis services (OLAP CUBE MDX).

The only information I have is the address as follows:

[Provider=MSOLAP.4;Password=@pwdxxx@;Persist Security Info=True;User ID=.\Client_mmb; Initial Catalog=ANALISISXXX; Data Source=200.201.202.203; MDX Compatibility=1;Safety Options=2;MDX Missing Member Mode=Error]

* not is cloud microsoft!.

I could not figure out how to configure this topology in my ODI while I searched these forums.

So, I turn to you for a solution to map this topology and reverse engineer it.

My only intention is to read data from the olap cube (mdx).

Thanks for any suggestion or clue

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 8 2017

Added on Oct 10 2017

#business-intelligence-applications, #data-integrator, #odi, #system-management-and-integration

5 comments

353 views