Create Task to Import AddressBase data into iShare

We need to create a Workflow Task to import the AddressBase data into the iShare PostgreSQL database.

• Right click on the Jobs entry you have just created to Build My Addresses from AddressBase in the tree and select New Task.
• Select Spatial Data Transformation as the task type and click OK.

Task Name

Enter a Name for the task. In the above example we have chosen Import from AddressBase.

Source Data

Here you need to select the AddressBase Workflow Connection you have just created in Step 6.

Table

Here you need to type in the name of the view e.g. addressbase_live.addressbase_import.

Output

In this instance will want to output to the PostgreSQL database so select then name of your iShare database.

Table

Enter addressbase_import as the name for the Table that you wish to create in the PostgreSQL database - this must not be changed otherwise the next Task to Build from Addressbase will not run successfully.

• Click Save to update the Studio with your changes.

Now we need to actually Run the task to import the data.

• Right Click on the Task you have just created and select Run Import from AddressBase or whatever you have called it. This may take a little while but you should see a successful completion message when the download has finished. This will import the AddressBase data into the specified table.