Mapping extracted data to an existing connection

Data extracted remotely, using the Portable Data Extractor, can be mapped to an existing IRC 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.

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

See Configuration Settings Guide for SAP, Oracle and PeopleSoft.

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 IRC.

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 must 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 IRC. 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, IRC verifies whether the uploaded .beu file is already mapped to the selected connection. A confirmation message is displayed.
  6. From the drop-down list, select the connection to which the data must 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 in the .beu file match, the drop-down list is empty.
  7. Click Save.
    The offline connection is mapped to the selected connection.

    Verifying Mapped Connections

    After an offline connection is mapped to an existing connection, you can verify the mapping as follows:

    • On the Connections page, click the connection name link to view the details of that connection. If data is mapped to this connection, the details are displayed.