Business 360 Connector > Mappings with Business 360 Connector overview > Source transformation mapping example

Source transformation mapping example

An organization uses Customer 360 to master customer data. To further analyze the customer data, the organization wants to load the mastered data to an analytical application. Use the Business 360 Connector to read data from Customer 360 and load the data to the analytical application.
    1. Create a Business 360 connection.
    2. Create a connection to the analytical application.
    3. Create a mapping.
    4. Add a Source transformation, and specify a name and description in the general properties.
    5. On the Source tab, perform the following steps:
    1. a. In the Connection field, select the Business 360 connection.
    2. b. In the Source Type field, select Single Object.
    3. c. In the Object field, select the source object from which you want to read data.
    4. The following image shows the source assets:
    5. d. To view the list of supported business applications, on the left pane, select Home.
    6. e. To view the list of available assets, select the asset type under an application. For example, if you select Customer 360 and Business Entities on the left pane, you can view the list of available business entities on the right pane from which you can select the required source object.
    7. f. To view the list of custom assets, on the left pane, expand Custom Assets, and select an asset type .
    8. The custom assets are grouped based on the asset type.
      The list of custom assets appears on the right pane. For example, if you choose Business Entities, the list of custom business entities appears on the right pane.
      Note: You can select predefined business entities, custom business entities, and relationships as the source object. You cannot select Reference 360 assets and hierarchies as the source object. If you change the name of the business entity or delete it in the Business 360 Console, the existing mappings with references to that business entity will fail when you run the mapping.
    6. On the Field Mapping tab, select elements in the response structure that you want to map to the output fields.
    The following image shows the response structure on the left pane in a hierarchical format and the output fields on the right pane in a relational format:
    Note: Map the BusinessId field if you want to export the value of the BusinessId field using the export job definition. The BusinessId field contains the unique ID of an existing master record.
    7. Add a Target transformation, and specify the name and description in the general properties.
    8. Select the connection to the analytical application.
    9. Go to Target > Parameters Panel > Input-Output Parameters, and create a parameter. Specify jobInstanceId as the name of the parameter.
    The input-output parameter is internally mapped to the job instance ID. When you run an ingress or export job, Cloud Application Integration process passes the job instance ID to the input-output parameter in Cloud Data Integration. Based on the defined taskflows, the job is executed. If you do not define the input-output parameter for the Target transformation in Cloud Data Integration, your job fails.
    The following image shows the input-output parameter dialog box:
    10. Draw links to connect the Source transformation to the Target transformation.
    The following image shows the Select Output Group dialog box where you select the output group to write data to the target:
    The Select Output Group dialog box shows the target to which you want to write data.
    Note: You cannot modify the targets from the mapped output groups. As a workaround, delink the source from the target, and relink.
    11. Save the mapping.