Command Reference > infacmd isp Command Reference > CreateConnection
  

CreateConnection

Defines a connection and the connection options.
To list connection options for an existing connection, run infacmd isp ListConnectionOptions.
The infacmd isp CreateConnection command uses the following syntax:
CreateConnection

<-DomainName|-dn> domain_name

<-UserName|-un> user_name

<-Password|-pd> password

[<-SecurityDomain|-sdn> security_domain]

[<-ResilienceTimeout|-re> timeout_period_in_seconds]

<-ConnectionName|-cn> connection_name

[<-ConnectionId|-cid> connection_id]

<-ConnectionType|-ct> connection_type

[<-ConnectionUserName|-cun> connection_user_name]

[<-ConnectionPassword|-cpd> connection_password]

[<-VendorId|-vid> vendor_id]

[-o options] (name-value pairs separated by space)
The following table describes infacmd isp CreateConnection options and arguments:
Option
Argument
Description
-DomainName
-dn
domain_name
Required. Name of the Informatica domain. You can set the domain name with the -dn option or the environment variable INFA_DEFAULT_DOMAIN. If you set a domain name with both methods, the -dn option takes precedence.
-UserName
-un
user_name
Required if the domain uses Native or LDAP authentication. User name to connect to the domain. You can set the user name with the -un option or the environment variable INFA_DEFAULT_DOMAIN_USER. If you set a user name with both methods, the -un option takes precedence.
Optional if the domain uses Kerberos authentication. To run the command with single sign-on, do not set the user name. If you set the user name, the command runs without single sign-on.
-Password
-pd
password
Required if you specify the user name. Password for the user name. The password is case sensitive. You can set a password with the -pd option or the environment variable INFA_DEFAULT_DOMAIN_PASSWORD. If you set a password with both methods, the password set with the -pd option takes precedence.
-SecurityDomain
-sdn
security_domain
Required if the domain uses LDAP authentication. Optional if the domain uses native authentication or Kerberos authentication. Name of the security domain to which the domain user belongs. You can set a security domain with the -sdn option or the environment variable INFA_DEFAULT_SECURITY_DOMAIN. If you set a security domain name with both methods, the -sdn option takes precedence. The security domain name is case sensitive.
If the domain uses native or LDAP authentication, the default is Native. If the domain uses Kerberos authentication, the default is the LDAP security domain created during installation. The name of the security domain is the same as the user realm specified during installation.
-ResilienceTimeout
-re
timeout_period_in_seconds
Optional. Amount of time in seconds that infacmd attempts to establish or re-establish a connection to the domain. If you omit this option, infacmd uses the timeout value specified in the INFA_CLIENT_RESILIENCE_TIMEOUT environment variable. If no value is specified in the environment variable, the default of 180 seconds is used.
-ConnectionName
-cn
connection_name
Name of the connection. The name is not case sensitive and must be unique within the domain. It cannot exceed 128 characters, contain spaces, or contain the following special characters:
~ ` ! $ % ^ & * ( ) - + = { [ } ] | \ : ; " ' < , > . ? /
- ConnectionId
-cid
connection_id
String that the Data Integration Service uses to identify the connection. The ID is not case sensitive. It must be 255 characters or less and must be unique in the domain. You cannot change this property after you create the connection. Default value is the connection name.
-ConnectionType
-ct
connection_type
Required. Type of connection. Use one of the following connection types:
  • - ADABAS
  • - DATASIFT
  • - DB2
  • - DB2I
  • - DB2Z
  • - FACEBOOK
  • - GreenplumPT
  • - HADOOP
  • - HadoopFileSystem
  • - HBASE
  • - HIVE
  • - IMS
  • - JDBC
  • - LINKEDIN
  • - ODBC
  • - ORACLE
  • - SAP
  • - SEQ
  • - SFDC
  • - SQLSERVER
  • - TWITTER
  • - TWITTERSTREAMING
  • - VSAM
  • - WEBCONTENT - KAPOWKATALYST
You can use the infacmd isp ListConnections command to view connection types.
ConnectionUserName
-cun
connection_user_name
Required. Database user name.
-ConnectionPassword
-cpd
connection_password
Required. Password for the database user name. You can set a password with the -cpd option or the environment variable INFA_DEFAULT_CONNECTION_PASSWORD, lf you set the password with both options, the -cpd option takes precedence.
If you are creating an ADABAS, DB2I, DB2Z, IMS, SEQ, or VSAM connection, you can enter a valid PowerExchange passphrase instead of a password. Passphrases for access to databases and data sets on z/OS can be from 9 to 128 characters in length. Passphrases for access to DB2 for i5/OS can be up to 31 characters in length. Passphrases can contain the following characters:
  • - Uppercase and lowercase letters
  • - The numbers 0 to 9
  • - Spaces
  • - The following special characters:
    • ’ - ; # \ , . / ! % & * ( ) _ + { } : @ | < > ?
    Note: The first character is an apostrophe.
Passphrases cannot include single quotation marks (‘), double quotation marks (“), or currency symbols.
If a passphrase contains spaces, you must enclose it with double-quotation marks ("), for example, "This is an example passphrase". If a passphrase contains special characters, you must enclose it with triple double-quotation characters ("""), for example, """This passphrase contains special characters ! % & *.""". If a passphrase contains only alphanumeric characters without spaces, you can enter it without delimiters.
Note: On z/OS, a valid RACF passphrase can be up to 100 characters in length. PowerExchange truncates passphrases longer than 100 characters when passing them to RACF for validation.
To use passphrases, ensure that the PowerExchange Listener runs with a security setting of SECURITY=(1,N) or higher in the DBMOVER member. For more information, see "SECURITY Statement" in the PowerExchange Reference Manual.
To use passphrases for IMS connections, ensure that the following additional requirements are met:
  • - You must configure ODBA access to IMS as described in the PowerExchange Navigator User Guide.
  • - You must use IMS data maps that specify IMS ODBA as the access method. Do not use data maps that specify the DL/1 BATCH access method because this access method requires the use of netport jobs, which do not support passphrases.
  • - The IMS database must be online in the IMS control region to use ODBA access to IMS.
-VendorId
-vid
vendor_id
Optional. ID of the external partner who built the adapter.
-Options
-o
options
Required. Enter name-value pairs separated by spaces. The connection options are different for each connection type.

Adabas Connection Options

Use connection options to define an Adabas connection.
Enter connection options in the following format:
... -o option_name=value option_name=value ...
To enter multiple options, separate them with a space. To enter a value that contains a space or other non-alphanumeric character, enclose the value in quotation marks.
The following table describes Adabas connection options:
Option
Description
CodePage
Required. Code to read from or write to the database. Use the ISO code page name, such as ISO-8859-6. The code page name is not case sensitive.
ArraySize
Optional. Determines the number of records in the storage array for the threads when the worker threads value is greater than 0. Valid values are from 1 through 100000. Default is 25.
Compression
Optional. Compresses the data to decrease the amount of data Informatica applications write over the network. True or false. Default is false.
EncryptionLevel
Optional. Level of encryption for RC2 or DES for encryption types. Enter one of the following values for the encryption level:
  • - 1. Use a 56-bit encryption key for DES and RC2.
  • - 2. Use a 168-bit triple DES encryption key for DES or a 64-bit encryption keyfor RC2.
  • - 3. Use a 168-bit triple DES encryption key for DES or a 128-bit encryption key for RC2.
Default is 1.
Note: If you select None for encryption type, the Data Integration Service ignores the encryption level value.
EncryptionType
Optional. Enter one of the following values for the encryption type:
  • - None
  • - RC2
  • - DES
Default is None.
InterpretAsRows
Optional. If true, the pacing size value represents a number of rows. If false, the pacing size represents kilobytes. Default is false.
Location
Location of the PowerExchange Listener node that can connect to the database. The location is defined in the first parameter of the NODE statement in the PowerExchange dbmover.cfg configuration file.
OffLoadProcessing
Optional. Moves bulk data processing from the source machine to the Data Integration Service machine.
Enter one of the following values:
  • - Auto. The Data Integration Service determines whether to use offload processing.
  • - Yes. Use offload processing.
  • - No. Do not use offload processing.
Default is Auto.
PacingSize
Optional. Slows the data transfer rate in order to reduce bottlenecks. The lower the value, the greater the session performance. Minimum value is 0. Enter 0 for optimal performance. Default is 0.
WorkerThread
Optional. Number of threads that the Data Integration Service uses to process bulk data when offload processing is enabled. For optimal performance, this value should not exceed the number of available processors on the Data Integration Service machine. Valid values are 1 through 64. Default is 0, which disables multithreading.
WriteMode
Enter one of the following write modes:
  • - CONFIRMWRITEON. Sends data to the PowerExchange Listener and waits for a success/no success response before sending more data.
  • - CONFIRMWRITEOFF. Sends data to the PowerExchange Listerner without waiting for a success/no success response. Use this option when the target table can be reloaded if an error occurs.
  • - ASYNCHRONOUSWITHFAULTT. Sends data to the PowerExchangeListener asynchronously with the ability to detect errors.
Default is CONFIRMWRITEON.
EnableConnectionPool
Optional. Enables connection pooling. When you enable connection pooling, the connection pool retains idle connection instances in memory. When you disable connection pooling, the Data Integration Service stops all pooling activity. True or false. Default is false.
ConnectionPoolSize
Optional. Maximum number of idle connections instances that the Data Integration Service maintains for a database connection. Set this value to be more than the minimum number of idle connection instances. Default is 15.
ConnectionPoolMaxIdleTime
Optional. Number of seconds that a connection exceeding the minimum number of connection instances can remain idle before the connection pool drops it. The connection pool ignores the idletime when it does not exceed the minimum number of idle connection instances. Default is 120.
ConnectionPoolMinConnections
Optional. Minimum number of idle connection instances that the pool maintains for a database connection. Set this value to be equal to or less than the idle connection pool size. Default is 0.

DataSift Connection Options

Use connection options to define a DataSift connection.
Enter connection options in the following format:
... -o option_name=value option_name=value ...
To enter multiple options, separate them with a space. To enter a value that contains a space or other non-alphanumeric character, enclose the value in quotation marks.
The following table describes DataSift connection options for infacmd isp CreateConnection and UpdateConnection commands:
Option
Description
userName
DataSift username for the DataSift user account.
apiKey
API key. The Developer API key is displayed in the Dashboard or Settings page in the DataSift account.

DB2 for i5/OS Connection Options

Use DB2I connection options to define the DB2 for i5/OS connection.
Enter connection options in the following format:
... -o option_name=value option_name=value ...
Separate multiple options with a space. To enter a value that contains a space or other non-alphanumeric character, enclose the value in quotation marks.
The following table describes DB2 for i5/OS connection options for infacmd isp CreateConnection and UpdateConnection commands:
Option
Description
DatabaseName
Database instance name.
EnvironmentSQL
Optional. SQL commands to set the database environment when you connect to the database. The Data Integration Service executes the connection environment SQL each time it connects to the database.
Note: Enclose special characters in double quotes.
CodePage
Required. Code page used to read from a source database or write to a target database or file.
ArraySize
Optional. Determines the number of records in the storage array for the threads when the worker threads value is greater than 0. Valid values are from 1 through 100000. Default is 25.
Compression
Optional. Compresses the data to decrease the amount of data to write over the network. Default is false.
EncyptionLevel
Optional. Level of encryption for RC2 or DES for encryption types. Enter one of the following values for the encryption level:
  • - 1. Use a 56-bit encryption key for DES and RC2.
  • - 2. Use a 168-bit triple DES encryption key for DES or a 64-bit encryption keyfor RC2.
  • - 3. Use a 168-bit triple DES encryption key for DES or a 128-bit encryption key for RC2.
Default is 1.
Note: If you select None for encryption type, the Data Integration Service ignores the encryption level value.
EncryptionType
Optional. Type of encryption. Enter one of the following values for the encryption type:
  • - None
  • - RC2
  • - DES
Default is None.
InterpretAsRows
Optional. Represent pacing size as a number of rows. If false, the pacing size represents kilobytes. Default is false.
Location
Location of the PowerExchange Listener node that can connect to the database. The location is defined in the first parameter of the NODE statement in the PowerExchange dbmover.cfg configuration file.
PacingSize
Optional. Amount of data the source system can pass to the PowerExchange Listener. Configure the pacing size if an external application, a database, or the Data Integration Service node is a bottleneck. The lower the value, the faster the performance.
Minimum value is 0. Enter 0 for maximum performance. Default is 0.
RejectFile
Optional. Enter the reject file name and path. Reject files contain rows that were not written to the database.
WriteMode
Enter one of the following write modes:
  • - CONFIRMWRITEON. Sends data to the PowerExchange Listener and waits for a success/no success response before sending more data.
  • - CONFIRMWRITEOFF. Sends data to the PowerExchange Listener without waiting for a success/no success response. Use this option when the target table can be reloaded if an error occurs.
  • - ASYNCHRONOUSWITHFAULTT. Sends data to the PowerExchange Listener asynchronously with the ability to detect errors.
Default is CONFIRMWRITEON.
DatabaseFileOverrides
Specifies the i5/OS database file override. The format is:
from_file/to_library/to_file/to_member
Where:
  • - from_file is the file to be overridden
  • - to_library is the new library to use
  • - to_file is the file in the new library to use
  • - to_member is optional and is the member in the new library and file to use. *FIRST is used if nothing is specified.
You can specify up to 8 unique file overrides on a single connection. A single override applies to a single source or target. When you specify more than one file override, enclose the string of file overrides in double quotes and include a space between each file override.
IsolationLevel
Commit scope of the transaction. Select one of the following values:
  • - None
  • - CS. Cursor stability.
  • - RR. Repeatable Read.
  • - CHG. Change.
  • - ALL
Default is CS.
LibraryList
List of libraries that PowerExchange searches to qualify the table name for Select, Insert, Delete, or Update statements. PowerExchange searches the list if the table name is unqualified.
Separate libraries with semicolons.
EnableConnectionPool
Optional. Enables parallel processing when loading data into a table in bulk mode. Used for Oracle. True or false. Default is true.
ConnectionPoolSize
Optional. Maximum number of idle connections instances that the Data Integration Service maintains for a database connection. Set this value to be more than the minimum number of idle connection instances.
ConnectionPoolMaxIdleTime
Optional. Number of seconds that a connection exceeding the minimum number of connection instances can remain idle before the connection pool drops it. The connection pool ignores the idletime when it does not exceed the minimum number of idle connection instances.
ConnectionPoolMinConnections
Optional. Minimum number of idle connection instances that the pool maintains for a database connection. Set this value to be equal to or less than the idle connection pool size. Default is 0.

Facebook Connection Options

Use connection options to define a Facebook connection.
Enter connection options in the following format:
... -o option_name=value option_name=value ...
To enter multiple options, separate them with a space. To enter a value that contains a space or other non-alphanumeric character, enclose the value in quotation marks.
The following table describes Facebook connection options for infacmd isp CreateConnection and UpdateConnection commands:
Option
Description
ConsumerKey
The App ID that you get when you create the application in Facebook. Facebook uses the key to identify the application.
ConsumerSecret
The App Secret that you get when you create the application in Facebook. Facebook uses the secret to establish ownership of the consumer key.
AccessToken
Access token that the OAuth Utility returns. Facebook uses this token instead of the user credentials to access the protected resources.
AccessSecret
Access secret is not required for Facebook connection.
Scope
Permissions for the application. Enter the permissions you used to configure OAuth.

Greenplum Connection Options

Use connection options to define a Greenplum connection.
Enter connection options in the following format:
... -o option_name=value option_name=value ...
To enter multiple options, separate them with a space. To enter a value that contains a space or other non-alphanumeric character, enclose the value in quotation marks.
The following table describes the Greenplum connection options for infacmd isp CreateConnection and UpdateConnection commands:
Option
Description
UserName
Required. User name with permissions to access the Greenplum database.
Password
Required. Password to connect to the Greenplum database.
driverName
Required. Name of the Greenplum JDBC driver.
For example:com.pivotal.jdbc.GreenplumDriver
For more information about the driver, see the Greenplum documentation.
connectionString
Required. Greenplum JDBC connection URL.
For example: jdbc:pivotal:greenplum://<hostname>:<port>;DatabaseName=<database_name>
For more information about the connection URL, see the Greenplum documentation.
hostName
Required. Host name or IP address of the Greenplum server.
portNumber
Optional. Greenplum server port number.
If you enter 0, the gpload utility reads from the environment variable $PGPORT.
Default is 5432.
databaseName
Required. Name of the database that you want to connect to.
enableSSL
Required. Set this option to true to establish secure communication between the gpload utility and the Greenplum server over SSL.
SSLCertificatePath
Required if you enable SSL. Path where the SSL certificates for the Greenplum server are stored.

HBase Connection Options

Use connection options to define an HBase connection. You can use an HBase connection to connect to an HBase table or a MapR-DB table.
Enter connection options in the following format:
... -o option_name=value option_name=value ...
To enter multiple options, separate them with a space. To enter a value that contains a space or other non-alphanumeric character, enclose the value in quotation marks.
The following table describes the HBase connection options for infacmd isp CreateConnection and UpdateConnection commands:
Option
Description
DATABASETYPE
Required when you create an HBase connection for a MapR-DB table. Set the value to MapR-DB. Default is HBase.
ZOOKEEPERHOSTS
Required. Name of the machine that hosts the ZooKeeper server.
When the ZooKeeper runs in the replicated mode, specify a comma-separated list of servers in the ZooKeeper quorum servers. If the TCP connection to the server breaks, the client connects to a different server in the quorum.
ZOOKEEPERPORT
Required. Port number of the machine that hosts the ZooKeeper server.
Default value of Zookeeper client port is 2181.
Default value of MapR distribution is 5181.
ISKERBEROSENABLED
Required. If you use the HBase connection to connect to an HBase table and want to enable Kerberos, set the value to true. If you use the HBase connection to connect to a MapR-DB table, you must set the value to false. Enclose the value in single quotes.
hbaseMasterPrincipal
Required if you set the value of ISKERBEROSENABLED to true. Specify the Service Principal Name (SPN) of the HBase master server. Enables the ZooKeeper server to communicate with an HBase master server that uses Kerberos authentication.
Enter a string in the following format:
hbase/<domain.name>@<YOUR-REALM>
Where:
  • - domain.name is the domain name of the machine that hosts the HBase master server.
  • - YOUR-REALM is the Kerberos realm.
hbaseRegionServerPrincipal
Required if you set the value of ISKERBEROSENABLED to true. Specify the Service Principal Name (SPN) of the HBase region server. Enables the ZooKeeper server to communicate with an HBase region server that uses Kerberos authentication.
Enter a string in the following format:
hbase_rs/<domain.name>@<YOUR-REALM>
Where:
  • - domain.name is the domain name of the machine that hosts the HBase master server.
  • - YOUR-REALM is the Kerberos realm.
maprdbpath
Required if you create an HBase connection to connect to a MapR-DB table.
Set the value to the database path that contains the MapR-DB table that you want to connect to. Enter a valid MapR cluster path. Enclose the value in single quotes.
When you create an HBase data object for MapR-DB, you can browse only tables that exist in the path that you specify in this option. You cannot access tables that are available in sub-directories in the specified path.
For example, if you specify the maprdbpath as /user/customers/, you can access the tables in the customers directory. However, if the customers directory contains a sub-directory named regions, you cannot access the tables in the following directory:
/user/customers/regions

HDFS Connection Options

Use connection options to define an HDFS connection.
Enter connection options in the following format:
... -o option_name=value option_name=value ...
To enter multiple options, separate them with a space. To enter a value that contains a space or other non-alphanumeric character, enclose the value in quotation marks.
The following table describes the HDFS connection options for infacmd isp CreateConnection and UpdateConnection commands:
Option
Description
userName
User name to access HDFS.
nameNodeURI
The URI to access HDFS. The URI must be in the following format: hdfs://<namenode>:<port>
Where
  • - <namenode> is the host name or IP address of the NameNode.
  • - <port> is the port that the NameNode listens for remote procedure calls (RPC).

Hadoop Connection Options

Use connection options to define a Hive connection.
Enter connection options in the following format:
... -o option_name='value' option_name='value' ...
To enter multiple options, separate them with a space.
The following table describes Hadoop connection options for infacmd isp CreateConnection and UpdateConnection commands that you configure when you want to use the Hadoop connection:
Option
Description
connectionId
String that the Data Integration Service uses to identify the connection. The ID is not case sensitive. It must be 255 characters or less and must be unique in the domain. You cannot change this property after you create the connection. Default value is the connection name.
connectionType
Required. Type of connection is Hadoop.
name
The name of the connection. The name is not case sensitive and must be unique within the domain. You can change this property after you create the connection. The name cannot exceed 128 characters, contain spaces, or contain the following special characters:
~ ` ! $ % ^ & * ( ) - + = { [ } ] | \ : ; " ' < , > . ? /
RMAddress
The service within Hadoop that submits requests for resources or spawns YARN applications.
Use the following format:
<hostname>:<port>
Where
  • - <hostname> is the host name or IP address of the Yarn resource manager.
  • - <port> is the port on which the Yarn resource manager listens for remote procedure calls (RPC).
