Map extracted data to an existing connection

Data extracted remotely using the Portable Data Extractor can be mapped to an existing Infor Risk & Compliance online or an offline connection. Mapping can be advantageous when Insights have multiple components as data extracted for the individual components can be mapped to a single connection for logical grouping.

Mapped connections are supported by default for the following Insights:

ERP INSIGHTS
SAP
  • Configuration Insight for SAP
Oracle
  • Process Configuration Insights
  • Configuration Insight
PeopleSoft
  • Process Configuration Insights
  • Configuration Insight

You can map extracted data from a .beu file to an existing Infor Risk & Compliance online or an offline connection.

Note: For an Insight to support offline project mapping to an existing offline or online connection, the Insight name should be mentioned in the MapInsightsConnections.xml file.

For example, if you want an offline project for Authorizations Insight for SAP to be mapped to an existing online or offline connection, the following node should be added to this file:

<InsightGuid InsightDispalyName="Authorizations Insight for SAP">fcfd2b48-af46-4b91-aa4a-269a84cf1043</InsightGuid>

For details refer to the respective Infor Risk & Compliance Configuration Settings Guide.

Mapping connections is possible only when the connection parameters in the .beu file (the output file of the Portable Data Extractor) match with the parameters for an existing connection in Infor Risk & Compliance.

The following table lists the connection parameters that should match with an existing connection.

ERP CONNECTION PARAMETERS TO MATCH
SAP
  • Host Name
  • System Number
  • Client Number
Oracle
  • Protocol
  • Host
  • Port
  • TNS Alias
PeopleSoft
  • Provider
  • Server
  • Datasource

Map extracted data from a .beu file to an existing connection as follows:

  1. On the Connections page, click Import to display a list of ERP applications. Click the required ERP to display the ERP: Import Connection page.
    Note: The procedure to map the extracted data in a .beu file to an existing connection is same across all the ERP applications. The Import functionality is not supported for Infor.
  2. On the Import Connection page, select whether data from this connection should be secured.
  3. Click Browse to locate the .beu project file generated by the Portable Data Extractor.
  4. Click the Upload icon. The system uploads the .beu file and populates the remaining fields on the screen with the connection details.
    Note: Ensure that the permission, Full Control is given to Everyone on the shared folder containing the .beu file. Unless this is done, the data cannot be populated for the mapped connection.
  5. Select the Map This Extraction check box to map data from the remote connection to an existing online or an offline connection in Infor Risk & Compliance. This check box is enabled only if the uploaded .beu file belongs to an Insight that supports the mapping functionality.
    Note: Before performing the mapping, Infor Risk & Compliance checks whether the uploaded .beu file is already mapped to the selected connection. If it is, a message is displayed, saying that the project is already mapped.
  6. From the drop-down list, select the connection to which the data should be mapped. The drop-down list displays all connections that match the connection parameters in the .beu file. If none of the parameters in the existing connections and .beu file match, the drop-down list will be empty.
  7. Click Save. The offline connection is mapped to the selected connection.

Verify mapped connections

After an offline connection is mapped to an existing connection, you can verify the mapping.

  • On the Connections page, click the connection name link to view the details of that connection. If data has been mapped to this connection, this will be displayed.