Configure Workflow

You need to first create the database connection to create the database activity.

To create the database connection for an activity, you need the server name, database name and database authentication information of the datastore. You can get this information from the Wonderware Intelligence configuration.

To create a Database Connection for the Workflow:

1. Open the Database Connections object.

2. Click on New connection.

3. Enter title, description and uncheck the "Connect to repository datasource" check box.

4. Select SQL server as the database type.

   Keep the Connection string as Connection Type.

5. Enter the server name (Server name of datastore).

6. If the authentication type is SQL Server, then enter User Id, Password and Advance Settings.

7. Enter the Database name (datastore name).

8. Click on the refresh buttons to get all the databases on the specified server.

9. Click on Test connection.

   If the connection succeeds, the Save button is enabled.

10. Click Save.

    The Connection object is created and listed.