Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.

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

Connections

Connections

Advanced FTPS connection properties

Advanced FTPS connection properties

When you set up an Advanced FTPS connection, you must configure the connection properties.
The following table describes the Advanced FTPS connection properties:
Connection property
Description
Runtime Environment
The name of the runtime environment that contains the Secure Agent that you want to run the tasks.
Host
The host name or IP address of the server.
Port
The port number to use for connecting to the server. If left blank, the default port number is 21.
Username
User name to connect to the FTPS server.
Password
Password to connect to the FTPS server.
Folder Path
The directory to use after connecting to the server.
Use passive mode
Indicates whether the connection uses
Passive
or
Active
mode. Specify
Yes
to use
Passive
mode. Specify
No
to use
Active
mode.
The default value is
Yes
.
In Active mode, the server will attempt to connect back to a port on the connection client in order to perform the data transfer.
In Passive mode, the server does not need to connect back to a port on the connection client, which is a more firewall-friendly mode. Therefore, if you have problems with connecting to the server, you may want to change the mode to Passive by selecting
Yes
for this option.
Data Connection Start Port
The starting port number to use for the data connection.
Data Connection End Port
The ending port number to use for the data connection.
Timeout
The number of seconds to wait when attempting to connect to the server. A timeout will occur if the connection cannot be established in the specified amount of time. If left blank, the default timeout is 120 seconds.
Connection Retry Attempts
The number of times to connect to retry the FTPS connection if a connection cannot be established. This setting is used for both the initial connection and any reconnect attempts due to lost connections. If left blank, then no retries will be attempted.
Connection Retry Interval
The number of seconds to wait between each connection retry attempt.
For instance, if you want to retry to connect up to 10 times with a five second delay between retries, then specify
10
for the
Connection Retry Attempts
and
5
for the
Connection Retry
Interval.
Control Encoding
If left blank, the connection uses the ISO standard ISO-8859-1. If supported by the server, other encodings like UTF-8 can be specified to support international characters.
Trusted Server
Specify whether the FTPS server is a trusted server. The FTPS Connector only supports a trusted server.
List Parser
The list parser to use for the server connection. If the field is empty, the Advanced FTPS Connector tries to use the MLSD parser. If the server does not support the MLSD parser, the connector uses the UNIX parser. If you experience problems listing directories, select a different list parser.
Date Format
This date format is applied if the server returns a date that is different from the selected list parser default. If your location requires a different date format (for example, d MMM yyyy), specify the date format in this field. Not all list parsers support the date format setting. List parsers that do not support the date format setting will ignore any user specified values.
Recent Date Format
Specify the date format to use when parsing the recent last modified date for each file. The recent date format applies in UNIX-based systems and appears on entries less than a year old. If your location requires a specific date format (for example, d MMM HH:mm), specify that pattern in this field. Not all list parsers support the recent date format setting. List parsers that do not support the recent date format setting will ignore any user-specified values.

0 COMMENTS

We’d like to hear from you!