Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.
Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Administrator
  • All Products

Table of Contents

Search

  1. Preface
  2. Connectors and connections
  3. Connection configuration
  4. ActiveCampaign connection properties
  5. Adabas CDC Connection Properties
  6. Adabas connection properties
  7. Adaptive Insights Connection Properties
  8. Adobe Analytics connection properties
  9. Adobe Analytics Mass Ingestion connection properties
  10. Adobe Experience Platform connection properties
  11. Advanced FTP Connection properties
  12. Advanced FTP V2 connection properties
  13. Advanced FTPS connection properties
  14. Advanced FTPS V2 connection properties
  15. Advanced SFTP connection properties
  16. Advanced SFTP V2 connection properties
  17. Amazon Athena connection properties
  18. Amazon Aurora connection properties
  19. Amazon DynamoDB connection properties
  20. Amazon DynamoDB V2 connection properties
  21. Amazon Kinesis connection properties
  22. Amazon Redshift connection properties
  23. Amazon Redshift V2 connection properties
  24. Amazon S3 connection properties
  25. Amazon S3 V2 connection properties
  26. Amplitude connection properties
  27. AMQP connection properties
  28. Anaplan V2 connection properties
  29. Ariba V2 connection properties
  30. AS2 connection properties
  31. Azure AI Search connection properties
  32. BigMachines connection properties
  33. Birst Cloud Connect connection properties
  34. Box connection properties
  35. Business 360 connection properties
  36. Business 360 Events connection properties
  37. Business 360 FEP connection properties
  38. CallidusCloud Commissions connection properties
  39. CallidusCloud File Processor connection properties
  40. Cassandra V2 connection properties
  41. Chatter connection properties
  42. Cloud Integration Hub connection properties
  43. Concur connection properties
  44. Concur V2 connection properties
  45. Couchbase connection properties
  46. Coupa connection properties
  47. Coupa V2 connection properties
  48. Cvent connection properties
  49. Databricks connection properties
  50. Datacom CDC Connection Properties
  51. Datacom Connection Properties
  52. Db2 Data Map connection properties
  53. Db2 for i CDC connection properties
  54. Db2 for i connection properties
  55. Db2 for i Database Ingestion connection properties
  56. Db2 for LUW CDC connection properties
  57. Db2 for LUW Database Ingestion connection properties
  58. Db2 for z/OS Bulk Load connection properties
  59. Db2 for z/OS CDC connection properties
  60. Db2 for z/OS connection properties
  61. Db2 for zOS Database Ingestion connection properties
  62. Db2 for z/OS Image Copy connection properties
  63. Db2 for z/OS Unload File connection properties
  64. DB2 Loader connection properties
  65. Db2 Warehouse on Cloud connection properties
  66. Domo connection properties
  67. Dropbox connection properties
  68. Elasticsearch connection properties
  69. Eloqua Bulk API connection properties
  70. Eloqua REST connection properties
  71. FHIR connection properties
  72. File List connection properties
  73. File Processor connection properties
  74. FileIO connection properties
  75. Flat file connections
  76. FTP/SFTP connections
  77. Google Ads connection properties
  78. Google Analytics connection properties
  79. Google Analytics Mass Ingestion connection properties
  80. Google BigQuery connection properties
  81. Google BigQuery V2 connection properties
  82. Google Bigtable connection properties
  83. Google Cloud Storage connection properties
  84. Google Cloud Storage V2 connection properties
  85. Google Drive connection properties
  86. Google PubSub - Streaming Ingestion and Replication connection properties
  87. Google PubSub connection properties
  88. Google PubSub V2 connection properties
  89. Google Sheets connection properties
  90. Google Sheets V2 connection properties
  91. Greenplum connection properties
  92. Hadoop connection properties
  93. Hadoop Files connection properties
  94. Hadoop Files V2 connection properties
  95. Hive connection properties
  96. HubSpot connection properties
  97. IBM MQ connection properties
  98. IMS CDC Connection Properties
  99. IMS connection properties
  100. JD Edwards EnterpriseOne connection properties
  101. JDBC connection properties
  102. JDBC V2 connection properties
  103. JIRA Cloud connection properties
  104. JMS connection properties
  105. Jira connection properties
  106. JSON Target connection properties
  107. Kafka connection properties
  108. Klaviyo connection properties
  109. Large Language Model connection properties
  110. LDAP connection properties
  111. Magento V1 connection properties
  112. Mailchimp connection properties
  113. Marketo V3 connection properties
  114. Microsoft Access connection properties
  115. Microsoft Azure Analysis Services connection properties
  116. Microsoft Azure Blob Storage V2 connection properties
  117. Microsoft Azure Blob Storage V3 connection properties
  118. Microsoft Azure Cosmos DB SQL API connection properties
  119. Microsoft Azure Data Lake Storage Gen2 connection properties
  120. Microsoft Azure DocumentDB Connection Properties
  121. Microsoft Azure Event Hub connection properties
  122. Microsoft Azure SQL Data Warehouse - Database Ingestion connection properties
  123. Microsoft Azure SQL Data Warehouse connection properties
  124. Microsoft Azure SQL Data Warehouse V2 connection properties
  125. Microsoft Azure Synapse Analytics connection properties
  126. Microsoft Azure Synapse Analytics Database Ingestion connection properties
  127. Microsoft Azure Synapse SQL connection properties
  128. Microsoft CDM Folders V2 connection properties
  129. Microsoft Dynamics 365 for Operations connection properties
  130. Microsoft Dynamics 365 for Sales connections
  131. Microsoft Dynamics 365 Mass Ingestion connection properties
  132. Microsoft Dynamics CRM connection properties
  133. Microsoft Dynamics NAV connection properties
  134. Microsoft Excel connection properties
  135. Microsoft Fabric Data Warehouse connection properties
  136. Microsoft Fabric Lakehouse connection properties
  137. Microsoft Fabric OneLake connection properties
  138. Microsoft Power BI connection properties
  139. Microsoft SharePoint connection properties
  140. Microsoft Sharepoint Online connection properties
  141. Microsoft SQL Server CDC connection properties
  142. Microsoft SQL Server connection properties
  143. Mixpanel connection properties
  144. MLLP connection properties
  145. MongoDB Mass Ingestion connection properties
  146. MongoDB connection properties
  147. MongoDB V2 connection properties
  148. MQTT connection properties
  149. MRI Software connection properties
  150. MySQL CDC connection properties
  151. MySQL connection properties
  152. Netezza connection properties
  153. NetSuite connection properties
  154. NetSuite Mass Ingestion connection properties
  155. NetSuite RESTlet V2 connection properties
  156. NICE Satmetrix connection properties
  157. OData connections properties
  158. OData consumer connection properties
  159. OData V2 Protocol Reader connection properties
  160. OData V2 Protocol Writer connection properties
  161. ODBC connection properties
  162. OpenAir connection properties
  163. Open Table connection properties
  164. Oracle connection properties
  165. Oracle Autonomous Database connections
  166. Oracle Business Intelligence Publisher connection properties
  167. Oracle CDC V2 connection properties
  168. Oracle Cloud Object Storage connections
  169. Oracle CRM Cloud V1 connections properties
  170. Oracle CRM On Demand connection properties
  171. Oracle Database Ingestion connection properties
  172. Oracle Financials Cloud V1 connection properties
  173. Oracle Fusion Cloud Mass Ingestion connection properties
  174. Oracle HCM Cloud V1 connection properties
  175. Pinecone connection properties
  176. PostgreSQL CDC connection properties
  177. PostgreSQL connection properties
  178. QuickBooks V2 Connection Properties
  179. Redis connection properties
  180. REST API connection properties
  181. REST V2 connection properties
  182. REST V3 Connection Properties
  183. Salesforce Analytics connection properties
  184. Salesforce Commerce Cloud connection properties
  185. Salesforce connection properties
  186. Salesforce Data Cloud connection properties
  187. Salesforce Marketing Cloud connection properties
  188. Salesforce Mass Ingestion connection properties
  189. Salesforce Pardot connection properties
  190. SAP connection properties
  191. SAP ADSO Writer connection properties
  192. SAP BAPI connection properties
  193. SAP BW Connector connection properties
  194. SAP BW BEx Query connection properties
  195. SAP HANA CDC Connection Properties
  196. SAP HANA connection properties
  197. SAP HANA Database Ingestion connection properties
  198. SAP IQ connection properties
  199. SAP Mass Ingestion connection properties
  200. SAP OData V2 connection properties
  201. SAP OData V4 connection properties
  202. SAP ODP Extractor connection properties
  203. SAP Table Connector connection properties
  204. SAS connection properties
  205. Satmetrix connection properties
  206. Sequential File connection properties
  207. ServiceNow connection properties
  208. ServiceNow Mass Ingestion connection properties
  209. Shopify connection properties
  210. Slack connection properties
  211. Snowflake connection properties
  212. Snowflake Data Cloud connection properties
  213. Stripe connection properties
  214. SuccessFactors LMS connection properties
  215. Successfactor ODATA connection properties
  216. SuccessFactors SOAP connection properties
  217. SurveyMonkey connection properties
  218. Tableau V2 connection properties
  219. Tableau V3 connection properties
  220. Teradata connection properties
  221. UKGPro V2 connection properties
  222. UltiPro connection properties
  223. Veeva Vault connection properties
  224. VSAM CDC connection properties
  225. VSAM connection properties
  226. Web Service Consumer connection properties
  227. WebServices V2 connection properties
  228. Workday connection properties
  229. Workday Mass Ingestion connection properties
  230. Workday V2 connection properties
  231. Xactly connection properties
  232. Xero connection properties
  233. XML Source connection properties
  234. XML Target connection properties
  235. Yellowbrick Data Warehouse connection properties
  236. Zendesk connection properties
  237. Zendesk Mass Ingestion connection properties
  238. Zendesk V2 connection properties
  239. Zuora AQuA Connection properties
  240. Zuora connection properties
  241. Zuora REST V2 connection properties

