Tasks

Back Next

Configuring a PowerCenter task

Perform the following tasks to create a PowerCenter task in

Data Integration

To 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

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

Optionally, if the task runs in a serverless runtime environment, configure serverless usage properties.

In 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

To run the task manually, select

Do not run this task on a schedule

Optionally, 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: <Secure Agent installation directory>/apps/Data_Integration_Server/data/userparameters
Parameter File Name	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.

Optionally, 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

Configure email notification options for the task.

In 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