Mapping configuration tasks with Cloud Integration Hub
Use mapping tasks for publications and subscriptions if you want to add an ETL (Extract, Transform, and Load) process to the Cloud Integration Hub publication or subscription process.
For publications and subscriptions that require mapping and filtering only, use synchronization tasks.
Mapping task configuration process
To use mapping tasks with Cloud Integration Hub Connector, you create the mapping in Informatica Intelligent Cloud Services Mapping Designer and then create a mapping task that uses the mapping.
To use mapping configuration with Cloud Integration Hub Connector, perform the following tasks:
1Create a mapping in Mapping Designer.
When you create a mapping for a publication, the source is the publishing cloud application and the target is the topic table in the Cloud Integration Hub publication repository into which to publish the data.
When you create a mapping for a subscription, the source is the topic table in the Cloud Integration Hub publication repository to consume data from and the target is the subscribing cloud application.
The topic must exist in Cloud Integration Hub before you create the mapping.
2Create a mapping task and select the appropriate mapping.
Creating a mapping and task for a publication
The mappings and tasks that you create to use in Cloud Integration Hub publications include a source and a target.
In publication mappings and tasks the source is the cloud application from which to publish data and the target is the topic table in the Cloud Integration Hub publication repository to which the publication publishes data.
Creating a mapping for a publication
Create the mapping to use in the mapping task for the publication.
The topic must exist in Cloud Integration Hub before you create the mapping.
1Click Design > Mappings, and then click New Mapping.
2In the New Mapping dialog box, enter the mapping name and description, and click OK.
You can use alphanumeric characters and underscores (_) in the mapping name.
3Add a source to the mapping canvas and configure source properties.
4Add a target to the mapping canvas and configure target properties.
aIn the Properties panel, on the General tab, you can enter a name and description.
bClick the Target tab. From the Connection list, select the Cloud Integration Hub connection.
cClick Select next to the Object field, select a topic table in the Select Object Target dialog box, and then click OK.
dOptionally, open the Connection list and select a parameter from the Parameters list. If no parameters exist in the list click New Parameter and then name the parameter and click OK.
eClick the Field Mapping tab and map fields from the source to the connection.
5On the mapping canvas, connect the source to the target.
6Click Save > Save and Close.
Creating a mapping task for a publication
When you create a publication task you select mapping that you created for the publicationand select the Cloud Integration Hub connection as the target of the task.
The mapping must exist in Mapping Designer before you create the task.
1In Data Integration, click New > Task > Mapping Task > Create.
2Specify the following task details:
Task Name
Enter a name for the task.
The name of the task must be unique within the organization. The task name is not case sensitive.
The task name can contain alphanumeric characters, spaces, and the following special characters: _ . + -
Tip: Indicate the type of the task in the task name. This will ensure that when you select a task to use in a Cloud Integration Hub publication workflow, you select a publication task. For example, name the task Pub_<TaskName>.
Description
Optionally, enter a description for the task. The description can contain up to 255 characters.
Runtime Environment
Runtime environment that contains the Secure Agent to run the task.
Mapping
Mapping associated with the task. Select the publication mapping.
To select a mapping, click Select. The Select a Mapping dialog box displays up to 200 mappings. If the mapping you want to use does not display, enter a search string to reduce the number of mappings that display.
Select a mapping and click OK.
An image of the mapping displays below the mapping name.
3Select the Targets step and then, from the Connection list, select the Cloud Integration Hub connection.
4From the Object list, select the topic table into which to publish data.
5Click Finish.
Creating a mapping and task for a subscription
The mappings and tasks that you create to use in Cloud Integration Hub subscriptions include a source and a target.
In subscription mappings and tasks the source is the topic table in the Cloud Integration Hub publication repository from where to consume data and the target is the cloud application that consumes the data.
The topic must exist in the Cloud Integration Hub before you create the mapping and task.
Creating a mapping for a subscription
Create the mapping to use in the mapping task for the subscription.
The topic must exist in Cloud Integration Hub before you create the mapping.
1Click Design > Mappings, and then click New Mapping.
2In the New Mapping dialog box, enter the mapping name and description, and click OK.
You can use alphanumeric characters and underscores (_) in the mapping name.
3Add a source to the mapping canvas and configure source properties.
aIn the Properties panel, on the General tab, you can enter a name and description.
bClick the Source tab. From the Connection list, select the Cloud Integration Hub connection.
cClick Select. To consume multiple topic tables select Multiple Objects and then, in the actions menu, click Add Source Object.
The Select Source Object dialog box shows.
dSelect the database table or tables to consume and then click OK.
4Add a target to the mapping canvas and configure target properties.
5On the mapping canvas, connect the source to the target.
6Click Save > Save and Close.
Creating a mapping task for a subscription
When you create a subscription task you select mapping that you created for the subscriptionand select the Cloud Integration Hub connection as the source of the task.
The mapping must exist in Mapping Designer before you configure the task.
1In Data Integration, click New > Mapping Task > Create.
2Specify the following task details:
Task Name
Enter a name for the task.
The name of the task must be unique within the organization. The task name is not case sensitive.
The task name can contain alphanumeric characters, spaces, and the following special characters: _ . + -
Tip: Indicate the type of the task in the task name. This will ensure that when you select a task to use in a Cloud Integration Hub publication workflow, you select a publication task. For example, name the task Pub_<TaskName>.
Description
Optionally, enter a description for the task. The description can contain up to 255 characters.
Runtime Environment
Runtime environment that contains the Secure Agent to run the task.
Mapping
Mapping associated with the task. Select the subscription mapping.
To select a mapping, click Select. The Select a Mapping dialog box displays up to 200 mappings. If the mapping you want to use does not display, enter a search string to reduce the number of mappings that display.
Select a mapping and click OK.
An image of the mapping displays below the mapping name.
3Click the Sources tab and then, from the Connection list, select the Cloud Integration Hub connection.
aFrom the Objects list, select the topic table from which to consume data.
bIn the Query Options section, you can filter or sort data based on one or more fields.
4On the Targets tab, select a target connection that connects to the target into which you want to write data.
5On the Input Parameters tab, map the fields in the Source column to fields in the Target column, and then click Next.
6On the Schedule tab, verify that the option Do not run this task on a schedule is selected. The task runs according to the schedule of the publication that uses the task. Optionally, you can run multiple instances of a mapping task simultaneously. To enable simultaneous task runs, select the Allow the mapping task to be executed simultaneously option.
