Importing Extra Keys in a Schedule

M3 DMP can use the Infor ION API Gateway to communicate with M3 and Data Lake.

On this section, you can view an example of how to use a Server Workflow to import data from the Data Lake and fill an Extra Key in a DMP dataset.

The current version of DMP does not include the Import Extra Key action in Server Workflow, but it is planned for future updates of the program Instead, the Run SQL action is used to perform this step.

Verify that these tasks are met before importing Extra Keys in a Schedule:

Configure the REST auth2 and the ION API file to access ION. Go to Menu > Setup > Settings > Data.
Import the dataset from M3.
Inspect the dataset properties, and enable and name the Extra Key fields in the Key tab.

On Server Workflows, select the Import Data Lake action to import Data Lake to a table using IDL_ITNO. See Server Workflows.
On Import Data Lake, specify this information:
Input
Specify this in the field:
```
SELECT
  "MITMAS"."ITNO",
  "MITMAS"."ITDS",
  "MITMAS"."STAT",
  "MITMAS"."FUDS",
  "MITMAS"."DWNO",
  "MITMAS"."RESP"
   FROM
  "MITMAS"
WHERE CONO=780
```
Note: The Server Workflow waits for the action to complete before continuing. In a standard workflow, you must add the Wait for Server Task action to ensure it is completed.
Optionally, you can review the result using Infor OS, Data Fabric, Compass, or use DMP DBTool after the result is imported.
On Server Workflows, select the Run SQL action.
Note: Before you configure the actions in Server Workflows, ensure that these settings are correctly configured:
- Go to Dataset properties > General. Check if the dataset property is set to Base1Key or BaseXKey in the Integration field.
- Go to Dataset properties > Keys > Basic/Extra Keys. On Extra Keys, set KClass1 as the correct DMP Field. On Basic Keys, K3 is set to UCITNO, but it might differ in some datasets.

On Run SQL, specify this information:

Configuration

Specify this in the field and save the configuration:

UPDATE Base1Key SET Base1Key.KClass1 = IDL_ITNO.RESP FROM Base1Key RIGHT JOIN IDL_ITNO ON IDL_ITNO.ITNO = Base1Key.K3 WHERE Base1Key.BaseID > 0

To configure the schedule, go to Menu > Data Administration > Scheduled Server Tasks.
See Scheduled Server Tasks.
After the schedule is completed, you can review the results. You can view the status in the Schedule list, and in a favorite view, you can see that the Extra Key field is populated.