3 Replies Latest reply: Mar 25, 2013 11:20 AM by Bruno Condemi RSS

    E1 Data Access Driver suitability for BI Applications

    Shoaib Javed
      Hi

      I am trying to access data from E1 data source for bulk loads into Endeca (For BI purpose). I am assessing the suitability of this driver for a BI/OLAP ETL dataloads. Can someone please tell me if DAD is suitable for such a purpose? What are the disadvantages of using?
      From what I remember using E1 DAD limits joins to upto 3 E1 tables, does not support subqueries, does not support left outer joins, does row by row processing rather than bulk loads, etc.
      Can someone confirm if my understanding is accurate?

      Thanks