7.6 Extract Transform Load (ETL) Database Connection Details

After screening is run, relationships (matches) and watch list records are exported to the Customer Screening database, and this data is sent to ECM based on the connections configured in the data store. To set the ETL database connection details, follow these steps

1. Go to the EDQ URL and open the Director menu.

   Figure 7-19 Director menu in EDQ

   
   

   

   
   
2. In the Director Landing page, expand the Customer-Screening project in the Project Browser pane.

   Figure 7-20 Project Browser pane

   
   

   

   
   
3. Expand the Data Stores node and open FCDM Batch Data. The Edit Data Store window appears.

   Figure 7-21 Data Stores Node

   
   

   

   
   
4. In the Edit Data Store window, enter the database host, database name, user name, and password.

   Figure 7-22 Edit Data Store for Staging Database Connection

   
   

   

   
   

   Note:

   1. OEDQ release 12c has a base config folder and a local config folder. The base config folder is called oedqhome and the local config folder is called oedqlocalhome. The names may differ in some cases. For example, dots or underscores may be inserted in the names, such as oedq_local_home.
   2. It is not necessary to enter the schema name if the user name mentioned is the schema owner.
   3. The parameters can be passed as externalized values in the runopsjob command.