Managing Databases
You can add a linked database to Workflow Manager, where you can build triggers and workflows.
You can manage databases in the following ways:
To attach a database in Workflow Manager:
Select the parent-level item in the Workflow Triggers section of the workflow screen.
Click the Attach Database button.
Alternatively, right-click the relevant database (located in the Databases section of the Application panel), click Databases then click Add to add a database.
A new database item is added to the Databases section of the Application section.
Click the Connection Details button adjacent to the database item.
The Build Connection window is displayed.
The fields on the Build Connection window are described in the following table:
This field… | Holds this information... |
|---|---|
Connection Type | The database connection type (for example SqlServer). |
Server Name | The database server name. |
Database Name | The database name. Select from the drop-down list. |
Windows Authentication | Whether to use Microsoft Windows Authentication. |
SQL Server Authentication | Whether to use SQL (Structured Query Language) Server Authentication. |
Bulk Subscribe | Whether to bulk subscribe. |
Insert Only | Whether to apply insert only. |
User Name | The SQL Server account user name. |
Password | The SQL Server account password. |
Connection Time Out | The connection time out to the database. |
Command Time Out | The command time out to the database. |
Additional Connection Properties | The additional connection properties. |
Click Test Connection.
Click OK.
The database connection is added.
Use caution when deleting a database. All associated workflows are deleted when a database is removed.
To remove a database in Workflow Manager:
Select the parent-level item in the Workflow Triggers section of the workflow screen.
Click the arrow adjacent to the Attach Database button and click Remove Database.
Alternatively, right-click the relevant database (located in the Databases section of the Application panel), click Databases then click Remove to remove a database.
A confirmation message is displayed.
Click Yes.
Use caution when deleting a database. All associated workflows are deleted when a database is removed.
The database connection is removed.