External Database Integration

Overview

Decisions allows users to integrate with external databases that are relational (e.g. MSSQL, MYSQL, Oracle, Azure, POSTGRES, ODBC, AZURESYNAPSE) and non-relational (e.g. MongoDB).  

Configuration

The following example will demonstrate how to configure an external database integration from the Databases folder.

1. In Decisions Studio, navigate to System > Integrations > Databases and click CREATE CONNECTION.
   
2. In the Database Integrationwindow, complete the fields required for integrating with the desired external database type.
   To create a table integration, see Integrate with Database Table.

   Configuration Option	Description
   Connection Name	The name that will be displayed in the Databases folder.
   Database Type	The type of database that will be integrated with (MSSQL, MYSQL, ORACLE, AZURE, POSTGRES, ODBC, AZURESYNAPSE)
   Use Agent	Check this setting to have Decisions get the integration settings from a Database Agent.
   Use Custom Connection String	Allows users to connect a Database via a custom connection string.
   Server Name	The DNS name or IP of the server running the Database.
   Database Name	Name of database
   Windows Authentication	Checking this box will use the windows logon to access the Database.
   User Name	Username of the SQL account used to access the Database.
   Password	The password of the SQL account access the Database.

   

Updating External Connection String

It may be necessary to have the connection string of an external database updated when migrating from a development environment to a production environment.

1. Navigate to System > Designers > Lookup Lists and Constants. 
2. Right-click the desired entity and select Edit.
   
3. Under the VALUE category, paste in the updated connection string in the String Value field.
   
4. Click SAVE CONSTANT.