To create and configure a PowerCenter task, export the workflow from the PowerCenter Repository Manager to an XML file and then upload the XML file in to Data Integration. After you upload the file, map the uploaded connections to Data Integration connections.
You can update an existing PowerCenter task to use a different PowerCenter XML file. When you upload a new PowerCenter XML file to an existing PowerCenter task, the PowerCenter task deletes the old XML file and updates the PowerCenter task definition based on new XML file content.
Configuring a PowerCenter task
Perform the following tasks to create a PowerCenter task in Data Integration.
1To create a PowerCenter task, click New > Tasks. Select PowerCenter Task and then click Create.
To edit a PowerCenter task, on the Explore page, navigate to the task. In the row that contains the task, click Actions and select Edit.
2In the Task Details area, configure the following fields:
Field
Description
Task Name
Name of the PowerCenter task.
Task names can contain alphanumeric characters, spaces, and the following special characters: _ . + -
Maximum length is 100 characters. Task names are not case sensitive.
Location
Project folder in which the task resides.
If the Explore page is currently active and a project or folder is selected, the default location for the asset is the selected project or folder. Otherwise, the default location is the location of the most recently saved asset.
Description
Description of the PowerCenter task.
Maximum length is 255 characters.
Runtime Environment
Runtime environment that contains the Secure Agent to run the task.
Workflow XML File
PowerCenter workflow XML file associated with the task. Only the first 30 characters of the XML file name appear.
To upload a file, click Upload XML File. After you upload the workflow XML file, the connections and transformations appear in the Workflow XML File Details area.
To download the workflow XML file from Data Integration, click Download XML File. You might download a file to import the workflow to the PowerCenter Workflow Manager for review.
3Optionally, if the task runs in a serverless runtime environment, configure serverless usage properties.
4In the Schedule Details area, choose whether to run the task on a schedule or without a schedule. Choose one of the following options:
- To run a task on a schedule, select Run this task on schedule and select the schedule you want to use.
- To create a new schedule, select New. Enter schedule details and click OK.
- To run the task manually, select Do not run this task on a schedule.
5Optionally, if the workflow contains parameters or variables, you can use values from a parameter file. Choose one of the following options:
- To use a parameter file on a local machine, select Local. enter the following information:
Field
Description
Parameter File Directory
Absolute path for the directory that contains the parameter file, excluding the parameter file name. The directory must be accessible by the Secure Agent.
If you do not enter a location, Data Integration uses the following directory:
Name of the file that contains the definitions and values of user-defined parameters and variables used in the task.
You can provide the file name or the relative path and file name in this field.
- To use a cloud-hosted file, select Cloud Hosted. Enter the following information about the file:
Field
Description
Connection
Connection where the parameter file is stored. You can use the following connection types:
- Amazon S3
- Google Storage V2
- Azure Data Lake Store Gen2
Object
Name of the file that contains the definitions and values of user-defined parameters and variables used in the task.
6Optionally, if you want to create a parameter file based on the parameters and default values specified in the mapping on which the task is based, click Download Parameter File Template. For more information about parameter file templates, see Mappings.
7Configure email notification options for the task.
8In the Connections area, select a Connection for each connection reference. A connection reference is a source, target, or lookup connection defined in the workflow XML file.
Alternatively, to create a connection, click New. To edit a connection, click View and then click Edit.
The Transformations area displays all transformations defined in the workflow XML file.
9If the mapping contains parameters, you can edit the values in the Mapping Parameters area.
10If the mapping contains variables, you can edit the values of the variables in the Mapping Variables area.