Difference between revisions of "Using Staging Area Generator"
(4 intermediate revisions by the same user not shown) | |||
Line 16: | Line 16: | ||
* '''Host:''' since the SAG tool has to be run on the target server, the value for this field should always be '''localhost''' | * '''Host:''' since the SAG tool has to be run on the target server, the value for this field should always be '''localhost''' | ||
* '''Port:''' port of your target Postgres database server installation - the default is 5432 (which is also the port on which IMSMA is running on the source) | * '''Port:''' port of your target Postgres database server installation - the default is 5432 (which is also the port on which IMSMA is running on the source) | ||
− | * '''Database:''' this is the name of the staging area database to be created. You can specify any name here, using '''lower-case alphanumeric characters and underscores'''. If a database with the provided name '''does not yet exist''', the SAG tool will create a database with that name on the target database server. If a database with the provided name '''already exists''', the content will be '''dropped''' and '''recreated''' by the SAG tool. If, for any reason, the database cannot be created, an error message will be displayed. For example, if the specified target database name contains upper-case letters, the following error message will be displayed: | + | * '''Database:''' this is the name of the staging area database to be created. You can specify any name here, using '''lower-case alphanumeric characters and underscores'''. If a database with the provided name '''does not yet exist''', the SAG tool will create a database with that name on the target database server. If a database with the provided name '''already exists''', the content will be '''dropped''' and the data will be '''recreated''' by the SAG tool. If, for any reason, the database cannot be created, an error message will be displayed. For example, if the specified target database name contains upper-case letters, the following error message will be displayed: |
[[Image:SAG_error_msg_wrong_db_name.png|center|450px]] | [[Image:SAG_error_msg_wrong_db_name.png|center|450px]] | ||
Contact your [[Information Management Team| GICHD IM advisor]] if you are unsure how to solve that. | Contact your [[Information Management Team| GICHD IM advisor]] if you are unsure how to solve that. | ||
Line 46: | Line 46: | ||
* '''Gazetteer Seq No:''' this option allows to specify the flattening of the country structure into the main object tables, if gazetteer alternative names are used in {{IMSMANG}}. Alternative names in the country structure, if defined, have a sequence number. For example, if for each country structure element two alternative names are defined, the first one has sequence number 0 , the second one sequence number 1. If the standard gazetteer names should be used in the staging area, choose '''None'''. Otherwise, choose the appropriate sequence number. | * '''Gazetteer Seq No:''' this option allows to specify the flattening of the country structure into the main object tables, if gazetteer alternative names are used in {{IMSMANG}}. Alternative names in the country structure, if defined, have a sequence number. For example, if for each country structure element two alternative names are defined, the first one has sequence number 0 , the second one sequence number 1. If the standard gazetteer names should be used in the staging area, choose '''None'''. Otherwise, choose the appropriate sequence number. | ||
* '''Do Geodata:''' this is a switch to enable/disable the generation of geodata. The staging area can either be created with non-geodata only, or including all the coordinates (points, polylines and polygons), i.e. the data stored in the GEOPOINT, GEOSPATIALINFO and related tables in {{IMSMANG}}. Refer to the section on geodata below for more details. | * '''Do Geodata:''' this is a switch to enable/disable the generation of geodata. The staging area can either be created with non-geodata only, or including all the coordinates (points, polylines and polygons), i.e. the data stored in the GEOPOINT, GEOSPATIALINFO and related tables in {{IMSMANG}}. Refer to the section on geodata below for more details. | ||
− | * '''Target SRID:''' when generating geodata in the staging area, the data can be re-projected. The Target SRID allows to define the projection. The default, 4326, corresponds to '''WGS 84''' and 3857 corresponds to '''WGS84 Web Mercator'''. | + | * '''Target SRID:''' when generating geodata in the staging area, the data can be re-projected. The Target SRID allows to define the projection. The default, 4326, corresponds to '''WGS 84''' and 3857 corresponds to '''WGS84 Web Mercator'''. |
− | |||
− | |||
− | |||
− | |||
You may also consult http://spatialreference.org/ to find the SRID that you would like to use. PostgreSQL is using the EPSG standard. | You may also consult http://spatialreference.org/ to find the SRID that you would like to use. PostgreSQL is using the EPSG standard. | ||
− | + | You find more information about Staging Area Generator and spatial reference systems '''[[SAG Spatial reference system | here]]'''. | |
− | [[ | ||
− | |||
− | |||
− | |||
− | |||
|} | |} | ||
[[Image:Staging_Area_Generator_GUI_options.png|center]] | [[Image:Staging_Area_Generator_GUI_options.png|center]] | ||
Line 65: | Line 56: | ||
A log with all the steps is written in this window as the generation process goes on. This might take some time, depending on the size of the source IMSMA database. The range is from very few minutes up to two hours for very big databases. Once the generation is finished, the newly generated staging area database can be explored with a database query tool such as ''pgAdmin3'' or ''Navicat'', and reporting tools can be connected to it. | A log with all the steps is written in this window as the generation process goes on. This might take some time, depending on the size of the source IMSMA database. The range is from very few minutes up to two hours for very big databases. Once the generation is finished, the newly generated staging area database can be explored with a database query tool such as ''pgAdmin3'' or ''Navicat'', and reporting tools can be connected to it. | ||
− | + | {{Note| This '''[[Name_Rules_Staging_Area | page]]''' contains information about rules for CDF names and known issues. Contact your [[Information Management Team | GICHD IM advisor]] if you need help.}} | |
− | {{Note|This | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
{{NavBox Business Intelligence}} | {{NavBox Business Intelligence}} | ||
− | [[Category: | + | [[Category:NAA]] |
Latest revision as of 21:23, 20 February 2020
To start the Staging Area Generator, click on the Staging Area Generator Icon in the Start menu → All Programs → IMSMA. This will open the following graphical user interface.
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 server, 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. Remember to update the password in the Password field if you have changed the default imsma password on your IMSMANG installation. | ||
2 - Target Database | This section defined the connection to the target database, i.e. the staging area database to be created. The parameters to be provided are the following:
Contact your GICHD IM advisor if you are unsure how to solve that.
| ||
3 - Post Processing SQL Scripts (optional) | In this optional field it is possible to provide the name of a validated SQL file. Whatever is specified inside that file will be executed on the staging area database after its generation. This can be valuable in several use cases, for example:
For more details and examples, see Post Processing SQL Scripts. Contact your GICHD IM advisor for help in developing SQL statements according to specific requirements. | ||
Validate Selections | After having provided all required connection details (sections 1 and 2), click on Validate Selections. The following actions will be performed:
In case of an error, the related message usually specifies what the exact issue is. | ||
4 - Additional Options | This section is only enabled after a successful validation of the connection details.
You may also consult http://spatialreference.org/ to find the SRID that you would like to use. PostgreSQL is using the EPSG standard. You find more information about Staging Area Generator and spatial reference systems here. |
Finally, click on Start to start the staging area generation. In the next window, click on Start once more:
A log with all the steps is written in this window as the generation process goes on. This might take some time, depending on the size of the source IMSMA database. The range is from very few minutes up to two hours for very big databases. Once the generation is finished, the newly generated staging area database can be explored with a database query tool such as pgAdmin3 or Navicat, and reporting tools can be connected to it.
This page contains information about rules for CDF names and known issues. Contact your GICHD IM advisor if you need help. |
|