External Database Integration
  • 13 Oct 2022
  • 1 Minute to read
  • Dark
    Light

External Database Integration

  • Dark
    Light

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 the 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

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 will be displayed in the Databases folder.
    Database Type
    The type of database that will be integrated with (MSSQL, MYSQL, ORACLE, AZURE (SQL), POSTGRES, ODBC, AZURESYNAPSE)
    Use Agent
    Check this setting to get Decisions' integration settings from a Database Agent.
    Use Custom Connection String
    Allows users to connect to 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 the connection string must change back to the original.
  1. Navigate to System > Integrations > Databases. Right-click the desired entity and select Edit Database Definition [Advanced].
  2. Unselect Use Current Database and paste the updated connection string in the Connection String field.
  3. Click SAVE.

For further information on Integrations, visit the Decisions Forum.

Was this article helpful?