How to connect to a Salesforce Sandbox?
With the deprecation of the old JDBC connections to Salesforce, I am unable to connect to a sandbox environment using the Salesforce connector. In order to connect to a sandbox, the connector needs to explicitly communicate that the environment is a sandbox. When using SSIS and connecting to Salesforce, there is a key/value that says" Use Sandbox = "True" (or False). The older CData JDBC driver allowed me to add additional parameters in the URL. The Salesforce connector works fine in non-sandbox environments.