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.
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.
iShare Studio ETL requires the following to be installed:
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. |