Setting up an Environment for your Production or Sandbox instances is straightforward and easy to manage

Environment Setup

Opening a given Environment from the definition window produces the second main window below where you configure a specific Environment, refer to the attributes reference that follows for detailed guidance, although at a minimum, to get started immediately, you’ll need to enter:

  • Sandbox (checkbox, hence tick/not ticked)
  • Licence Key provided to you (whether full/paid or trial)
  • Username
  • Password
  • Security Token
  • Working Path
AttributeNotes
EnvironmentAn Environment defines each unique connection to a Salesforce instance, whether that is a Sandbox or a Production Org, all connection work is done against this Name
SandboxClick this checkbox if your given Environment is a sandbox. Note, there are no licence restrictions imposed on accessing a sandbox, regardless of the Salesforce Org they belong to (i.e. even Orgs different to the one(s) you have licenced have no cost implication).
UsernameThe Salesforce User used in the connection. This will be a Production username for your Production instance, or if you’re defining a sandbox Environment, then a sandbox username.
PasswordThe Password of your username (text security obscured)
Security TokenThe Security Token of your username (text security obscured)
Working PathSQL Sales for the BULK Connection Method makes temporary use of a working directory on a drive available to the SQL Server. No data is held at rest and you are advised to check there is suitable spare capacity on the drive which hosts this directory.
ChunksizeDefaulted to 100000. SQL Sales will chunk internal data processing to this setting, separate to any api batchsize you may have specified for a given replication or data operation. Note, for certain heavier data operations, the specified Chunksize may be automatically lowered to achieve optimal data transfer between Salesforce and SQL Server.
Boolean fields as bitSalesforce will by default return boolean fields as TRUE or FALSE, which SQL Server handles in a varchar(5) datatype. Working in SQL Server it is often preferable to work with a bit datatype.
BulkAPI: allow null updatesBy default when using the loading to Salesforce with the BULKAPI, you are not permitted to update a field with an null, this setting overrides that
DropSSIdWhen loading to Salesforce, via a SQL Server table, SQL Sales will define a primary key
InstanceThis is your Salesforce instance url, click on “Gather Instance & urn” to populate for your given username. By default this will return your current Salesforce api version for your end point. This will always be the latest api version you are set to, however this can be customised to a specific older api version if that is relevant to your particular requirements. Customise by altering the api version number in the Instance string.
urnThis is your urn, which by default will return the urn for your Salesforce end point as defined by your username. Customise this if necessary for your particular requirements, typically you would expect to have one of these two:urn:enterprise.soap.sforce.comurn:partner.soap.sforce.comGenerally, just accept the defaut returned for you
Load ContentVersion as data, not from fileWhen loading files to Salesforce, typically this is achieved by providing the path to a file located on a drive accessible by SQL Sales, in a UNC location. Alternatively, by checking this option, you can provide the file as a field in a SQL Server table (see detail in the ss_Loader stored procedure).
Include base64 fields with replica/deltaBy default, when replicating (via ss_Replica & ss_Delta), Salesforce fields which contain Content (base64) data are not included as they are binary data-heavy. If you require this data, check this box.
Connection Method (BULK/ODBC)BULK (for the bulk text based method)ODBC (for ODBC)Typically BULK is quicker but you decide what works best for your situation.
LoggingDefault is 0-OFF. The log file is created in the same location as the setup “Configuration Path Selection”. Generally, logging is not necessary and certainly 1-DEBUG should only be used when diagnosing issues with SQL-Sales support
0-OFF
1-DEBUG
2-INFO
3-WARNING
4-ERROR
5-CRITICAL
ODBC: SQL ServerApplicable only for the ODBC method: specify your SQL Server, this will be the server on which you have installed SQL Sales
ODBC: Use trusted connectionApplicable only for the ODBC method: If applicable to your setup and how you have installed SQL Sales (i.e. how you are running SQL Sales). Check this if Windows trusted connection is applicable to your use case.
ODBC: SQL LoginApplicable if connecting via a SQL Server login (i.e. not trusted connection).
ODBC: SQL PasswordApplicable if connecting via a SQL Server login (i.e. not trusted connection). (text security obscured)
ODBC: DriverList of available drivers available on your specified SQL Server.
Integration UsernameThe API or integration Username specified in the [sub] (subject) claim of the JWT token (when using OAuth 2.0 to authenticate and connect to Salesforce).
Custom Connected AppEach configured Environment in each installation of SQL-Sales will require a custom connected app setting up, enter the name here, for the given Environment (when using OAuth 2.0 to authenticate and connect to Salesforce).
Consumer KeyConsumer key, copied from the above custom connected app (when using OAuth 2.0 to authenticate and connect to Salesforce).
Expiration (days)Enter a numeric value between 1 and 365. This inputs to the certificate validity period which you’ll create, for passing to the custom connected app when setting it up (when using OAuth 2.0 to authenticate and connect to Salesforce).
“Create Certificate” buttonThis will generate and pass a new digital certificate to your clipboard, for you to save as a .pem file for uploading to your custom connected app. The certificate is not held at rest within SQL-Sales. (Only applicable when using OAuth 2.0 to authenticate and connect to Salesforce).
“Drop Certificate” buttonInstantly revoke an existing certificate (only applicable when using OAuth 2.0 to authenticate and connect to Salesforce).