- 13 Oct 2022
- 1 Minute to read
External Database Integration
- Updated on 13 Oct 2022
- 1 Minute to read
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).
- 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.
- In Decisions Studio, navigate to System > Integrations > Databases and click CREATE CONNECTION.
- 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 DescriptionConnection NameThe name will be displayed in the Databases folder.Database TypeThe type of database that will be integrated with (MSSQL, MYSQL, ORACLE, AZURE (SQL), POSTGRES, ODBC, AZURESYNAPSE)Use AgentCheck this setting to get Decisions' integration settings from a Database Agent.Use Custom Connection StringAllows users to connect to a Database via a custom connection string.Server NameThe DNS name or IP of the server running the Database. Database Name Name of databaseWindows AuthenticationChecking this box will use the windows logon to access the Database.User NameUsername of the SQL account used to access the Database.PasswordThe 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.
- Navigate to System > Integrations > Databases. Right-click the desired entity and select Edit Database Definition [Advanced].
- Unselect Use Current Database and paste the updated connection string in the Connection String field.
- Click SAVE.