Source systems created in FDMEE

In this blog, I would be talking about the source systems in FDMEE and the backend table where this information is stored. Although it is possible to update this information manually, I would not recommend the same since this information is referred to in multiple other tables (One reason why manually updating these tables is not recommended is because FDMEE does not use foreign keys for referential integrity. This information is coded at an application level. This means an inadvertent code snippet manually updated can possibly break an FDMEE install)

The source systems defined in FDMEE is as shown in the below snapshot.

The source system information is stored in a table called as AIF_SOURCE_SYSTEMS that is present in the FDMEE schema defined during the EPM installation. The contents of this table is as shown in the below snapshot. 

The main fields that are updated by a user is as shown in the below snapshot. 

Source System Name, Source System Description, Source System Type, Drill_to_Source_URL and ODI_CONTEXT_CODE are the commonly updated values from the frontend. 

The table structure metadata of AIF_SOURCE_SYSTEMS is as shown in the below snapshot.