For example, enter: myhostame:8032
You can also get the Resource Manager Address property from yarn-site.xml located in the following directory on the Hadoop cluster: /etc/hadoop/conf/
The Resource Manager Address appears as the following property in yarn-site.xml:
<property>
<name>yarn.resourcemanager.address</name>
<value>hostname:port</value>
<description>The address of the applications manager interface in the Resource Manager.</description>
</property>
Optionally, if the yarn.resourcemanager.address property is not configured in yarn-site.xml, you can find the host name from the yarn.resourcemanager.hostname or yarn.resourcemanager.scheduler.address properties in yarn-site.xml. You can then configure the Resource Manager Address in the Hadoop connection with the following value: hostname:8032
cadiAppYarnQueueName
The YARN scheduler queue name used by the Blaze engine that specifies available resources on a cluster. The name is case sensitive.
cadiExecutionParameterList
Custom properties that are unique to the Blaze engine.
You can specify multiple properties.
Use the following format:
<property1>=<value>
Where
  • - <property1> is a Blaze engine optimization property.
  • - <value> is the value of the Blaze engine optimization property.
To specify multiple properties use &: as the property separator.
Use custom properties only at the request of Informatica Global Customer Support.
cadiMaxPort
The maximum value for the port number range for the Blaze engine.
cadiMinPort
The minimum value for the port number range for the Blaze engine.
cadiUserName
The operating system profile user name for the Blaze engine.
cadiWorkingDirectory
The HDFS file path of the directory that the Blaze engine uses to store temporary files. Verify that the directory exists. The YARN user, Blaze engine user, and mapping impersonation user must have write permission on this directory.
databaseName
Namespace for tables. Use the name default for tables that do not have a specified database name.
defaultFSURI
The URI to access the default Hadoop Distributed File System.
Use the following connection URI:
hdfs://<node name>:<port>
Where
  • - <node name> is the host name or IP address of the NameNode.
  • - <port> is the port on which the NameNode listens for remote procedure calls (RPC).
