5.1.1.2.1 Update ECM Atomic Schema Datasource in Toolkit Metadata

If you set ECM_DATASOURCE in the above table to a value other than E_D, follow these steps to ensure all Toolkit Metadata references are updated to the correct datasource for investigation reads.

To update ECM Atomic Schema Datasource:

1. Skip this section if you are using E_D as your ECM_DATASOURCE.
2. If you have set ECM_DATASOURCE to a different datasource name, perform the following updates in the Toolkit Metadata tables:
   • In the table CS_IH_ENTITY_SQL_QUERY_MAPPING, update the value of the column V_DATASRC_NM from E_D to your chosen datasource name for all relevant records.
   • In the table CS_IH_SQL_DATASOURCE_MAP, update the value of the column V_DATASRC_NM from E_D to your chosen datasource name for all relevant records.

This ensures that the Flow Template Notebook references the correct schema when reading data for investigations, preventing unresolved lookups or data access issues.