This content has been marked as final. Show 1 reply
Hi,1 person found this helpful
I can only tell you by experience. Given the structure of JDE tables, it's quite hard to map a BI business model (star-schema based) and have it work with decent response times when data is queried - this is valid even if you don't take the database (Oracle, DB2, etc) into account. In my experience, directly mapping the JDE tables in OBIEE works properly only on very limited subject areas. For example, we mapped a very small subject area built around the customer ledger table - but, for example, we had to build a dimension table from a number of JDE tables because otherwise the performance was very very poor. As a matter of fact, in this case we built a solution based on a mixed approach: direct access to JDE tables + access to ad-hoc tables when needed.
Generally speaking, consider to have an ETL based approach.
Should you consider to directly map JDE tables, I suggest you to carefully specify database source and connection pool details.
Hope this helps,
Edited by: 820782 on Jan 31, 2013 3:59 PM