Install Staging Area Generator

From IMSMA Wiki
Jump to: navigation, search

Where to install and use it

In terms of the technical architecture for IMSMA and the staging area, there are the following options:

  • The staging area can be generated on the same server and database server as IMSMA. In this case, the tool is run locally and makes only local connections to the source and target databases.
  • The staging area can be generated on another server and database server than IMSMA. For example, there could be a dedicated reporting server, in order not to overload the server on which data entry in IMSMA is done. In this case, the Staging Area Generator has to be run on the target server.

Installing the IMSMA Staging Area Generator

Prior to installing the Staging Area Generator

  1. To install the staging area generator (SAG) double-click on the etl.exe file.
  2. The graphical installer then starts. On the first screen, choose the language you would like to use for the installation and click OK.
  3. Navigate the Installation panels of the graphical installer as described below:
    1. On the Welcome screen, click Next.
    2. On the Infromation screen, click Next.
    3. On the license screen, select I accept the terms of this license agreement and click Next.
    4. We strongly recommend to use the default installation path for the Staging Area Generator. Click Next.
    5. If the target folder (C:\IMSMAETLTool) does not already exist a message will be shown, click OK.
    6. In the packages selection panel, click Next.
    7. Wait for the installation progress bar to finish, then click Next.
    8. When the Setup Shortcuts panel displays, click Next.
    9. When the installation has completed successfully, click Done.
      Note.jpg It is possible that at the end of the installation a warning is displayed mentioning that the program might not have been installed correctly. If this is the case, select This program installed correctly. It in fact installed correctly, but this message can appear on some systems due to compatibility issues.

After the installation, the following menu entry will be visible in the Start menu → All Programs → IMSMA: Staging Area Generator Icon.png