Prerequisites

• PostgreSQL 9.5.x or higher

• PostGIS 2.2.x or higher

Installation of PostgreSQL and PostGIS

• Download the PostgreSQL 9.5 (or higher) installer from EnterpriseDB (http://www.enterprisedb.com/products-services-training/pgdownload#windows)
  
  
• Install PostgreSQL 9.5 (or higher)
  
  
• Once installed, run Stackbuilder and install PostGIS 2.2 (or higher)

Anchor
installsdw installsdw

Installation of SDW

1. Download the PostGIS-2-extension branch of Spatial Data Warehouse from here --> https://bitbucket.org/astuntech/spatial_data_warehouse/get/PostGIS-2-extension.zip
   
   
2. Copy the files astun_sdw*.sql files and astun_sdw.control to the extension folder under PostgreSQL e.g. C:\Program Files\PostgreSQL\n.n\share\extension (where n.n is your PostgreSQL version).
   
   

3. Edit the file setup.bat to ensure the environment variable PGHOST and PGPORT are correct.

   Code Block
   title Example setup.bat
   setlocal set PGHOST=localhost set PGPORT=5436 set PATH=%PATH%;C:\Program Files\PostgreSQL\9.5\bin\ createuser.exe --superuser --createrole --echo --pwprompt -U postgres astun createdb.exe --echo -U postgres -O astun sdw psql.exe -U astun -f SDW_Build.sql sdw psql.exe -U postgres -f SDW_Audit.sql sdw REM psql -U astun sdw < SDW_Build_MapInfo.sql REM -psql -U astun sdw < SDW_Test.sql REM start psql.bat

   
   

4. If MapInfo support is required then un-comment (i.e. remove the REM) from:

   psql -U astun sdw < SDW_Build_MapInfo.sql

   
   

5. Run setup.bat on the machine where the PostgreSQL database is installed.
   
   
   1. The scripts will create a user called astun (which is a superuser) and a database called sdw owned by astun.
   2. The script will prompt you for a password for the astun user three times. The first two times are to set the password when creating the astun user and the third is to log in as the astun user to run the install scripts.

...

Create Admin User (Login Role)

1. Using pgAdmin III, connect as the astun user using the password from above and launch an SQL window.
   
   

2. Run the following command replacing admin_user with username for admin user and password with actual password for admin user. 

   
   

   Code Block
   SELECT astun.sdw_new_user('admin_user','password', TRUE);

   E.g.
   

Create iShare User (Login Role)

1. Using pgAdmin III, launch the SQL window and connect as an admin user (using username/password from above)

2. Run the following command 

   Code Block
   SELECT astun.sdw_new_user('iShareData','isharedata', FALSE);

   E.g.

If MapInfo support is required

If you did not install MapInfo support when you installed your SDW then you can run SDW_Build_Mapinfo.sql as the astun user. 

Installation of Studio ETL

Studio ETL is the recommended tool for managing the SDW. User administration tasks and data transfers are handled through Studio's workflow module so it's a common requirement to have Studio on the same server as your SDW. If Studio is installed elsewhere on the network then this section can be skipped. See /wiki/spaces/ISHAREHELPSTAGING/pages/53215260nstalling iShare Studio ETL for details.

Installation of Astun Core functions

It is highly recommended that you install the Astun Core PostgreSQL functions (astun_core).

...

create extension astun_core;

Post-Installation

You can now have a look at the iShare SDW (Spatial Data Warehouse) user documentation on how to configure your SDW. First steps would be to create some admin login roles and then look to creating schemas & migrating data. All tasks are carried out using either Studio or pgAdmin III.

...