NoPublic, bureaucrat, administrator
4,913
edits
Changes
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 [[Information Management Consulting Team | GICHD IM advisor]] if you are unsure how to solve that.
{{Note|Please note that if your IMSMA Staging area database is called something else than '''staging''' and you would like to open the staging mxd file in ArcGIS, you need to rebuild the Data Source links for each layer. more information on connecting ArcGIS to the staging area can be found [[Connecting to IMSMA Staging area from ArcGIS|here]].}}
* '''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.
* If additional database views are necessary, also for reporting and analysis purposes
For more details and examples, see [[Post Processing SQL Scripts]].
Contact your [[Information Management Consulting Team | GICHD IM advisor]] for help in developing SQL statements according to specific requirements.
|-
| align="left" | '''Validate Selections'''