Table of Contents

Search

  1. Preface
  2. Mappings
  3. Mapping tutorial
  4. Parameters
  5. CLAIRE recommendations
  6. Data catalog discovery
  7. Visio templates

Mappings

Mappings

Parameter file location

Parameter file location

When you use a parameter file, save the parameter file on a local machine or in a cloud-hosted directory based on the task type. You enter details about the parameter file on the
Schedule
tab when you create the task.
The following table lists the default parameter file directory for each task type:
Task type
Default parameter file directory
Mapping task based on a mapping
<Secure Agent installation directory>/apps/Data_Integration_Server/data/userparameters
Mapping task based on a mapping in advanced mode
<Secure Agent installation directory>/apps/data/userparameters
Synchronization task
<Secure Agent installation directory>/apps/Data_Integration_Server/data/userparameters
For mapping tasks, you can also save the parameter file in one of the following locations:
A local machine
Save the file in a location that the Secure Agent can access.
For mappings in advanced mode, the file must be stored on the Secure Agent machine.
You enter the file name and directory on the
Schedule
tab when you create the task. Enter the absolute file path. Alternatively, enter a path relative to a $PM system variable, for example,
$PMRootDir/ParameterFiles
.
The following table lists the system variables that you can use:
System variable
Description
$PMRootDir
Root directory for the Data Integration Server Secure Agent service.
Default is
<Secure Agent installation directory>/apps/Data_Integration_Server/data
.
$PMBadFileDir
Directory for row error logs and reject files.
Default is $PMRootDir/error.
$PMCacheDir
Directory for index and data cache files.
Default is $PMRootDir/cache.
$PMExtProcDir
Directory for external procedures.
Default is $PMRootDir.
$PMLookupFileDir
Directory for lookup files.
Default is $PMRootDir.
$PMSessionLogDir
Directory for session logs.
Default is $PMRootDir/../logs.
$PMSourceFileDir
Directory for source files.
Default is $PMRootDir.
$PMStorageDir
Directory for files related to the state of operation of internal processes such as session and workflow recovery files.
Default is $PMRootDir.
$PMTargetFileDir
Directory for target files.
Default is $PMRootDir.
$PMTempDir
Directory for temporary files.
Default is $PMRootDir/temp.
$PMWorkflowLogDir
Directory for workflow logs.
Default is $PMRootDir/../logs.
To find the configured path of a system variable, see the pmrdtm.cfg file located at the following directory:
<Secure Agent installation directory>\apps\Data_Integration_Server\<Data Integration Server version>\ICS\main\bin\rdtm
You can also find the configured path of any variable except $PMRootDir in the Data Integration Server system configuration details in
Administrator
.
If you do not enter a location,
Data Integration
uses the default parameter file directory.
A cloud platform
You can use a connection stored with
Informatica Intelligent Cloud Services
. The following table shows the connection types that you can use and the configuration requirements for each connection type:
Connection type
Requirements
Amazon S3 V2
You can use a connection that was created with the following credentials:
  • Access Key
  • Secret Key
  • Region
The S3 bucket must be public.
Azure Data Lake Store Gen2
You can use a connection that was created with the following credentials:
  • Account Name
  • ClientID
  • Client Secret
  • Tenant ID
  • File System Name
  • Directory Path
The storage point must be public.
Google Storage V2
You can use a connection that was created with the following credentials:
  • Service Account ID
  • Service Account Key
  • Project ID
The storage bucket must be public.
Create the connection before you configure the task. You select the connection and file object to use on the
Schedule
tab when you create the task.
Data Integration
displays the location of the parameter file and the value of each parameter in the job details after you run the task.

0 COMMENTS

We’d like to hear from you!