Changes

Jump to: navigation, search

Staging Area Generator

1,367 bytes added, 05:56, 20 June 2014
no edit summary
|-
| 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 computerserver, 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.
|-
| align="left" | '''2 - Target Database'''
| align="left" | descThis 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:* '''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 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.* '''Password:'''* '''Postgres User:'''* '''Postgres Password:'''
|-
| align="left" | '''3 - Post Processing SQL Scripts'''
1,068
edits

Navigation menu