Creating a Data Source Name
Typically, after installing the Simba Salesforce ODBC Driver, you need to create a Data Source Name (DSN).
Alternatively, for information about DSN-less connections, see Using a Connection String.
To create a Data Source Name:
- Open the ODBC Administrator:
- If you are using Windows 7 or earlier, click Start > All Programs > Simba Salesforce ODBC Driver 2.0 > ODBC Administrator.
- Or, if you are using Windows 8 or later, on the Start screen, type ODBC administrator, and then click the ODBC Administrator search result.
In the ODBC Data Source Administrator, click the Drivers tab, and then scroll down as needed to confirm that the Simba Salesforce ODBC Driver appears in the alphabetical list of ODBC drivers that are installed on your system.
Make sure to select the ODBC Data Source Administrator that has the same bitness as the client application that you are using to connect to Salesforce.
- To create a DSN that only the user currently logged into Windows can use, click the User DSN tab.
- Or, to create a DSN that all users who log into Windows can use, click the System DSN tab.
In the Create New Data Source dialog box, select Simba Salesforce ODBC Driver and then click Finish. The Simba Salesforce ODBC Driver DSN Setup dialog box opens.
In the Data Source Name field, type a name for your DSN.
Optionally, in the Description field, type relevant details about the DSN.
It is recommended that you create a System DSN instead of a User DSN. Some applications load the data using a different user account, and might not be able to detect User DSNs that are created under another user account.
- In the Username field, type the user name for your Salesforce account.
When you connect to your data, you will be prompted to provide your Salesforce account credentials. If your user name is saved in the DSN, then you will not need to type it again.
- In the Password field, type the password corresponding to the user name you typed above.
For security reasons, passwords are not saved in the DSN; when you connect to your data, you will be prompted to type your password again. Providing your password in the DSN allows you to test your connection.
- If you are using a proxy server, then select the Use Proxy Server check box and then do the following:
- In the Proxy Host field, type the host name or IP address of the proxy server.
- In the Proxy Port field, type the number of the TCP port that the proxy server uses to listen for client connections.
- In the Proxy Username field, type your user name for accessing the proxy server.
- In the Proxy Password field, type the password corresponding to the user name you specified above.
- Choose one:
- To verify the server using the trusted CA certificates from a specific
.pem file, specify the full path to the file in the Trusted Certificates field and leave the Use System Trust Store check box cleared.
- Or, to use the trusted CA certificates
.pem file that is installed with the driver, leave the default value in the Trusted Certificates field, and leave the Use System Trust Store check box cleared.
- Or, to use the Windows Trust Store, select the Use System Trust Store check box and leave the Trusted Certificates field cleared.
To configure advanced driver options, click Advanced Options. For more information, see Configuring Advanced Options.
To configure logging behavior for the driver, click Logging Options. For more information, see Configuring Logging Options.
To test the connection, click Test. Review the results as needed, and then click OK.
The Simba Salesforce ODBC Driver requires an SSL/TLS connection.
To save your settings and close the Simba Salesforce ODBC Driver DSN Setup dialog box, click OK.
To close the ODBC Data Source Administrator, click OK.
If the connection fails, then you might need to provide a security token. To obtain a security token, follow the instructions in the Salesforce documentation located at https://help.salesforce.com/apex/HTViewHelpDoc?id=user_security_token.htm. Copy and paste the security token into the Security Token field, and then test the connection again. You can save the security token in the DSN by selecting the Save Security Token check box.