For example, enter: hdfs://myhostname:8020/
You can also get the Default File System URI property from core-site.xml located in the following directory on the Hadoop cluster: /etc/hadoop/conf/
Use the value from the fs.defaultFS property found in core-site.xml.
For example, use the following value:
<property>
<name>fs.defaultFS</name>
<value>hdfs://localhost:8020</value>
</property>
If the Hadoop cluster runs MapR, use the following URI to access the MapR File system: maprfs:///.
engineType
The engine that the Hadoop environment uses to run a mapping on the Hadoop cluster. Select a value from the drop down list.
For example select: MRv2
To set the engine type in the Hadoop connection, you must get the value for the mapreduce.framework.name property from mapred-site.xml located in the following directory on the Hadoop cluster: /etc/hadoop/conf/
If the value for mapreduce.framework.name is classic, select mrv1 as the engine type in the Hadoop connection.
If the value for mapreduce.framework.name is yarn, you can select the mrv2 or tez as the engine type in the Hadoop connection. Do not select Tez if Tez is not configured for the Hadoop cluster.
You can also set the value for the engine type in hive-site.xml. The engine type appears as the following property in hive-site.xml:
<property>
<name>hive.execution.engine</name>
<value>tez</value>
<description>Chooses execution engine. Options are: mr (MapReduce, default) or tez (Hadoop 2 only)</description>
</property>
environmentSQL
SQL commands to set the Hadoop environment. The Data Integration Service executes the environment SQL at the beginning of each Hive script generated in a Hive execution plan.
The following rules and guidelines apply to the usage of environment SQL:
  • - Use the environment SQL to specify Hive queries.
  • - Use the environment SQL to set the classpath for Hive user-defined functions and then use environment SQL or PreSQL to specify the Hive user-defined functions. You cannot use PreSQL in the data object properties to specify the classpath. The path must be the fully qualified path to the JAR files used for user-defined functions. Set the parameter hive.aux.jars.path with all the entries in infapdo.aux.jars.path and the path to the JAR files for user-defined functions.
  • - You can use environment SQL to define Hadoop or Hive parameters that you want to use in the PreSQL commands or in custom queries.
hadoopExecEnvExecutionParameterList
Custom properties that are unique to the Hadoop environment.
You can specify multiple properties.
Use the following format:
<property1>=<value>
Where
  • - <property1> is a Hadoop environment optimization property.
  • - <value> is the value of the Hadoop environment optimization property.
To specify multiple properties use &: as the property separator.
Use custom properties only at the request of Informatica Global Customer Support.
Hiveusername
User name of the user that the Data Integration Service impersonates to run mappings on a Hadoop cluster.
If the Hadoop cluster uses Kerberos authentication, the principal name for the JDBC connection string and the user name must be the same.
Note: You must use user impersonation for the Hadoop connection if the Hadoop cluster uses Kerberos authentication.
If the Hadoop cluster does not use Kerberos authentication, the user name depends on the behavior of the JDBC driver.
If you do not specify a user name, the Hadoop cluster authenticates jobs based on the operating system profile user name of the machine that runs the Data Integration Service.
hiveWarehouseDirectoryOnHDFS
The absolute HDFS file path of the default database for the warehouse that is local to the cluster. For example, the following file path specifies a local warehouse: /user/hive/warehouse
For Cloudera CDH, if the Metastore Execution Mode is remote, then the file path must match the file path specified by the Hive Metastore Service on the Hadoop cluster.
You can get the value for the Hive Warehouse Directory on HDFS from the hive.metastore.warehouse.dir property in hive-site.xml located in the following directory on the Hadoop cluster: /etc/hadoop/conf/
For example, use the following value:
<property>
<name>hive.metastore.warehouse.dir</name>
<value>/usr/hive/warehouse </value>
<description>location of the warehouse directory</description>
</property>
For MapR, hive-site.xml is located in the following direcetory: /opt/mapr/hive/<hive version>/conf.
jobMonitoringURL
The URL for the MapReduce JobHistory server. You can use the URL for the JobTracker URI if you use MapReduce version 1.
Use the following format:
<hostname>:<port>
Where
  • - <hostname> is the host name or IP address of the JobHistory server.
  • - <port> is the port on which the JobHistory server listens for remote procedure calls (RPC).
For example, enter: myhostname:8021
You can get the value for the Job Monitoring URL from mapred-site.xml. The Job Monitoring URL appears as the following property in mapred-site.xml:
<property>
<name>mapred.job.tracker</name>
<value>myhostname:8021 </value>
<description>The host and port that the MapReduce job tracker runs at.</description>
</property>
metastoreDatabaseDriver
Driver class name for the JDBC data store. For example, the following class name specifies a MySQL driver:
com.mysql.jdbc.Driver
You can get the value for the Metastore Database Driver from hive-site.xml. The Metastore Database Driver appears as the following property in hive-site.xml:
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
</property>
metastoreDatabasePassword
The password for the metastore user name.
You can get the value for the Metastore Database Password from hive-site.xml. The Metastore Database Password appears as the following property in hive-site.xml:
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>password</value>
</property>
metastoreDatabaseURI
The JDBC connection URI used to access the data store in a local metastore setup. Use the following connection URI:
jdbc:<datastore type>://<node name>:<port>/<database name>
where
  • - <node name> is the host name or IP address of the data store.
  • - <data store type> is the type of the data store.
  • - <port> is the port on which the data store listens for remote procedure calls (RPC).
  • - <database name> is the name of the database.
For example, the following URI specifies a local metastore that uses MySQL as a data store:
jdbc:mysql://hostname23:3306/metastore
You can get the value for the Metastore Database URI from hive-site.xml. The Metastore Database URI appears as the following property in hive-site.xml:
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://MYHOST/metastore</value>
</property>
metastoreDatabaseUserName
The metastore database user name.
You can get the value for the Metastore Database User Name from hive-site.xml. The Metastore Database User Name appears as the following property in hive-site.xml:
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>hiveuser</value>
</property>
metastoreMode
Controls whether to connect to a remote metastore or a local metastore. By default, local is selected. For a local metastore, you must specify the Metastore Database URI, Metastore Database Driver, Username, and Password. For a remote metastore, you must specify only the Remote Metastore URI.
You can get the value for the Metastore Execution Mode from hive-site.xml. The Metastore Execution Mode appears as the following property in hive-site.xml:
<property>
<name>hive.metastore.local</name>
<value>true</true>
</property>
Note: The hive.metastore.local property is deprecated in hive-site.xml for Hive server versions 0.9 and above. If the hive.metastore.local property does not exist but the hive.metastore.uris property exists, and you know that the Hive server has started, you can set the connection to a remote metastore.
remoteMetastoreURI
The metastore URI used to access metadata in a remote metastore setup. For a remote metastore, you must specify the Thrift server details.
Use the following connection URI:
thrift://<hostname>:<port>
Where
  • - <hostname> is name or IP address of the Thrift metastore server.
  • - <port> is the port on which the Thrift server is listening.
For example, enter: thrift://myhostname:9083/
You can get the value for the Remote Metastore URI from hive-site.xml. The Remote Metastore URI appears as the following property in hive-site.xml:
<property>
<name>hive.metastore.uris</name>
<value>thrift://<n.n.n.n>:9083</value>
<description> IP address or fully-qualified domain name and port of the metastore host</description>
</property>
SparkHDFSStagingDir
The HDFS file path of the directory that the Spark engine uses to store temporary files for running jobs. The YARN user, Spark engine user, and mapping impersonation user must have write permission on this directory.
SparkExecutionParameterList
An optional list of configuration parameters to apply to the Spark engine. You can change the default Spark configuration properties values, such as spark.executor.memory or spark.driver.cores.
Use the following format:
<property1>=<value>
  • - <property1> is a Spark configuration property.
  • - <value> is the value of the property.
For example, you can configure a YARN scheduler queue name that specifies available resources on a cluster: spark.yarn.queue=TestQ
To enter multiple properties, separate each name-value pair with the following text: &:
stgDataCompressionCodecClass
Codec class name that enables data compression and improves performance on temporary staging tables.
stgDataCompressionCodecType
Hadoop compression library for a compression codec class name.

Hive Connection Options

