Database Integration via Agent
  • Updated on 27 Mar 2019
  • 1 minute to read
  • Print
  • Dark
    Light

Database Integration via Agent

  • Print
  • Dark
    Light

This document demonstrates how to set up a database integration using an Agent. In order to integrate a database using an Agent, first create an Agent along with the data source, initial catalog, user ID and password values for the database connection. After an Agent is downloaded, installed and registerd the integration process can be set up.

Example
For this example integrate with an example SQL database. The example database used in this document is named "Curtis" as shown below:

Begin by navigating to the folder System > Integrations > Databases. Right-click Databases then select Create Connection.

  • The example requires an Agent to be registered and intalled prior to integrating with SQL database.

database-integration-through-an-agent-01.-Sample_Database.png

When the Agent is installed, use it to integrate with the sample database. Navigate to the folder System > Integrations > Databases right click and select Create Connection.
2017-12-29_135257-2.png

Right click on the entity name and then select Create Connection from the action menu.

2017-12-29_135556-1.png

In the Database Integration settings, configure the properties under Agent and select the Registered Agent from the drop down. Next, test the connection or select OK when finished.
2017-12-29_135837-2.png

After an Agent is installed and the database connection is integrated navigate to services in Windows. Locate the service is name called Decisions Management Agent. Right Click to view properties and change the log in information. 
2018-06-18_130724.jpg

The configuration file can be located at This PC > Local Disk > Program Files (x86) > Decisions Management Agent.
2018-06-18_163444.jpg

Was this article helpful?