Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

MS Project data in OBIEE 11G

Received Response
11
Views
2
Comments
User_BKM1E
User_BKM1E Rank 1 - Community Starter
edited August 2024 in Oracle Analytics Cloud and Server

I need to show MS Project data in OBIEE 11G. but i am unable to find any odbc driver or any direct connect procedure of MS Project connection with BI.Is MS project data presenatation is possible in OBI or not?

Please guide.

Tagged:

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    There isn't a MS Project native connector in OBIEE.

    If MS Project has an ODBC driver, setup the connection (depends on the OS your OBIEE is installed on) and inside the RPD you will be able to use that connection. Of course OBIEE expect that ODBC driver to speak a standard query language, so as long as the driver can reply to SELECT queries you will get something.

    But out of the box there isn't anything and even with an ODBC connection OBIEE will have no knowledge about your MS Project: it will be a totally anonymous random ODBC source.

  • Joel
    Joel Rank 8 - Analytics Strategist

    There does appear to be an ODBC driver that can hook up to MS Project as @Gianni Ceresa mentioned earlier - https://marketplace.visualstudio.com/items?itemName=CDATASOFTWARE.MSProjectODBCDriver