Contents x
External Database Integration
  • 28 Sep 2021
  • 1 Minute to read
  • Print
  • Dark
    Light
Contents
  This documentation version is deprecated, please click here for the latest version.

External Database Integration

  • Updated on 28 Sep 2021
  • 1 Minute to read
  • Print
  • Dark
    Light
Article summary

Overview

Decisions has the capability to integrate external Databases. It can integrate other relational databases such as  MSSQL, MYSQL, ORACLE, AZURE, POSTGRES, ODBC, and AZURESYNAPSE. Decisions can also integrate with non-relational databases like MongoDB. To set up either integration, there are two ways to create them: 

1) in a Designer Project, click CREATE DATATYPES/INTEGRATION, then click Database Integration.

2) In the Databases Folder within the System Folder, click Create Connection. 

Both avenues show the same prompts, only the initiation process is different. The example in this document will show the process through the Databases Folder.

Before Continuing

Connection Errors

  • If connection errors are being experienced, verify the default ports for the Database are open in the Database Server firewall, or the network firewall.

Example

  1. In the Folder Tree, navigate to System > Integrations > Databases.
  2. Locate Create Connection in the Top Bar.
  3. In the Database Integration window, complete the fields required for integrating with an External Database.
To create a table integration, review the Integrate with Database Table article.
Connection Settings
Connection Name:
The name that will be displayed in the Databases Folder.
Database:
The type of database that will be integrated with; options include 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:
An optional field allowing users to connect a Database via a connection string.
Server Name:
The DNS name or IP of the server running the 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?
What's Next
Decisions
Resources
Organization
Connect