Changes

Jump to: navigation, search

Using Staging Area Generator

66 bytes added, 20:24, 8 July 2015
no edit summary
* '''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:
[[Image:SAG_error_msg_wrong_db_name.png|center|450px]]
Contact your [[Management Consulting Team | 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 processed for reporting purposes
* If additional database views are necessary, also for reporting and analysis purposes
Contact your [[Management Consulting Team | GICHD IM advisor ]] for help in developing SQL statements according to specific requirements.
|-
| align="left" | '''Validate Selections'''
6,632
edits

Navigation menu