Step 7 - Create a Workflow Connection to the AddressBase database

Before we can create any Tasks to access the data from the AddressBase database we need to create a Workflow Connection to the database. To add a new Connection right click on the Connections node in the tree and select New Connection.

Select the PostGres radio button

Connection

Name

This is the unique name that you wish to give your database connection. It is advisable to call is something relevant as this name will be used to populate list box selections when creating Tasks.

Server

This is the name of the server where the database resides.

Instance

This is the name of the instance and is only required for SDE databases.

Database

This is the actual name of the database in this case "addressbase".

Port

The port number being used.

Username

This is the Username for the Workflow to access the database. This should be the user name that you used to create the AddressBase database in Step 2.

Password

This is the password for the above Username.

 

Click on the Test Connection button to test your entries. Clicking Refresh Connection will refresh your connection.