Use connection options to define a Hive connection.
Enter connection options in the following format:
... -o option_name='value' option_name='value' ...
To enter multiple options, separate them with a space.
The following table describes Hive connection options for infacmd isp CreateConnection and UpdateConnection commands that you configure when you want to use the Hive connection:
Option
Description
connectionType
Required. Type of connection is HIVE.
name
The name of the connection. The name is not case sensitive and must be unique within the domain. You can change this property after you create the connection. The name cannot exceed 128 characters, contain spaces, or contain the following special characters:
~ ` ! $ % ^ & * ( ) - + = { [ } ] | \ : ; " ' < , > . ? /
relationalSourceAndTarget
Hive connection mode. Set this option to true if you want to use the connection to access the Hive data warehouse. If you want to access Hive target, you need to enable the same connection or another Hive connection to run the mapping in the Hadoop cluster.
If you enable relational source and target, you must provide the metadataDatabaseString option.
pushDownMode
Hive connection mode. Set this option to true if you want to use the connection to run mappings in the Hadoop cluster.
If you enable the connection for pushdown mode, you must provide the options to run the Informatica mappings in the Hadoop cluster.
environmentSQL
SQL commands to set the Hadoop environment. In native environment type, the Data Integration Service executes the environment SQL each time it creates a connection to Hive metastore. If the Hive connection is used to run mappings in the Hadoop cluster, the Data Integration Service executes the environment SQL at the beginning of each Hive session.
The following rules and guidelines apply to the usage of environment SQL in both the connection modes:
  • - Use the environment SQL to specify Hive queries.
  • - Use the environment SQL to set the classpath for Hive user-defined functions and then use either environment SQL or PreSQL to specify the Hive user-defined functions. You cannot use PreSQL in the data object properties to specify the classpath. The path must be the fully qualified path to the JAR files used for user-defined functions. Set the parameter hive.aux.jars.path with all the entries in infapdo.aux.jars.path and the path to the JAR files for user-defined functions.
  • - You can also use environment SQL to define Hadoop or Hive parameters that you intend to use in the PreSQL commands or in custom queries.
If the Hive connection is used to run mappings in the Hadoop cluster, only the environment SQL of the Hive connection is executed. The different environment SQL commands for the connections of the Hive source or target are not executed, even if the Hive sources and targets are on different clusters.
enableQuotes
Encloses all database reserved words in quotes. Default is false.

Properties to Access Hive as Source or Target

The following table describes the mandatory options for infacmd isp CreateConnection and UpdateConnection commands that you configure when you want to use the Hive connection to access Hive data:
Property
Description
metadataConnString
The JDBC connection URI used to access the metadata from the Hadoop server.
The connection string uses the following format:
jdbc:hive://<hostname>:<port>/<db>
Where
  • - hostname is name or IP address of the machine on which the Hive server is running.
  • - port is the port on which the Hive server is listening.
  • - db is the database to which you want to connect. If you do not provide the database details, the Data Integration Service uses the default database details.
bypassHiveJDBCServer
JDBC driver mode. Enable this option to use the embedded JDBC driver (embedded mode).
To use the JDBC embedded mode, perform the following tasks:
  • - Verify that Hive client and Informatica Services are installed on the same machine.
  • - Configure the Hive connection properties to run mappings in the Hadoop cluster.
If you choose the non-embedded mode, you must configure the Data Access Connection String.
The JDBC embedded mode is preferred to the non-embedded mode.
connectString
The connection string used to access data from the Hadoop data store. The non-embedded JDBC mode connection string must be in the following format:
jdbc:hive://<hostname>:<port>/<db>
Where
  • - hostname is name or IP address of the machine on which the Hive server is running.
  • - port is the port on which the Hive server is listening. Default is 10000.
  • - db is the database to which you want to connect. If you do not provide the database details, the Data Integration Service uses the default database details.

Properties to Run Mappings in the Hadoop Cluster

The following table describes the mandatory options for infacmd isp CreateConnection and UpdateConnection commands that you configure when you want to use the Hive connection to run Informatica mappings in the Hadoop cluster:
Property
Description
databaseName
Namespace for tables. Use the name default for tables that do not have a specified database name.
defaultFSURI
The URI to access the default Hadoop Distributed File System.
The FS URI must be in the following format:
hdfs://<node name>:<port>
Where
  • - node name is the host name or IP address of the NameNode.
  • - port is the port on which the NameNode listens for remote procedure calls (RPC).
jobTrackerURI
The service within Hadoop that submits the MapReduce tasks to specific nodes in the cluster.
JobTracker URI must be in the following format:
<jobtrackername>:<port>
Where
  • - jobtrackername is the host name or IP address of the JobTracker.
  • - port is the port on which the JobTracker listens for remote procedure calls (RPC).
hiveWarehouseDirectoryOnHDFS
The absolute HDFS file path of the default database for the warehouse, which is local to the cluster. For example, the following file path specifies a local warehouse:
/user/hive/warehouse
metastoreExecutionMode
Controls whether to connect to a remote metastore or a local metastore. For a local metastore, you must specify the Metastore Database URI, Driver, Username, and Password. For a remote metastore, you must specify only the Remote Metastore URI.
metastoreDatabaseURI
The JDBC connection URI used to access the data store in a local metastore setup. The URI must be in the following format:
jdbc:<datastore type>://<node name>:<port>/<database name>
where
  • - node name is the host name or IP address of the data store.
  • - data store type is the type of the data store.
  • - port is the port on which the data store listens for remote procedure calls (RPC).
  • - database name is the name of the database.
For example, the following URI specifies a local metastore that uses MySQL as a data store:
jdbc:mysql://hostname23:3306/metastore
metastoreDatabaseDriver
Driver class name for the JDBC data store. For example, the following class name specifies a MySQL driver:
com.mysql.jdbc.Driver
metastoreDatabaseUserName
The metastore database user name.
metastoreDatabasePassword
The password for the metastore user name.
remoteMetastoreURI
The metastore URI used to access metadata in a remote metastore setup. For a remote metastore, you must specify the Thrift server details.
The URI must be in the following format:
thrift://<hostname>:<port>
Where
  • - hostname is name or IP address of the Thrift metastore server.
  • - port is the port on which the Thrift server is listening.

DB2 for z/OS Connection Options

Use DB2Z connection options to define the IBM for DB2 z/OS connection.
Enter connection options in the following format:
... -o option_name=value option_name=value ...
Separate multiple options with a space. To enter a value that contains a space or other non-alphanumeric character, enclose the value in quotation marks.
The following table describes DB2Z connection options for infacmd isp CreateConnection and UpdateConnection commands:
Option
Description
DataAccessConnectString
Connection string used to access data from the database.
<database name>
EnvironmentSQL
Optional. SQL commands to set the database environment when you connect to the database. The Data Integration Service executes the connection environment SQL each time it connects to the database.
Note: Enclose special characters in double quotes.
CodePage
Required. Code page used to read from a source database or write to a target database or file.
ArraySize
Optional. Determines the number of records in the storage array for the threads when the worker threads value is greater than 0. Valid values are from 1 through 100000. Default is 25.
Compression
Optional. Compresses the data to decrease the amount of data to write over the network. Default is false.
CorrelationID
Optional. Label to apply to a DB2 task or query to allow DB2 for z/OS to account for the resource. Enter up to 8 bytes of alphanumeric characters.
EncyptionLevel
Optional. Level of encryption for RC2 or DES for encryption types. Enter one of the following values for the encryption level:
  • - 1. Use a 56-bit encryption key for DES and RC2.
  • - 2. Use a 168-bit triple DES encryption key for DES or a 64-bit encryption keyfor RC2.
  • - 3. Use a 168-bit triple DES encryption key for DES or a 128-bit encryption key for RC2.
Default is 1.
Note: If you select None for encryption type, the Data Integration Service ignores the encryption level value.
EncryptionType
Optional. Type of encryption. Enter one of the following values for the encryption type:
  • - None
  • - RC2
  • - DES
Default is None.
InterpretAsRows
Optional. Represent pacing size as a number of rows. If false, the pacing size represents kilobytes. Default is false.
Location
Location of the PowerExchange listener node that can connect to the database. The node is defined in the PowerExchange dbmover.cfg configuration file.
OffloadProcessing
Optional. Moves bulk data processing from the VSAM source to the Data Integration Service machine.
Enter one of the following values:
  • - Auto. The Data Integration Service determines whether to use offload processing.
  • - Yes. Use offload processing.
  • - No. Do not use offload processing.
Default is Auto.
PacingSize
Optional. Amount of data the source system can pass to the PowerExchange Listener. Configure the pacing size if an external application, a database, or the Data Integration Service node is a bottleneck. The lower the value, the faster the performance.
Minimum value is 0. Enter 0 for maximum performance. Default is 0.
RejectFile
Optional. Enter the reject file name and path. Reject files contain rows that were not written to the database.
WorkerThread
Optional. Number of threads that the Data Integration Service uses to process bulk data when offload processing is enabled. For optimal performance, this value should not exceed the number of available processors on the Data Integration Service machine. Valid values are 1 through 64. Default is 0, which disables multithreading.
WriteMode
Enter one of the following write modes:
  • - CONFIRMWRITEON. Sends data to the PowerExchange Listener and waits for a success/no success response before sending more data.
  • - CONFIRMWRITEOFF. Sends data to the PowerExchange Listener without waiting for a success/no success response. Use this option when the target table can be reloaded if an error occurs.
  • - ASYNCHRONOUSWITHFAULTT. Sends data to the PowerExchange Listener asynchronously with the ability to detect errors.
Default is CONFIRMWRITEON.
EnableConnectionPool
Optional. Enables parallel processing when loading data into a table in bulk mode. Used for Oracle. True or false. Default is true.
ConnectionPoolSize
Optional. Maximum number of idle connections instances that the Data Integration Service maintains for a database connection. Set this value to be more than the minimum number of idle connection instances.
ConnectionPoolMaxIdleTime
Optional. Number of seconds that a connection exceeding the minimum number of connection instances can remain idle before the connection pool drops it. The connection pool ignores the idletime when it does not exceed the minimum number of idle connection instances.
ConnectionPoolMinConnections
Optional. Minimum number of idle connection instances that the pool maintains for a database connection. Set this value to be equal to or less than the idle connection pool size. Default is 0.

IBM DB2 Connection Options

Use connection options to define the IBM DB2 connection.
Enter connection options in the following format:
... -o option_name=value option_name=value ...
Separate multiple options with a space. To enter a value that contains a space or other non-alphanumeric character, enclose the value in quotation marks.
The following table describes IBM DB2 connection options for infacmd isp CreateConnection and UpdateConnection commands:
Option
Description
PassThruEnabled
Optional. Enables pass-through security for the connection. When you enable pass-through security for a connection, the domain uses the client user name and password to log into the corresponding database, instead of the credentials defined in the connection object.
MetadataAccessConnectString
Required. JDBC connection URL used to access metadata from the database.
jdbc:informatica:db2://<host name>:<port>;DatabaseName=<database name>
When you import a table from the Developer tool or Analyst tool, by default, all tables are displayed under the default schema name. To view tables under a specific schema instead of the default schema, you can specify the schema name from which you want to import the table. Include the ischemaname parameter in the URL to specify the schema name. For example, use the following syntax to import a table from a specific schema:
jdbc:informatica:db2://<host name>:<port>;DatabaseName=<database name>;ischemaname=<schema_name>
To search for a table in multiple schemas and import it, you can specify multiple schema names in the ischemaname parameter. The schema name is case sensitive. You cannot use special characters when you specify multiple schema names. Use the pipe (|) character to separate multiple schema names. For example, use the following syntax to search for a table in three schemas and import it:
jdbc:informatica:db2://<host name>:<port>;DatabaseName=<database name>;ischemaname=<schema_name1>|<schema_name2>|<schema_name3>
AdvancedJDBCSecurityOptions
Optional. Database parameters for metadata access to a secure database. Informatica treats the value of the AdvancedJDBCSecurityOptions field as sensitive data and encrypts the parameter string.
To connect to a secure database, include the following parameters:
  • - EncryptionMethod. Required. Indicates whether data is encrypted when transmitted over the network. This parameter must be set to SSL.
  • - ValidateServerCertificate. Optional. Indicates whether Informatica validates the certificate that is sent by the database server.
    • If this parameter is set to True, Informatica validates the certificate that is sent by the database server. If you specify the HostNameInCertificate parameter, Informatica also validates the host name in the certificate.
    If this parameter is set to false, Informatica does not validate the certificate that is sent by the database server. Informatica ignores any truststore information that you specify.
  • - HostNameInCertificate. Optional. Host name of the machine that hosts the secure database. If you specify a host name, Informatica validates the host name included in the connection string against the host name in the SSL certificate.
  • - TrustStore. Required. Path and file name of the truststore file that contains the SSL certificate for the database.
  • - TrustStorePassword. Required. Password for the truststore file for the secure database.
Note: For a complete list of the secure JDBC parameters, see the DataDirect JDBC documentation.
Informatica appends the secure JDBC parameters to the connection string. If you include the secure JDBC parameters directly in the connection string, do not enter any parameters in the AdvancedJDBCSecurityOptions field.
DataAccessConnectString
Connection string used to access data from the database.
Enter the connection string in the following format:
<database name>
CodePage
Required. Code page used to read from a source database or write to a target database.
EnvironmentSQL
Optional. SQL commands to set the database environment when you connect to the database. The Data Integration Service executes the connection environment SQL each time it connects to the database.
For example, ALTER SESSION SET CURRENT_SCHEMA=INFA_USR;
Note: Enclose special characters in double quotes.
TransactionSQL
Optional. SQL commands to execute before each transaction. The Data Integration Service executes the transaction SQL at the beginning of each transaction.
For example, SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
Note: Enclose special characters in double quotes.
Tablespace
Optional. The tablespace name of the database.
QuoteChar
Optional. The character that you will use for quotes in this connection.
The type of character used to identify special characters and reserved SQL keywords, such as WHERE. The Data Integration Service places the selected character around special characters and reserved SQL keywords. The Data Integration Service also uses this character for the QuoteChar property. Default is 0.
EnableQuotes
Optional. Select to enable quotes or not for this connection.
When enabled, the Data Integration Service places identifier characters around table, view, schema, synonym, and column names when generating and executing SQL against these objects in the connection. Use if the objects have mixed-case or lowercase names. Valid values are True or False. Default is True.
EnableConnectionPool
Optional. Enables connection pooling. When you enable connection pooling, the connection pool retains idle connection instances in memory. When you disable connection pooling, the Data Integration Service stops all pooling activity. Valid values are True or False. Default is True.
ConnectionPoolSize
Optional. Maximum number of idle connections instances that the Data Integration Service maintains for a database connection. Set this value to be more than the minimum number of idle connection instances. Default is 15.
ConnectionPoolMaxIdleTime
Optional. Number of seconds that a connection exceeding the minimum number of connection instances can remain idle before the connection pool drops it. The connection pool ignores the idletime when it does not exceed the minimum number of idle connection instances. Default is 120.
ConnectionPoolMinConnections
Optional. Minimum number of idle connection instances that the pool maintains for a database connection. Set this value to be equal to or less than the idle connection pool size. Default is 0.

IMS Connection Options

Use connection options to define an IMS connection.
Enter connection options in the following format:
... -o option_name=value option_name=value ...
To enter multiple options, separate them with a space. To enter a value that contains a space or other non-alphanumeric character, enclose the value in quotation marks.
The following table describes IMS connection options:
Option
Description
CodePage
Required. Code to read from or write to the database. Use the ISO code page name, such as ISO-8859-6. The code page name is not case sensitive.
ArraySize
Optional. Determines the number of records in the storage array for the threads when the worker threads value is greater than 0. Valid values are from 1 through 100000. Default is 25.
Compression
Optional. Compresses the data to decrease the amount of data Informatica applications write over the network. True or false. Default is false.
EncryptionLevel
Optional. Level of encryption for RC2 or DES for encryption types. Enter one of the following values for the encryption level:
  • - 1. Use a 56-bit encryption key for DES and RC2.
  • - 2. Use a 168-bit triple DES encryption key for DES or a 64-bit encryption keyfor RC2.
  • - 3. Use a 168-bit triple DES encryption key for DES or a 128-bit encryption key for RC2.
Default is 1.
Note: If you select None for encryption type, the Data Integration Service ignores the encryption level value.
EncryptionType
Optional. Enter one of the following values for the encryption type:
  • - None
  • - RC2
  • - DES
Default is None.
InterpretAsRows
Optional. If true, the pacing size value represents a number of rows. If false, the pacing size represents kilobytes. Default is false.
Location
Location of the PowerExchange Listener node that can connect to the database. The location is defined in the first parameter of the NODE statement in the PowerExchange dbmover.cfg configuration file.
OffLoadProcessing
Optional. Moves bulk data processing from the source machine to the Data Integration Service machine.
Enter one of the following values:
  • - Auto. The Data Integration Service determines whether to use offload processing.
  • - Yes. Use offload processing.
  • - No. Do not use offload processing.
Default is Auto.
PacingSize
Optional. Slows the data transfer rate in order to reduce bottlenecks. The lower the value, the greater the session performance. Minimum value is 0. Enter 0 for optimal performance. Default is 0.
WorkerThread
Optional. Number of threads that the Data Integration Service uses to process bulk data when offload processing is enabled. For optimal performance, this value should not exceed the number of available processors on the Data Integration Service machine. Valid values are 1 through 64. Default is 0, which disables multithreading.
WriteMode
Enter one of the following write modes:
  • - CONFIRMWRITEON. Sends data to the PowerExchange Listener and waits for a success/no success response before sending more data.
  • - CONFIRMWRITEOFF. Sends data to the PowerExchange Listerner without waiting for a success/no success response. Use this option when the target table can be reloaded if an error occurs.
  • - ASYNCHRONOUSWITHFAULTT. Sends data to the PowerExchangeListener asynchronously with the ability to detect errors.
Default is CONFIRMWRITEON.
EnableConnectionPool
Optional. Enables connection pooling. When you enable connection pooling, the connection pool retains idle connection instances in memory. When you disable connection pooling, the Data Integration Service stops all pooling activity. True or false. Default is false.
ConnectionPoolSize
Optional. Maximum number of idle connections instances that the Data Integration Service maintains for a database connection. Set this value to be more than the minimum number of idle connection instances. Default is 15.
ConnectionPoolMaxIdleTime
Optional. Number of seconds that a connection exceeding the minimum number of connection instances can remain idle before the connection pool drops it. The connection pool ignores the idletime when it does not exceed the minimum number of idle connection instances. Default is 120.
ConnectionPoolMinConnections
Optional. Minimum number of idle connection instances that the pool maintains for a database connection. Set this value to be equal to or less than the idle connection pool size. Default is 0.

JDBC Connection Options

Use connection options to define a JDBC connection.
Enter connection options in the following format:
... -o option_name=value option_name=value ...
To enter multiple options, separate options with spaces. To enter a value that contains a space or other non-alphanumeric character, enclose the value in quotation marks.
The following table describes JDBC connection options for infacmd isp CreateConnection and UpdateConnection commands:
Option
Description
JDBCDriverClassName
The Java class that you use to connect to the database.
The following list provides the driver class name that you can enter for the applicable database type:
  • - DataDirect JDBC driver class name for Oracle:
    • com.informatica.jdbc.oracle.OracleDriver
  • - DataDirect JDBC driver class name for IBM DB2:
    • com.informatica.jdbc.db2.DB2Driver
  • - DataDirect JDBC driver class name for Microsoft SQL Server:
    • com.informatica.jdbc.sqlserver.SQLServerDriver
  • - DataDirect JDBC driver class name for Sybase ASE:
    • com.informatica.jdbc.sybase.SybaseDriver
  • - DataDirect JDBC driver class name for Informix:
    • com.informatica.jdbc.informix.InformixDriver
  • - DataDirect JDBC driver class name for MySQL:
    • com.informatica.jdbc.mysql.MySQLDriver
For more information about which driver class to use with specific databases, see the vendor documentation.
MetadataConnString
The URL that you use to connect to the database.
The following list provides the connection string that you can enter for the applicable database type:
  • - DataDirect JDBC driver for Oracle:
    • jdbc:informatica:oracle://<hostname>:<port>;SID=<sid>
  • - DataDirect JDBC driver for IBM DB2:
    • jdbc:informatica:db2://<hostname>:<port>;DatabaseName=<database name>
  • - DataDirect JDBC driver for Microsoft SQL Server:
    • jdbc:informatica:sqlserver://<host>:<port>;DatabaseName=<database name>
  • - DataDirect JDBC driver for Sybase ASE:
    • jdbc:informatica:sybase://<host>:<port>;DatabaseName=<database name>
  • - DataDirect JDBC driver for Informix:
    • jdbc:informatica:informix://<host>:<port>;informixServer=<informix server name>;databaseName=<dbName>
  • - DataDirect JDBC driver for MySQL:
    • jdbc:informatica:mysql://<host>:<port>;DatabaseName=<database name>
For more information about the connection string to use for specific databases, see the vendor documentation for the URL syntax.
EnvironmentSQL
Optional. SQL commands to set the database environment when you connect to the database. The Data Integration Service executes the connection environment SQL each time it connects to the database.
For example, ALTER SESSION SET CURRENT_SCHEMA=INFA_USR;
Note: Enclose special characters in double quotation marks.
TransactionSQL
Optional. SQL commands to execute before each transaction. The Data Integration Service executes the transaction SQL at the beginning of each transaction.
For example, SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
Note: Enclose special characters in double quotes.
QuoteChar
Optional. The character that you will use for quotes in this connection.
The type of character used to identify special characters and reserved SQL keywords, such as WHERE. The Data Integration Service places the selected character around special characters and reserved SQL keywords. The Data Integration Service also uses this character for the QuoteChar property. Default is DOUBLE_QUOTE.
EnableQuotes
Optional. Select to enable quotes or not for this connection.
When enabled, the Data Integration Service places identifier characters around table, view, schema, synonym, and column names when generating and executing SQL against these objects in the connection. Use if the objects have mixed-case or lowercase names. Valid values are True or False. Default is True.
hadoopConnector
Required if you want to enable Sqoop connectivity for the data object that uses the JDBC connection. The Data Integration Service runs the mapping in the Hadoop run-time environment through Sqoop.
You can configure Sqoop connectivity for relational data objects, customized data objects, and logical data objects that are based on a JDBC-compliant database.
Set the value to SQOOP_146 to enable Sqoop connectivity.
hadoopConnectorArgs
Optional. Enter the arguments that Sqoop must use to connect to the database. Enclose the Sqoop arguments within single quotes. Separate multiple arguments with a space.
For example, hadoopConnectorArgs='--<Sqoop argument 1> --<Sqoop argument 2>'
To read data from or write data to Teradata through Teradata Connector for Hadoop (TDCH) specialized connectors for Sqoop, define the TDCH connection factory class in the hadoopConnectorArgs argument. The connection factory class varies based on the TDCH Sqoop Connector that you want to use.
  • - To use the Cloudera Connector Powered by Teradata, configure the hadoopConnectorArgs argument as follows:
    • hadoopConnectorArgs='-Dsqoop.connection.factories=com.cloudera.connector.teradata.TeradataManagerFactory'
  • - To use the Hortonworks Connector for Teradata (powered by the Teradata Connector for Hadoop), configure the hadoopConnectorArgs argument as follows:
    • hadoopConnectorArgs='-Dsqoop.connection.factories=org.apache.sqoop.teradata.TeradataManagerFactory'
If you do not enter Sqoop arguments, the Data Integration Service constructs the Sqoop command based on the JDBC connection properties.

LinkedIn Connection Options

Use connection options to define a LinkedIn connection.
Enter connection options in the following format:
... -o option_name=value option_name=value ...
To enter multiple options, separate them with a space. To enter a value that contains a space or other non-alphanumeric character, enclose the value in quotation marks.
The following table describes LinkedIn connection options for infacmd isp CreateConnection and UpdateConnection commands:
Option
Description
ConsumerKey
The API key that you get when you create the application in LinkedIn. LinkedIn uses the key to identify the application.
ConsumerSecret
The Secret key that you get when you create the application in LinkedIn. LinkedIn uses the secret to establish ownership of the consumer key.
AccessToken
Access token that the OAuth Utility returns. The LinkedIn application uses this token instead of the user credentials to access the protected resources.
AccessSecret
Access secret that the OAuth Utility returns. The secret establishes ownership of a token.

Microsoft SQL Server Connection Options

Use connection options to define the Microsoft SQL Server connection.
Enter connection options in the following format:
... -o option_name=value option_name=value ...
To enter multiple options, separate them with a space. To enter a value that contains a space or other non-alphanumeric character, enclose the value in quotation marks.
The following table describes Microsoft SQL Server connection options for the infacmd isp CreateConnection and UpdateConnection commands:
Option
Description
UseTrustedConnection
Optional. The Integration Service uses Windows authentication to access the Microsoft SQL Server database. The user name that starts the Integration Service must be a valid Windows user with access to the Microsoft SQL Server database. True or false. Default is false.
PassThruEnabled
Optional. Enables pass-through security for the connection. When you enable pass-through security for a connection, the domain uses the client user name and password to log into the corresponding database, instead of the credentials defined in the connection object.
MetadataAccessConnectString
JDBC connection URL to access metadata from the database.
Use the following connection URL:
jdbc:informatica:sqlserver://<host name>:<port>;DatabaseName=<database name>
To test the connection with NTLM authentication, include the following parameters in the connection string:
  • - AuthenticationMethod. The NTLM authentication version to use.
    • Note: UNIX supports NTLMv1 and NTLMv2 but not NTLM.
  • - Domain. The domain that the SQL server belongs to.
The following example shows the connection string for an SQL server that uses NTLMv2 authentication in an NT domain named Informatica.com:
jdbc:informatica:sqlserver://host01:1433;DatabaseName=SQL1;AuthenticationMethod=ntlm2java;Domain=Informatica.com
If you connect with NTLM authentication, you can enable the Use trusted connection option in the MS SQL Server connection properties. If you connect with NTLMv1 or NTLMv2 authentication, you must provide the user name and password in the connection properties.
AdvancedJDBCSecurityOptions
Optional. Database parameters for metadata access to a secure database. Informatica treats the value of the AdvancedJDBCSecurityOptions field as sensitive data and encrypts the parameter string.
To connect to a secure database, include the following parameters:
  • - EncryptionMethod. Required. Indicates whether data is encrypted when transmitted over the network. This parameter must be set to SSL.
  • - ValidateServerCertificate. Optional. Indicates whether Informatica validates the certificate that is sent by the database server.
    • If this parameter is set to True, Informatica validates the certificate that is sent by the database server. If you specify the HostNameInCertificate parameter, Informatica also validates the host name in the certificate.
    If this parameter is set to false, Informatica does not validate the certificate that is sent by the database server. Informatica ignores any truststore information that you specify.
  • - HostNameInCertificate. Optional. Host name of the machine that hosts the secure database. If you specify a host name, Informatica validates the host name included in the connection string against the host name in the SSL certificate.
  • - TrustStore. Required. Path and file name of the truststore file that contains the SSL certificate for the database.
  • - TrustStorePassword. Required. Password for the truststore file for the secure database.
Note: For a complete list of the secure JDBC parameters, see the DataDirect JDBC documentation.
Informatica appends the secure JDBC parameters to the connection string. If you include the secure JDBC parameters directly to the connection string, do not enter any parameters in the AdvancedJDBCSecurityOptions field.
DataAccessConnectString
Required. Connection string used to access data from the database.
Enter the connection string in the following format:
<server name>@<database name>
DomainName
Optional. The name of the domain where Microsoft SQL Server is running.
PacketSize
Optional. Increase the network packet size to allow larger packets of data to cross the network at one time.
CodePage
Required. Code to read from or write to the database. Use the ISO code page name, such as ISO-8859-6. The code page name is not case sensitive.
UseDSN
Required. Determines whether the Data Integration Service must use the Data Source Name for the connection.
If you set the option value to true, the Data Integration Service retrieves the database name and server name from the DSN.
If you set the option value to false, you must enter the database name and server name.
ProviderType
Required. The connection provider that you want to use to connect to the Microsoft SQL Server database.
You can define one of the following values:
  • - 0. Set the value to 0 if you want to use the ODBC provider type. Default is 0.
  • - 1. Set the value to 1 if you want to use the OLEDB provider type. OLEDB is a deprecated provider type. Informatica will drop support for the OLEDB provider type in a future release.
OwnerName
Optional. The table owner name.
SchemaName
Optional. The name of the schema in the database. You must specify the schema name for the Profiling Warehouse if the schema name is different from the database user name. You must specify the schema name for the data object cache database if the schema name is different from the database user name and if you configure user-managed cache tables.
EnvironmentSQL
Optional. SQL commands to set the database environment when you connect to the database. The Data Integration Service executes the connection environment SQL each time it connects to the database.
For example, ALTER SESSION SET CURRENT_SCHEMA=INFA_USR;
Note: Enclose special characters in double quotes.
TransactionSQL
Optional. SQL commands to execute before each transaction. The Data Integration Service executes the transaction SQL at the beginning of each transaction.
For example, SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
Note: Enclose special characters in double quotes.
QuoteChar
Optional. The character that you will use for quotes in this connection.
The type of character used to identify special characters and reserved SQL keywords, such as WHERE. The Data Integration Service places the selected character around special characters and reserved SQL keywords. The Data Integration Service also uses this character for the QuoteChar property. Default is 0.
EnableQuotes
Optional. Choose to enable quotes or not for this connection.
When enabled, the Data Integration Service places identifier characters around table, view, schema, synonym, and column names when generating and executing SQL against these objects in the connection. Use if the objects have mixed-case or lowercase names. Valid values are True or False. Default is True.
EnableConnectionPool
Optional. Enables connection pooling. When you enable connection pooling, the connection pool retains idle connection instances in memory. When you disable connection pooling, the Data Integration Service stops all pooling activity. Valid values are True or False. Default is True.
ConnectionPoolSize
Optional. Maximum number of idle connections instances that the Data Integration Service maintains for a database connection. Set this value to be more than the minimum number of idle connection instances. Default is 15.
ConnectionPoolMaxIdleTime
Optional. Number of seconds that a connection exceeding the minimum number of connection instances can remain idle before the connection pool drops it. The connection pool ignores the idletime when it does not exceed the minimum number of idle connection instances. Default is 120.
ConnectionPoolMinConnections
Optional. Minimum number of idle connection instances that the pool maintains for a database connection. Set this value to be equal to or less than the idle connection pool size. Default is 0.

Netezza Connection Options

Use connection options to define a Netezza connection.
Enter connection options in the following format:
... -o option_name=value option_name=value ...
To enter multiple options, separate them with a space. To enter a value that contains a space or other non-alphanumeric character, enclose the value in quotation marks.
The following table describes the Netezza connection options for infacmd isp CreateConnection and UpdateConnection commands:
Option
Description
connectionString
Required. Name of the ODBC data source that you create to connect to the Netezza database.
jdbcUrl
Required. JDBC URL that the Developer tool must use when it connects to the Netezza database. Use the following format:
jdbc:netezza://<hostname>:<port>/<database name>
username
Required. User name with the appropriate permissions to access the Netezza database.
password
Required. Password for the database user name.
timeout
Required. Number of seconds that the Developer tool waits for a response from the Netezza database before it closes the connection.

OData Connection Options

Use connection options to define an OData connection.
Enter connection options in the following format:
... -o option_name=value option_name=value ...
To enter multiple options, separate them with a space. To enter a value that contains a space or other non-alphanumeric character, enclose the value in quotation marks.
The following table describes the OData connection options for infacmd isp CreateConnection and UpdateConnection commands:
Property
Description
URL
Required. OData service root URL that exposes the data that you want to read.
securityType
Optional. Security protocol that the Developer tool must use to establish a secure connection with the OData server.
Enter one of the following values:
  • - None
  • - SSL
  • - TLS
trustStoreFileName
Required if you enter a security type.
Name of the truststore file that contains the public certificate for the OData server.
trustStorePassword
Required if you enter a security type.
Password for the truststore file that contains the public certificate for the OData server.
keyStoreFileName
Required if you enter a security type.
Name of the keystore file that contains the private key for the OData server.
keyStorePassword
Required if you enter a security type.
Password for the keystore file that contains the private key for the OData server.

ODBC Connection Options

Use connection options to define the ODBC connection.
Enter connection options in the following format:
... -o option_name=value option_name=value ...
To enter multiple options, separate them with a space. To enter a value that contains a space or other non-alphanumeric character, enclose the value in quotation marks.
The following table describes ODBC connection options for infacmd isp CreateConnection and UpdateConnection commands:
Option
Description
PassThruEnabled
Optional. Enables pass-through security for the connection. When you enable pass-through security for a connection, the domain uses the client user name and password to log into the corresponding database, instead of the credentials defined in the connection object.
DataAccessConnectString
Connection string used to access data from the database.
Enter the connection string in the following format:
<database name>
CodePage
Required. Code page used to read from a source database or write to a target database or file.
EnvironmentSQL
Optional. SQL commands to set the database environment when you connect to the database. The Data Integration Service executes the connection environment SQL each time it connects to the database.
For example, ALTER SESSION SET CURRENT_SCHEMA=INFA_USR;
Note: Enclose special characters in double quotes.
TransactionSQL
Optional. SQL commands to execute before each transaction. The Data Integration Service executes the transaction SQL at the beginning of each transaction.
For example, SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
Note: Enclose special characters in double quotes.
QuoteChar
Optional. The character that you will use for quotes in this connection.
The type of character used to identify special characters and reserved SQL keywords, such as WHERE. The Data Integration Service places the selected character around special characters and reserved SQL keywords. The Data Integration Service also uses this character for the QuoteChar property. Default is 4.
ODBC Provider
Optional. The type of database to which the Data Integration Service connects using ODBC. For pushdown optimization, specify the database type to enable the Data Integration Service to generate native database SQL. The options are as follows:
  • - Other
  • - Sybase
  • - Microsoft_SQL_Server
  • - Teradata
  • - Netezza
  • - Greenplum
Default is Other.
EnableQuotes
Optional. Choose to enable quotes or not for this connection.
When enabled, the Data Integration Service places identifier characters around table, view, schema, synonym, and column names when generating and executing SQL against these objects in the connection. Use if the objects have mixed-case or lowercase names. Valid values are True or False. Default is False.
EnableConnectionPool
Optional. Enables connection pooling. When you enable connection pooling, the connection pool retains idle connection instances in memory. When you disable connection pooling, the Data Integration Service stops all pooling activity. Valid values are True or False. Default is True.
ConnectionPoolSize
Optional. Maximum number of idle connections instances that the Data Integration Service maintains for a database connection. Set this value to be more than the minimum number of idle connection instances. Default is 15.
ConnectionPoolMaxIdleTime
Optional. Number of seconds that a connection exceeding the minimum number of connection instances can remain idle before the connection pool drops it. The connection pool ignores the idle time when it does not exceed the minimum number of idle connection instances. Default is 120.
ConnectionPoolMinConnections
Optional. Minimum number of idle connection instances that the pool maintains for a database connection. Set this value to be equal to or less than the idle connection pool size. Default is 0.

Oracle Connection Options

Use connection options to define the Oracle connection.
Enter connection options in the following format:
... -o option_name=value option_name=value ...
To enter multiple options, separate them with a space. To enter a value that contains a space or other non-alphanumeric character, enclose the value in quotation marks.
The following table describes Oracle connection options for infacmd isp CreateConnection and UpdateConnection commands:
Option
Description
PassThruEnabled
Optional. Enables pass-through security for the connection. When you enable pass-through security for a connection, the domain uses the client user name and password to log into the corresponding database, instead of the credentials defined in the connection object.
MetadataAccessConnectString
JDBC connection URL used to access metadata from the database.
jdbc:informatica:oracle://<host_name>:<port>;SID=<database name>
AdvancedJDBCSecurityOptions
Optional. Database parameters for metadata access to a secure database. Informatica treats the value of the AdvancedJDBCSecurityOptions field as sensitive data and encrypts the parameter string.
To connect to a secure database, include the following parameters:
  • - EncryptionMethod. Required. Indicates whether data is encrypted when transmitted over the network. This parameter must be set to SSL.
  • - ValidateServerCertificate. Optional. Indicates whether Informatica validates the certificate that is sent by the database server.
    • If this parameter is set to true, Informatica validates the certificate that is sent by the database server. If you specify the HostNameInCertificate parameter, Informatica also validates the host name in the certificate.
    If this parameter is set to false, Informatica does not validate the certificate that is sent by the database server. Informatica ignores any truststore information that you specify.
  • - HostNameInCertificate. Optional. Host name of the machine that hosts the secure database. If you specify a host name, Informatica validates the host name included in the connection string against the host name in the SSL certificate.
  • - TrustStore. Required. Path and file name of the truststore file that contains the SSL certificate for the database.
  • - TrustStorePassword. Required. Password for the truststore file for the secure database.
  • - KeyStore. Required. Path and file name of the keystore file.
  • - KeyStorePassword. Password for the keystore file for the secure database.
Note: For a complete list of the secure JDBC parameters, see the DataDirect JDBC documentation.
Informatica appends the secure JDBC parameters to the connection string. If you include the secure JDBC parameters directly to the connection string, do not enter any parameters in the AdvancedJDBCSecurityOptions field.
DataAccessConnectString
Connection string used to access data from the database.
Enter the connection string in the following format from the TNSNAMES entry:
<database name>
CodePage
Required. Code page used to read from a source database or write to a target database or file.
EnvironmentSQL
Optional. SQL commands to set the database environment when you connect to the database. The Data Integration Service executes the connection environment SQL each time it connects to the database.
For example, ALTER SESSION SET CURRENT_SCHEMA=INFA_USR;
Note: Enclose special characters in double quotes.
TransactionSQL
Optional. SQL commands to execute before each transaction. The Data Integration Service executes the transaction SQL at the beginning of each transaction.
For example, SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
Note: Enclose special characters in double quotes.
EnableParallelMode
Optional. Enables parallel processing when loading data into a table in bulk mode. Used for Oracle. True or false. Default is false.
QuoteChar
Optional. The character that you will use for quotes in this connection.
The type of character used to identify special characters and reserved SQL keywords, such as WHERE. The Data Integration Service places the selected character around special characters and reserved SQL keywords. The Data Integration Service also uses this character for the QuoteChar property. Default is 0.
EnableQuotes
Optional. Choose to enable quotes or not for this connection.
When enabled, the Data Integration Service places identifier characters around table, view, schema, synonym, and column names when generating and executing SQL against these objects in the connection. Use if the objects have mixed-case or lowercase names. Valid values are True or False. Default is True.
EnableConnectionPool
Optional. Enables connection pooling. When you enable connection pooling, the connection pool retains idle connection instances in memory. When you disable connection pooling, the Data Integration Service stops all pooling activity. Valid values are True or False. Default is True.
ConnectionPoolSize
Optional. Maximum number of idle connections instances that the Data Integration Service maintains for a database connection. Set this value to be more than the minimum number of idle connection instances. Default is 15.
ConnectionPoolMaxIdleTime
Optional. Number of seconds that a connection exceeding the minimum number of connection instances can remain idle before the connection pool drops it. The connection pool ignores the idletime when it does not exceed the minimum number of idle connection instances. Default is 120.
ConnectionPoolMinConnections
Optional. Minimum number of idle connection instances that the pool maintains for a database connection. Set this value to be equal to or less than the idle connection pool size. Default is 0.

Salesforce Connection Options

Use connection options to define a Salesforce connection.
Enter connection options in the following format:
... -o option_name=value option_name=value ...
For example,
infacmd createConnection -dn DomainName -un Domain_UserName -pd Domain_Pwd -cn conname -cid conname -ct SFDC -o userName=salesforceUserName password=salesforcePWD serviceURL=https://login.salesforce.com/services/Soap/u/26.0
To enter multiple options, separate them with a space. To enter a value that contains a space or other non-alphanumeric character, enclose the value in quotation marks.
The following table describes Salesforce connection options for infacmd isp CreateConnection and UpdateConnection commands:
Option
Description
userName
Salesforce user name.
password
Password for the Salesforce user name. The password is case sensitive.
To access Salesforce outside the trusted network of your organization, you must append a security token to your password to log in to the API or a desktop client.
To receive or reset your security token, log in to Salesforce and click Setup > My Personal Information > Reset My Security Token.
serviceURL
URL of the Salesforce service that you want to access. In a test or development environment, you might want to access the Salesforce Sandbox testing environment. For more information about the Salesforce Sandbox, see the Salesforce documentation.

SAP Connection Options

Use connection options to define the SAP connection.
Enter connection options in the following format:
... -o option_name=value option_name=value ...
Separate multiple options with a space. To enter a value that contains a space or other non-alphanumeric character, enclose the value in quotation marks.
The following table describes SAP connection options for infacmd isp CreateConnection and UpdateConnection commands:
Option
Description
UserName
Required. SAP system user name.
Password
Required. Password for the user name.
HostName
Required. Host name of the SAP application.
ClientNumber
Required. SAP client number.
SystemNumber
Required. SAP system number.
Language
Optional. SAP Logon language.

Sequential Connection Options

Use SEQ connection options to define a connection to a sequential z/OS data set.
Enter connection options in the following format:
... -o option_name=value option_name=value ...
To enter multiple options, separate them with a space. To enter a value that contains a space or other non-alphanumeric character, enclose the value in quotation marks.
The following table describes SEQ connection options for infacmd isp CreateConnection and UpdateConnection commands:
Option
Description
CodePage
Required. Code to read from or write to the sequential file. Use the ISO code page name, such as ISO-8859-6. The code page name is not case sensitive.
ArraySize
Optional. Determines the number of records in the storage array for the threads when the worker threads value is greater than 0. Valid values are from 1 through 100000. Default is 25.
Compression
Optional. Compresses the data to decrease the amount of data that Informatica applications write over the network. True or false. Default is false.
EncryptionLevel
Optional. Level of encryption for RC2 or DES for encryption types. Enter one of the following values for the encryption level:
  • - 1. Use a 56-bit encryption key for DES and RC2.
  • - 2. Use a 168-bit triple DES encryption key for DES or a 64-bit encryption keyfor RC2.
  • - 3. Use a 168-bit triple DES encryption key for DES or a 128-bit encryption key for RC2.
Default is 1.
Note: If you select None for encryption type, the Data Integration Service ignores the encryption level value.
EncryptionType
Optional. Enter one of the following values for the encryption type:
  • - None
  • - RC2
  • - DES
Default is None.
InterpretAsRows
Optional. If true, the pacing size value represents a number of rows. If false, the pacing size represents kilobytes. Default is false.
Location
Location of the PowerExchange Listener node that can connect to the data source. The location is defined in the first parameter of the NODE statement in the PowerExchange dbmover.cfg configuration file.
OffLoadProcessing
Optional. Moves bulk data processing from the data source machine to the Data Integration Service machine.
Enter one of the following values:
  • - Auto. The Data Integration Service determines whether to use offload processing.
  • - Yes. Use offload processing.
  • - No. Do not use offload processing.
Default is Auto.
PacingSize
Optional. Slows the data transfer rate in order to reduce bottlenecks. The lower the value, the greater the session performance. Minimum value is 0. Enter 0 for optimal performance. Default is 0.
WorkerThread
Optional. Number of threads that the Data Integration Service uses to process bulk data when offload processing is enabled. For optimal performance, this value should not exceed the number of available processors on the Data Integration Service machine. Valid values are 1 through 64. Default is 0, which disables multithreading.
WriteMode
Enter one of the following write modes:
  • - CONFIRMWRITEON. Sends data to the Data Integration Service and waits for a success/no success response before sending more data.
  • - CONFIRMWRITEOFF. Sends data to the Data Integration Service without waiting for a success/no success response. Use this option when the target table can be reloaded if an error occurs.
  • - ASYNCHRONOUSWITHFAULTT. Sends data to the Data Integration Service asynchronously with the ability to detect errors.
Default is CONFIRMWRITEON.
EnableConnectionPool
Optional. Enables connection pooling. When you enable connection pooling, the connection pool retains idle connection instances in memory. When you disable connection pooling, the Data Integration Service stops all pooling activity. True or false. Default is false.
ConnectionPoolSize
Optional. Maximum number of idle connections instances that the Data Integration Service maintains for a database connection. Set this value to be more than the minimum number of idle connection instances. Default is 15.
ConnectionPoolMaxIdleTime
Optional. Number of seconds that a connection exceeding the minimum number of connection instances can remain idle before the connection pool drops it. The connection pool ignores the idletime when it does not exceed the minimum number of idle connection instances. Default is 120.
ConnectionPoolMinConnections
Optional. Minimum number of idle connection instances that the pool maintains for a database connection. Set this value to be equal to or less than the idle connection pool size. Default is 0.

Teradata Parallel Transporter Connection Options

Use connection options to define a Teradata PT connection.
Enter connection options in the following format:
... -o option_name='value' option_name='value' ...
To enter multiple options, separate them with a space. To enter a value that contains a space or other non-alphanumeric character, enclose the value in quotation marks.
The following table describes Teradata PT connection options for infacmd isp CreateConnection and UpdateConnection commands:
Option
Description
UserName
Required. Teradata database user name with the appropriate write permissions to access the database.
Password
Required. Password for the Teradata database user name.
DriverName
Required. Name of the Teradata JDBC driver.
ConnectionString
Required. JDBC URL to fetch metadata.
TDPID
Required. Name or IP address of the Teradata database machine.
databaseName
Required. Teradata database name.
If you do not enter a database name, Teradata PT API uses the default login database name.
DataCodePage
Optional. Code page associated with the database.
When you run a mapping that loads to a Teradata target, the code page of the Teradata PT connection must be the same as the code page of the Teradata target.
Default is UTF-8.
Tenacity
Optional. Number of hours that Teradata PT API continues trying to log on when the maximum number of operations run on the Teradata database.
Must be a positive, non-zero integer. Default is 4.
MaxSessions
Optional. Maximum number of sessions that Teradata PT API establishes with the Teradata database.
Must be a positive, non-zero integer. Default is 4.
MinSessions
Optional. Minimum number of Teradata PT API sessions required for the Teradata PT API job to continue.
Must be a positive integer between 1 and the Max Sessions value. Default is 1.
Sleep
Optional. Number of minutes that Teradata PT API pauses before it retries to log on when the maximum number of operations run on the Teradata database.
Must be a positive, non-zero integer. Default is 6.
useMetadataJdbcUrl
Optional.
Set this option to true to Indicate that the Teradata Connector for Hadoop (TDCH) must use the JDBC URL that you specified in the connection string.
Set this option to false to specify a different JDBC URL that TDCH must use when it runs the mapping.
tdchJdbcUrl
Required.
JDBC URL that TDCH must use when it runs the mapping.
dataEncryption
Required.
Enables full security encryption of SQL requests, responses, and data on Windows.
To enable data encryption on Unix, add the command UseDataEncryption=Yes to the DSN in the odbc.ini file.

Twitter Connection Options

Use connection options to define a Twitter connection.
Enter connection options in the following format:
... -o option_name=value option_name=value ...
To enter multiple options, separate them with a space. To enter a value that contains a space or other non-alphanumeric character, enclose the value in quotation marks.
The following table describes Twitter connection options for infacmd isp CreateConnection and UpdateConnection commands:
Option
Description
ConsumerKey
The consumer key that you get when you create the application in Twitter. Twitter uses the key to identify the application.
ConsumerSecret
The consumer secret that you get when you create the Twitter application. Twitter uses the secret to establish ownership of the consumer key.
AccessToken
Access token that the OAuth Utility returns. Twitter uses this token instead of the user credentials to access the protected resources.
AccessSecret
Access secret that the OAuth Utility returns. The secret establishes ownership of a token.

Twitter Streaming Connection Options

Use connection options to define a Twitter Streaming connection.
Enter connection options in the following format:
... -o option_name=value option_name=value ...
To enter multiple options, separate them with a space. To enter a value that contains a space or other non-alphanumeric character, enclose the value in quotation marks.
The following table describes Twitter Streaming connection options for infacmd isp CreateConnection and UpdateConnection commands:
Option
Description
HoseType
Streaming API methods. You can specify the following methods:
  • - Filter. The Twitter statuses/filter method returns public statuses that match the search criteria.
  • - Sample. The Twitter statuses/sample method returns a random sample of all public statuses.
UserName
Twitter user screen name.
Password
Twitter password.

VSAM Connection Options

Use connection options to define a VSAM connection.
Enter connection options in the following format:
... -o option_name=value option_name=value ...
To enter multiple options, separate them with a space. To enter a value that contains a space or other non-alphanumeric character, enclose the value in quotation marks.
The following table describes VSAM connection options for infacmd isp CreateConnection and UpdateConnection commands:
Option
Description
CodePage
Required. Code to read from or write to the VSAM file. Use the ISO code page name, such as ISO-8859-6. The code page name is not case sensitive.
ArraySize
Optional. Determines the number of records in the storage array for the threads when the worker threads value is greater than 0. Valid values are from 1 through 100000. Default is 25.
Compression
Optional. Compresses the data to decrease the amount of data Informatica applications write over the network. True or false. Default is false.
EncryptionLevel
Optional. Level of encryption for RC2 or DES for encryption types. Enter one of the following values for the encryption level:
  • - 1. Use a 56-bit encryption key for DES and RC2.
  • - 2. Use a 168-bit triple DES encryption key for DES or a 64-bit encryption keyfor RC2.
  • - 3. Use a 168-bit triple DES encryption key for DES or a 128-bit encryption key for RC2.
Default is 1.
Note: If you select None for encryption type, the Data Integration Service ignores the encryption level value.
EncryptionType
Optional. Enter one of the following values for the encryption type:
  • - None
  • - RC2
  • - DES
Default is None.
InterpretAsRows
Optional. If true, the pacing size value represents a number of rows. If false, the pacing size represents kilobytes. Default is false.
Location
Location of the PowerExchange listener node that can connect to VSAM. The node is defined in the PowerExchange dbmover.cfg configuration file.
OffLoadProcessing
Optional. Moves bulk data processing from the VSAM source to the Data Integration Service machine.
Enter one of the following values:
  • - Auto. The Data Integration Service determines whether to use offload processing.
  • - Yes. Use offload processing.
  • - No. Do not use offload processing.
Default is Auto.
PacingSize
Optional. Slows the data transfer rate in order to reduce bottlenecks. The lower the value, the greater the session performance. Minimum value is 0. Enter 0 for optimal performance. Default is 0.
WorkerThread
Optional. Number of threads that the Data Integration Service uses to process bulk data when offload processing is enabled. For optimal performance, this value should not exceed the number of available processors on the Data Integration Service machine. Valid values are 1 through 64. Default is 0, which disables multithreading.
WriteMode
Enter one of the following write modes:
  • - CONFIRMWRITEON. Sends data to the Data Integration Service and waits for a success/no success response before sending more data.
  • - CONFIRMWRITEOFF. Sends data to the Data Integration Service without waiting for a success/no success response. Use this option when the target table can be reloaded if an error occurs.
  • - ASYNCHRONOUSWITHFAULTT. Sends data to the Data Integration Service asynchronously with the ability to detect errors.
Default is CONFIRMWRITEON.
EnableConnectionPool
Optional. Enables connection pooling. When you enable connection pooling, the connection pool retains idle connection instances in memory. When you disable connection pooling, the Data Integration Service stops all pooling activity. True or false. Default is false.
ConnectionPoolSize
Optional. Maximum number of idle connections instances that the Data Integration Service maintains for a database connection. Set this value to be more than the minimum number of idle connection instances. Default is 15.
ConnectionPoolMaxIdleTime
Optional. Number of seconds that a connection exceeding the minimum number of connection instances can remain idle before the connection pool drops it. The connection pool ignores the idletime when it does not exceed the minimum number of idle connection instances. Default is 120.
ConnectionPoolMinConnections
Optional. Minimum number of idle connection instances that the pool maintains for a database connection. Set this value to be equal to or less than the idle connection pool size. Default is 0.

Web Content-Kapow Katalyst Connection Options

Use connection options to define a Web Content-Kapow Katalyst connection.
Enter connection options in the following format:
... -o option_name=value option_name=value ...
To enter multiple options, separate them with a space. To enter a value that contains a space or other non-alphanumeric character, enclose the value in quotation marks.
The following table describes Web Content-Kapow Katalyst connection options for infacmd isp CreateConnection and UpdateConnection commands:
Option
Description
ManagementConsoleURL
URL of the Local Management Console where the robot is uploaded.
The URL must start with http or https. For example, http://localhost:50080.
RQLServicePort
The port number where the socket service listens for the RQL service.
Enter a value from 1 through 65535. Default is 50000.
Username
User name required to access the Local Management Console.
Password
Password to access the Local Management Console.