DBAmp Configuration Properties

Parameter	Description
API Version	Specifies the API 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 DBAmp waits between querying for BulkAPI job completion. The default is 60000 ms.
Bulk Query Timeout	Specifies the time in minutes for which the provider waits for a bulk query response. The default is 60 minutes.
DBAmp Blob Directory	Specifies a directory for DBAmp Blob. This is a local directory that holds downloaded files containing the binary field(s) content of a Salesforce object.
DBAmp Booleans as Strings	True or False. If True, DBAmp reports Salesforce checkboxes and Boolean fields as nvarchar(5), otherwise, it uses bit.
DBAmp Work Directory	Specifies a directory for DBAmp Work.
Include Binary Field Values	Specifies how DBAmp handles large binary files when downloading from Salesforce. The default is “False” (exclude).
Max Connections	Specifies the number of connections allowed at a time. The default is 20.
Max Threads	Specifies the number of threads allowed at a time. The default 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 fields of length greater than the specified value are created as nvarchar(max). The default 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 is “”.
Report Time as NVarchar	True or False. If True, DBAmp reports Salesforce time fields as nvarchar(40); otherwise, it uses time(7).
SQL Login Init String	Enter your SQL Server credentials. If you are using Windows Authentication or Integrated Security, use the default value of Trusted_Connection=Yes.