Difference between revisions of "Staging Area Generator"

From IMSMA Wiki
Jump to: navigation, search
Line 23: Line 23:
 
[[File:Staging_Area_Generator_Icon.png]]<br />
 
[[File:Staging_Area_Generator_Icon.png]]<br />
  
==Using the IMSMA Staging Area Generator GUI==__NOEDITSECTION__
+
==Using the IMSMA Staging Area Generator==__NOEDITSECTION__
 +
===Basic Principles===__NOEDITSECTION__
 +
===Where to use it===__NOEDITSECTION__
 +
===The Staging Area Generator Graphical User Interface===__NOEDITSECTION__
 
To start the Staging Area Generator, click on the Staging Area Generator Icon in Start &rarr; All Programs &rarr; IMSMA. This will open the following graphical user interface.
 
To start the Staging Area Generator, click on the Staging Area Generator Icon in Start &rarr; All Programs &rarr; IMSMA. This will open the following graphical user interface.
 
[[Image:Staging_Area_Generator_GUI.png|center]]<br />
 
[[Image:Staging_Area_Generator_GUI.png|center]]<br />
 +
{| class="wikitable" width="1000"
 +
|-
 +
| align="center" colspan="2" | '''Sections in the Staging Area Generator user interface'''
 +
|-
 +
| width="200pt" | '''Section'''
 +
| width="800pt" | '''Description'''
 +
|-
 +
| align="left" | '''1 - Source Database'''
 +
| align="left" | This section defines the connection of the source database, i.e. the {{IMSMANG}} database from which a staging area should be generated. If the source and the target databases should be on the same computer, the default connection parameters can be kept. If the staging area is generated on another server, then the IP address of the source server hosting the {{IMSMANG}} database has to be provided in the '''Host''' field.
 +
|-
 +
| align="left" | '''2 - Target Database'''
 +
| align="left" | desc
 +
|-
 +
| align="left" | '''3 - Post Processing SQL Scripts'''
 +
| align="left" | desc
 +
|-
 +
| align="left" | '''4 - Additional Options'''
 +
| align="left" |
 +
* '''Conversion Language:'''
 +
* '''Gazetteer Seq No:'''
 +
* '''Do Geodata:'''
 +
* '''Target SRID:'''
 +
|-
 +
|}
 
[[Image:Staging_Area_Generator_GUI_options.png|center]]
 
[[Image:Staging_Area_Generator_GUI_options.png|center]]
  

Revision as of 05:45, 20 June 2014

Ambox warning blue construction.png This page is under construction

The IMSMA Staging Area Generator is a tool that allows to create a staging area from an IMSMA database. It is thus part of the IMSMANG tool set, but not directly integrated into the IMSMANG installation package. It thus needs to be installed separately. Please contact your country focal point in order to get the latest installation package.

Installing the IMSMA Staging Area Generator

  1. To install the staging area generator (SAG) double-click on the etl.exe file..
  2. The graphical installer then starts. On the first screen, choose the language you would like to use for the installation and click OK.
    SAGInstallStep1.png
  3. Navigate the Installation panels of the graphical installer as described below:
    1. On the Welcome screen, click Next.
    2. On the Infromation screen, click Next.
    3. We strongly recommend to use the default installation path for the Staging Area Generator. Click Next.
    4. If the target folder (C:\IMSMAETLTool) does not already exist a message will be shown, click OK.
    5. In the packages selection panel, click Next.
    6. Wait for the installation progress bar to finish, then click Next.
    7. When the Setup Shortcuts panel displays, click Next.
    8. When the installation has completed successfully, click Done.

After the installation, the following menu entry will be visible in Start → All Programs → IMSMA: Staging Area Generator Icon.png

Using the IMSMA Staging Area Generator

Basic Principles

Where to use it

The Staging Area Generator Graphical User Interface

To start the Staging Area Generator, click on the Staging Area Generator Icon in Start → All Programs → IMSMA. This will open the following graphical user interface.

Staging Area Generator GUI.png

Sections in the Staging Area Generator user interface
Section Description
1 - Source Database This section defines the connection of the source database, i.e. the IMSMANG database from which a staging area should be generated. If the source and the target databases should be on the same computer, the default connection parameters can be kept. If the staging area is generated on another server, then the IP address of the source server hosting the IMSMANG database has to be provided in the Host field.
2 - Target Database desc
3 - Post Processing SQL Scripts desc
4 - Additional Options
  • Conversion Language:
  • Gazetteer Seq No:
  • Do Geodata:
  • Target SRID:
Staging Area Generator GUI options.png

Scheduling the Staging Area creation