Universal Data Adapter (UDA) in FDMEE 11.2.2
The Universal Data Adapter enables you to integrate external source table/view information directly, such as from SQL tables, into FDMEE - bypassing the open interface table. This feature enables you to easily connect to any source data where they have access to the underlying database in the case where a prepackaged adapter is not available, or if the pre-packaged adapter does not provide the required data. Here's a main difference between UDA & Open Interface Adapter: Open Interface Adapter : We use FDMEE table AIF_OPEN_INTERFACE as a staging table between our source DB and the FDMEE staging table ( TDATASEG_T ). Universal Data Adapter : We bypass the Open Interface table so we have direct integration between our source DB and TDATASEG_T (i.e. FDMEE). Check the below diagram for the data flow: UDA can be thought as a way of extracting data from any data source which FDMEE can access its underlying database. FDMEE uses Oracle Data Integrator as the underlying ELT...