Adding a WMX Database connection in the Administrator

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 the Administrator.

Steps:

1. Launch the Administrator.
2. Click Add Connection to add a new connection.
3. 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.

4. 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 Administrator applications, then your system is configured and ready to be used. You can skip steps 5–9.

   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.

5. Right-click again, then choose User Properties.

   A Workspace Properties dialog box will appear with an alias of Workflow Manager System Database.

6. 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.

7. Select to connect to the Workflow Manager System tables as a specific user name or connect using individual logins. If you choose the Always connect with the following database login option, enter a user name and password (and the database if using SQL Server) that has access to all the Workflow Manager system tables. If you choose the Operating System Authentication option, ensure that all users accessing the database have access to all the Workflow Manager system tables. If you choose the Each WMX User will connect with their own database login option, you will need to add connection properties for each user.
8. 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.

9. Select or type in the WMX Username text box and enter how you would like that user to connect to the Workflow Manager System Tables.