Connections

Connections

Back Next

Connection details

Connection details

The following table describes the basic connection properties:
Property
Description
Connection Name
Name of the connection.
Each connection name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -,
Maximum length is 255 characters.
Description
Description of the connection. Maximum length is 4000 characters.
Type
db2loader
Use Secret Vault
Stores sensitive credentials for this connection in the secrets manager that is configured for your organization.
This property appears only if secrets manager is set up for your organization.
This property is not supported by
Data Ingestion and Replication
.
When you enable the secret vault in the connection, you can select which credentials that the Secure Agent retrieves from the secrets manager. If you don't enable this option, the credentials are stored in the repository or on a local Secure Agent, depending on how your organization is configured.
For information about how to configure and use a secrets manager, see
"Secrets manager configuration" in the Administrator help
.
Runtime Environment
The name of the runtime environment where you want to run tasks.
Select a Secure Agent.
Host Name
The name of the machine that hosts the DB2 database server.
Database Name
The name of the DB2 database.
Port Number
The port number that connects to the DB2 database server.
Default is 50000.
Schema Name
The schema name in the DB2 database server to fetch the metadata.
This property doesn't apply when you configure a DB2 Loader connection.
User Name
The user name to connect to the DB2 account.
Password
The password to connect to the DB2 account.
Connection String
The alias name to connect to the DB2 database.

