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!

RPD as a Data Source in Informatica

799604Feb 26 2013 — edited Feb 27 2013

I have a question. Has anyone ever tried importing the BI service as a datasource into Informatica? I'm posting the question to the Informatica community too. (OBIEE 10.1.3.4.2 & Informatica 8.1.1)
Since it's ODBC, I'm thinking there may be some flexibility. I can see the dimension objects from the RPD show like tables in a schema when importing it. However the objects are empty. No columns.

The reason why I'm attempting this is because we're trying to get to a database that cannot connect to Informatica due unavailibilty of ODBC drivers for the OS. However the db can connect to the server where the BI server resides.
Maybe I can retrieve the data from a connection pool that'll be added to the RPD. However dont expose it, but transform it (ETL) then load it to warehouse. Subsequently exposing it after it's been loaded.

Any one ever attempt something like this? (Not our first or second choice.)

Thanks,
Lael

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 27 2013

Added on Feb 26 2013

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #obiee

7 comments

612 views