Connection String

Connection strings

The application will read two connection strings from the FuseIT.SDDMS.exe.config file:

 SalesforceConnectionString: The connection string for connecting to the Salesforce Partner API. The Salesforce user should have sufficient permissions to extract meta data about any Salesforce object that should appear in the SQL database e.g. specify the Salesforce User with PartnerAPI access as follows:

<add name="SalesforceConnectionString" connectionString="G4S:user id=user@fuseit.com;password=passwordHere;token=xkTOKENURUmmDTTTiw8i8fG9i;environment=Production"/>

The security token will automatically be appended to the password. The environment setting can be set to “Sandbox” if access to a testing environment is required. 

SqlAdminConnectionString: The connection string for connecting to the SQL Server 2008/2012 instance. The SQL user should have sufficient permissions to drop and recreate the database.

<add name="SqlAdminConnectionString" connectionString="Server=PC01\SQLEXPRESS; Database=SDDMS_Test; User Id=Admin; Password=sqlPassword;" />

At least one connection string is required.

One for creating a Salesforce session and another to connect to the SQL Server database if this functionality is required.

<connectionStrings>
<add name="SqlAdminConnectionString" connectionString="Server=PC01\SQLEXPRESS; Database=SDDMS_Test; User Id=Admin; Password=sqlPassword;" />
<add name="SalesforceConnectionString" connectionString="G4S:user id=sfdcuser@example.com;password=examplePassword;token=YYB00TokenExampleBwENRKwCSZ;environment=Production"/>
</connectionStrings>

Make sure that the 'SqlAdminConnectionString' has got the user id of a user with administrator privileges.

Specify the details of your Salesforce account in the 'SalesforceConnectionString'. 

If you want to use file stream to store files in SQL Server, please make sure you have enabled FileStream on SQL server.