Advanced settings

The following table describes the advanced connection properties:
Property
Description
Encryption Method
Encrypts data exchanged between the Secure Agent and the database server.
Select one of the following encryption methods from the list:
  • No Encryption. Establishes a connection without using SSL. Data is not encrypted.
  • SSL. Establishes a connection using SSL. Data is encrypted using SSL.
Default is No Encryption.
Validate Server Certificate
Determines whether the Secure Agent validates the certificate that is sent by the database server.
This property appears only if you select the encryption method as
SSL
.
Select one of the following options from the list:
  • False. The Secure Agent does not validate the certificate.
  • True. The Secure Agent validates the certificate.
Default is False.
Truststore
The path and file name of the truststore file that contains the SSL certificate to connect to DB2.
This property appears only if you select the encryption method as
SSL
 and validate server certificate as
True
.
Specify both the directory and file name in the following format:
/root/<folder name>/<truststore file name>.p12
Truststore Password
The password to access the truststore file that contains the SSL certificate.
This property appears only if you select the encryption method as
SSL
 and validate server certificate as
True
.
Host Name in Certificate
The name of the machine that hosts the secure database.
This property appears only if you select the encryption method as
SSL
 and validate server certificate as
True
.
The Secure Agent validates the host name specified in this property with the host name in the SSL certificate.
Authentication Method
The authentication method that the driver uses to establish a connection.
Select one of the following authentication methods from the list:
  • Clear Text. Sends the user ID and password in clear text to the DB2 server for authentication.
  • Encrypted Password. Sends the user ID in clear text and encrypted password to the DB2 server for authentication.
Default is Clear Text.
Is Staged
Method to load data.
Select
Is Staged
 to load data to a flat file staging area before loading to the database.
Default is disabled.
Recoverable
Sets the DB2 tablespace in backup pending state.
Before you enable the
Recoverable
 option and run a mapping, you need to fully back up the database to perform any other operation on the tablespace.
Default is enabled.
DB2 Server Location
The DB2 database server location.
Select one of the following locations from the list:
  • Remote. The DB2 database server resides on another machine.
  • Local. The DB2 database server resides on the Secure Agent machine.
Default is Remote.
External Loader Executable
The DB2 external loader executable file name.
The Secure Agent uses the DB2 external loader executable file of the IBM data server client 9.5 version and later.
Default is db2load.
Operation Mode
The operation for DB2 external loader to perform.
Select one of the following operation modes to determine how the DB2 external loader writes data to the target table based on the mode that you selected in the DB2 external loader:
  • Insert. Loads data to the table.
  • Replace. Deletes existing data from the table, and then adds data to the table.
  • Restart. Restarts a previously interrupted load operation.
  • Terminate. Terminates a previously interrupted load operation and rolls back the operation to the starting point, even if consistency points are passed.
Default is Insert.
Additional Metadata Connection Properties
Additional metadata connection properties that you want to pass to the driver. If you specify more than one property, separate each key-value pair with a semicolon.
For example, <parameter name1>=<value1> ; <parameter name2>=<value2>
0 COMMENTS
We’d like to hear from you!