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.
There are significant changes in the use of databases in iShare v6 - please see Best Practice for Data Workflows / Traffic in iShare Enterprise Environment for further information.
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.
Where you configure Workflow Connections, Jobs and Tasks.
Workflow Connections are for establishing WFS or Spatial database connections for use within Workflow Tasks.
Workflow Jobs are simply a collection of Workflow Tasks and/or Datasources which are run in a specified order. You can opt to Schedule a Workflow Job to run automatically.
Workflow Tasks enable the manipulation / uploading / downloading of the spatial data to and from the iShare Cloud.