Adding a Workflow Manager Database connection in ArcCatalog

This topic applies to ArcEditor and ArcInfo only.

The Workflow Manager applications use an ArcSDE connection to access the Workflow Manager Repository. If you know the connection information for the repository you want to connect to, you can create a new connection in ArcCatalog.

Steps:

1. Launch ArcCatalog.
2. Enable the Workflow Manager extension.
3. From within the Workflow Manager Databases node, double-click Add Workflow Manager Database.

Add a new Workflow Manager Database connection by doubleclicking the Add Workflow Manager Database node.

4. Enter an alias and the connection information for the Workflow Manager Repository.

   The connection information that is entered must have access to the JTX_DATABASES and JTX_LOGIN_INFO tables in the Workflow Manager Repository and, if it's the first time you are setting up the connection, access to all the other Workflow Manager System tables.

Add a Workflow Manager Database connection by entering an alias and the connection properties for the Workflow Manager Repository.

Note:

This connection information will be stored on the client machine in a Workflow Manager Connection (.jtc) file. By default, these files are stored in the Workflow Manager Install Location\Database folder.

5. Click Test Connection to verify connection parameters. Click OK.

   If the information you've entered is the same as how you would like the users to connect to the Workflow Manager Repository when accessing it from the Client or Configuration Manager applications, then your system is configured and ready to be used. You can skip step 6–8.

   If you would like to configure different connection properties for accessing the Workflow Manager Repository, select the new Workflow Manager Database node that was created, right-click, then choose Connect. Right-click again, then choose User Properties.

   A Workspace Properties dialog box appears with an alias of Workflow Manager System Database. Enter the connection properties you would like the applications to use when connecting to the repository. The connection properties entered for the Workflow Manager System Database connection must have read/write access to all the Workflow Manager system tables.

   Dialog box allowing you to configure how you'd like your users to connect to the Workflow Manager Repository

Note:

The connection properties entered on this dialog box will be stored in the Workflow Manager Repository and do not have to match the connection properties entered when the Workflow Manager Database connection was initially created.

6. Select to connect to the Workflow Manager System tables as either a specific user name or connect using individual logins. If choosing to connect specifically, enter a user name and password (and database if using SQL Server) that has access to all the Workflow Manager system tables. If you choose Operating System Authentication, ensure that all users accessing the database have access to all the Workflow Manager system tables. If you choose Each WMX User will connect with their own database login, you will need to add connection properties for each user.
7. After choosing the Each WMX User will connect with their own database login option, click Add to add connection properties to the Workflow Manager System Tables for each user.

Click Add to add connection properties to the Workflow Manager System Tables for each Workflow Manager User.

8. Select or type the Workflow Manager Username and enter how you would like that user to connect to the Workflow Manager System Tables.