Creating the Data Lake flow

A prerequisite of setting up the Data Lake is that you must generate an API Gateway file. See Obtaining the IDM user credentials.

A value from this file will be used below in step 3. It is crucial that the user who is identified on the Download Credential page when generating the API Gateway file have, at the minimum, the following security roles before setting up the Data Lake. If this is not the case, the roles can be added. Then, a new API Gateway file can be generated and used as an input to the Action for Import API Gateway Config file wizard in PLM Process. Failure to have the necessary security roles will result in a 403 - Forbidden error when setting up the Data Lake.

This is a list of the necessary security roles:
  • DATALAKE-Administrator
  • DATALAKE-DataAdministrator
  • DATALAKE-SystemAdministror
  • IONAPI-Administrator
  • IONDeskAdmin
  • IONDeskSecurityAdmin
  • SecurityApplicationAdmin
  • IONDeskOAuthGenerator
  1. From Infor OS , navigate to ION .
  2. Click Connection > Connection Point.
  3. Click Add to create a new Connection Point. The recommended name is OptivaIMS.
    The Logical ID Type must be plmprocess.
    The Logical ID must be infor.plmprocess.optivaims.
    TheAPI Gateway Client ID must be set the value for ci in the API Gateway file.
  4. Select Connect > Data Flows.
  5. Click Add and select the Data Lake flow.
  6. In the Name field, specify Optiva2DataLake.
    The data flow should look like this:data_lake_flow1
  7. In the flow window select the Application icon and drag it into position to the left of the Data Lake icon that is already there.
  8. In Application Activity Properties, specify the name: OptivaIMS.
    data_lake2
  9. Click the plus sign to add a connection point for this application.
  10. Select your OptivaIMS connection point and click OK.
  11. In the data lake flow window, select the paper icon. The OptivaIMS application is displayed.
  12. Select the + sign from the Documents section below the flow.
  13. Select the check box in the top title bar of the table to select all documents and click OK.
  14. Click Save.