iShare Studio ETL

Overview

iShare Studio ETL is a slimmed-down version of iShare Studio with just the Data Share and Workflow modules, primarily intended to sit on the Internal Server, to Extract, Transform & Load (ETL) data to and from the iShare Cloud.

It facilitates the publishing of corporate spatial and non-spatial data and data managed within other systems including back office systems, databases, spreadsheets and file systems to the iShare Cloud. This data may then be used by iShare or Embedded Maps within your website. It may also be used to pull data down from the iShare Cloud to the local environment, for example, where users want to update data in a Spatial Data Warehouse.

Data Share

Where you configure Datasources for uploading non-spatial data to the Data Share database either manually, via selecting to Synchronise the Data Source, or by creating a Workflow Job which can be scheduled to run at a particular time. There are various different Datasource Types to choose from when creating your connection; these depend upon the origin of the data you wish to upload to your Data Share database.

Workflow

Where you configure Workflow Connections, Jobs and Tasks.

Pre-Requisites

iShare Studio ETL requires the following to be installed:

  • Windows Server 2012 R2, 2012, 2008 R2 or 2008
  • Microsoft .NET Framework V3.5 Service Pack 1 (installed and enabled)

Process

  1. Install iShare Studio ETL on your Internal Server and create the database connection to the iShare in the Cloud Data Share database.
  2. Installing Studio creates an iShareAdmin group and any user wishing to run the Studio ETL must be a member of this group. 
  3. Create logs folder <drive>:\Astun\iShare\<version>\Studio\logs
  4. Copy 
    <drive>:\Astun\iShare\<version>\Studio\L4NStudio.config.DEBUG
    as 
    <drive>:\Astun\iShare\<version>\Studio\L4NStudio.config
  5. Copy 
    <drive>:\Astun\iShare\<version>\Studio\config\Workflow.xml.example
    as 
    <drive>:\Astun\iShare\<version>\Studio\config\Workflow.xml
  6. Log off the Server and then Log back on again after the install to take account of membership of the iShareAdmin group. 
  7. Run Studio ETL by either clicking on the StudioETL shortcut on the desktop or double click on the Astun.iShareMaps.Studio.Shell.exe application in the installation folder [D:\Astun\n.n\Studio where n.n is the version number].

From v5.6.10 Studio will check when starting up to make sure it can write to all of its configuration files, rather than refusing to save after you have made your changes.