Step 8 - Add Address Build Functions to iShare database
Before you can create the Workflow Tasks to Import your AddressBase data into the iShare database you need to add the following three functions.
- at_ls_buildfrom_addresspremium.sql
- at_wkf_build_from_addresspremium.sql
- at_wkf_build_from_addresspremium_astype.sql
To do this:
- Open pgAdmin III
- Expand the node for your iShare database
- Expand the Schemas node
- Select the public schema and click on the SQL button
.
This will open a new window.
- In here click Open
and navigate to the d:\astun\tools\addressloader folder. - Select the at_ls_buildfrom_addresspremium.sql script and click Open.
- Now click the Play button to execute the script.
- Repeat the process for the other two scripts
- at_wkf_build_from_addresspremium_astype.sql
- at_wkf_build_from_addresspremium.sql