DBAmp Configuration Properties
DBAmp Configuration Properties
The following table describes the configuration properties that control how DBAmp connects to Salesforce, processes data, and manages performance, data types, and system behavior.
| Parameter | Description |
|---|---|
| API Version | Specifies the API that you want DBAmp to use. Leaving this field blank sets the API to the latest supported Salesforce version. |
| Bulk Polling Interval | Specifies the number of milliseconds (ms) DBAmp waits between querying for BulkAPI job completion. The default number is 60000 ms. |
| Bulk Query Timeout | Specifies the time in minutes for which the provider waits for a bulk query response. The default time is 60 minutes. |
| DBAmp Blob Directory | Specifies a directory for DBAmp Blob. This local directory contains downloaded files containing the content of binary fields for a Salesforce object. |
| DBAmp Booleans as Strings | Can be set to True or False. If this parameter is set to True, DBAmp reports Salesforce checkbox and Boolean fields as NVARCHAR(5); otherwise, it reports them using the BIT data type. |
| DBAmp Numbers as Decimals | Specifies whether to report Number fields as decimals instead of floats. |
| DBAmp Work Directory | Specifies a directory for DBAmp Work. |
| Include Binary Field Values | Specifies how DBAmp handles large binary files when downloading them from Salesforce. The default setting is False, which specifies that DBAmp should exclude the files. |
| Local Port | Specifies the port number to use. The default port is 1435. |
| Location | Specifies the installation directory for DBAmp if it was not installed in the default location. |
| Max Connections | Specifies the number of connections allowed at a time. The default number of connections is 20. |
| Max Threads | Specifies the number of threads allowed at a time. The default number of threads is 20. |
| Metadata Override | Modifies the scale of a decimal field or the length of a string field. In some cases, Salesforce.com returns data with a greater scale than the reported metadata allows. |
| Minimum Long Size | Specifies the length of all NVARCHAR fields in Salesforce. Any field of a length greater than the specified value are created as NVARCHAR(MAX). The default length is 4000. |
| Network Receive Timeout | Specifies the number of seconds DBAmp waits for a response from the Salesforce server. If you receive an Operation Timed Out error, increase this value. |
| Other | Set ConvertDateTimeToGMT=true to convert your local time to UTC. The default value is "". |
| Report Date as DateTime2 | Specifies whether Salesforce date fields are reported as DATETIME2 instead of date. |
| Report Text as Varchar | Specifies whether Salesforce text fields are reported as VARCHAR instead of NVARCHAR. |
| Report Time as NVarchar | Can be set to True or False. If this parameter is set to True, DBAmp reports Salesforce time fields as type NVARCHAR(40); otherwise, it reports them using the TIME(7) type. |
| SQL Login Init String | Enter your SQL Server credentials. If you use Windows Authentication or Integrated Security, use the default value of Trusted_Connection=Yes. |
| Translate Picklist Fields | Specifies whether to return translated values for picklist fields. |