This discussion is archived
5 Replies Latest reply: Apr 2, 2013 10:48 AM by Ahsan Shah RSS

OBI APPS for DB2 and SQL

user8819264 Newbie
Currently Being Moderated
Hi all

I understand Bi Apps is a set of standard predefined reports for different modules of diffrent ERPs like Oracle EBS, JD edwards, peoplesoft etc. I have seen on the compliance matrix Non Oracle db's like IBM DB2, Mircrosoft SQL etc are also supported. I would like to Know how these are supported for BI Apps standard reports as the underlaying data on this may not be of above supported applications. And the predifined ETL(informatica mappings may not match to the tables of these source Db's.

Thanks for your Guidance
  • 1. Re: OBI APPS for DB2 and SQL
    Ahsan Shah Expert
    Currently Being Moderated
    The "Tables" will be the same for the applications across the DB platforms (Oracle, DB2, etc). Informatica SQL is ANSI based so it is agnostic of the actual platform. Essentially, as long as the ERP systems are available on multiple DB platforms, OBIA will extract in the same manner (you just have to define the platform on the ETL SDE extractors). The DB platform does not change the ERP tables as far as I know.

    Pls mark correct..
  • 2. Re: OBI APPS for DB2 and SQL
    Abe Newbie
    Currently Being Moderated
    Thanks For your reply.

    Based on this, i understand that OBI Apps works only on below applications (As given on matrix for 7.9.6.3) with different supported database type specified on the matrix.

    1. EBS
    2. Siebel
    3. JD Edwards Enterprise One
    4. JD Edwards World
    5. PeopleSoft

    Am i right?. Kindly suggest.

    Thanks
  • 3. Re: OBI APPS for DB2 and SQL
    Ahsan Shah Expert
    Currently Being Moderated
    The cert matrix is the best resource...yes. However, these are NOT the only ERP systems OBI Apps has adaptors for. There are also adaptors for SAP, RETEK, Maximo and other systems on other versions of OBIA.

    pls mark correct...
  • 4. Re: OBI APPS for DB2 and SQL
    user8819264 Newbie
    Currently Being Moderated
    Thanks Ahsan.

    Can you give me the link for latest matrix for OBI apps. I couldn't find it on my googling

    Thank you so much
  • 5. Re: OBI APPS for DB2 and SQL
    Ahsan Shah Expert
    Currently Being Moderated
    Here you go:

    http://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&cad=rja&ved=0CDMQFjAA&url=http%3A%2F%2Fwww.oracle.com%2Ftechnetwork%2Fmiddleware%2Fbi-applications%2Fbiapps7964cert-matrix-1891451.xls&ei=uRlbUbaELOit0AGe4oCAAQ&usg=AFQjCNFpBX79KDDbfKsXqW3pL5RQgknnfQ&sig2=oxYbYn99i-0GorggTe49ow&bvm=bv.44697112,d.dmQ

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points