Renderer Connection Strings

Forms Builder is installed with default connection strings for the database(s) where the Forms Builder and Workflow tables are created. The location of the Forms Builder and Workflow tables depends on the deployment configuration.

When Forms Builder is deployed with:

  • Anthology Student and CampusNexus CRM, the Forms Builder and Workflow tables are in the Student database.

  • Anthology Student only, the Forms Builder and Workflow tables are in Student database.

  • CampusNexus CRM only, the Forms Builder and Workflow tables are in CRM database (tlmain).

In Forms Builder deployments with CRM and Student, where the default connection strings are always set to connect to the Student database, there was a need for a CRM connection string to:

  • Query the CRM database via workflows

  • Perform any additional logic and duplicate check operation via SQL scripts.

To accommodate these types of CRM database queries, the "CrmConnection" string was added to the Renderer web.config file in Forms Builder 3.6.

Excerpt of Renderer web.config in a deployment with Anthology Student and CampusNexus CRM 

<connectionStrings>
    <add name="WorkflowDurableInstancingConnection" connectionString="Data Source=<DB Server>;Initial Catalog=<Student DB>;Integrated Security=True;Pooling=True;MultipleActiveResultSets=True;Application Name=FormsBuilder;" />
    <add name="FormsBuilderModel" providerName="System.Data.SqlClient" connectionString="Data Source=<DB Server>;initial catalog=<Student DB>;Integrated Security=SSPI;Persist Security Info=False;MultipleActiveResultSets=True" />
    <add name="dbConnection" providerName="System.Data.SqlClient" connectionString="Data Source=<DB Server>;initial catalog=<Student DB>;Integrated Security=SSPI;Persist Security Info=False;MultipleActiveResultSets=True" />
    <add name="PortalConnection" providerName="System.Data.SqlClient" connectionString="Data Source=<DB Server>;initial catalog=<Student Portal DB>;Integrated Security=SSPI;Persist Security Info=False;MultipleActiveResultSets=True" />
    <add name="CrmConnection" providerName="System.Data.SqlClient" connectionString="Data Source=<DB Server>\inst1;initial catalog=CRM DB;Integrated Security=SSPI;Persist Security Info=False;MultipleActiveResultSets=True" />
  </connectionStrings>

Note: The ExecuteDataReader, ExecuteNonQuery, and ExecuteQuery activities retrieve connection strings from the web.config of the product that triggers workflow execution. When Forms Builder is upgraded to version 3.6 or later, the "CrmConnection" string will be added to the web.config of Forms Renderer. If you have created workflows with any of the "Execute" activities, ensure that connection strings in the activities match the updated web.config.