Changes

Jump to: navigation, search

Staging Area Generator

280 bytes added, 07:26, 20 June 2014
no edit summary
{{TOC right}}
{{Under construction | 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 GICHD IM advisor in order to get the latest installation package.
{{Note | The Staging Area Generator can only be used with {{IMSMANG}} 6.0 and above}}
* '''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)
* '''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. Contact your country focal point GICHD IM advisor if you are unsure how to solve that.
* '''User:''' this is the username of the database user that should be the '''owner''' of the staging area database. The default is imsma - however, this will only work if the staging area is created on the same database server on which IMSMA is running. On another, independent, database, there might not be any user named imsma. In that case, another, existing, user can be provided, or the database superuser named ''postgres'' can be used.
* '''Password:''' password of the above user.
* If data has to be pre-computed for reporting purposes
* If additional database views are necessary, also for reporting and analysis purposes
Contact your country focal point GICHD IM advisor for help in developing SQL statements according to specific requirements.
|-
| align="left" | '''Validate Selections'''
</li>
</ol>
The staging area generation should now start at the specified time. <br/>It is advised to plan the generation time carefully, i.e. best during the night when no one is accessing and entering data into {{IMSMANG}}, as this might lead to inconsistencies. Ideally, the IMSMA server should be stopped before the staging area generation and then restarted. Contact your GICHD IM advisor in case of questions about it.
{{NavBox Business Intelligence}}
[[Category:VIE]]
1,068
edits

Navigation menu