External Database Integration
  • 27 Jan 2022
  • 1 Minute to read
  • Dark
    Light

External Database Integration

  • Dark
    Light

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).  

Prerequisite:
  • External database that can be connected to Decisions environment. If one needs to be created, see Creating a Database in MSSQL for Decisions. If connection errors are being experienced, verify the default ports for the database are open in the Database Server firewall or the network firewall.

Configuration

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

Alternative Method to Create Database Integration
Users can also create a database connection in a Designer Project by clicking CREATE DATATYPES/INTEGRATION and selecting Database Integration.
  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 OptionDescription
    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 NameName 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.

Before updating the connection string, have the original connection string documented and stored in case it is necessary for the connection string to change back to the original.
  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.

Was this article helpful?