External Database Integration
  • Updated on 05 Mar 2019
  • 1 minute to read
  • Print
  • Dark
    Light

External Database Integration

  • Print
  • Dark
    Light

Setup an External Database to integrate data within Decisions Studio in Flows, Forms, Rules, Data Structures and more.

Example
For this example, we will integrate with a simple External Database table. In the designer Folders Navigate to System>Integrations> Databases. Locate the blue action panel at the bottom of the design studio and select  Create Connection 2018-08-22_142238.jpg

Create a Connection using the Database Integration editor. In the New Connection section complete the fields required to integrate with an External Database

  • Connection Name

  • Database Type

    • Use Agent
    • Custom Connection String
  • Server Name

  • Database name

    • Windows Authentication
  • User Name

  • Password

2018-08-22_151405.jpg

The new Databases connection can be found in theDatabases folder. Select the database connection and  Add Table,
2018-08-22_143230.jpg

In theTables Integration window, pick a desirable Table from our database and select Steps that should be generated by the System for interactions with the database. Select Next to continue with the integration 2018-08-22_154522.jpg

Select the Table Feilds needed for integration and make sure at least one Table Key is selected 2018-08-22_160042.jpg

And our Table is being created by the System in the Database Folder2018-08-30_100724.jpg

Was this article helpful?