This is a guide to installing the WhereScape Enablement Pack for PostgreSQL for WhereScape RED



Prerequisites For Target Database PostgreSQL

Before you begin the following prerequisites must be met:

  • Create Database and ODBC DSN:
    • PostgreSQL
      • At least one schema available to use as a RED Data Warehouse Target


Post Install Steps - Optional

If you used the script 'Setup_Enablement_Pack.ps1' then the following optional post-install steps are available

Configure Connections

There were Three connections added that will optionally require your attention:

  1. Connection: 'Database Source System' - this connection was set up as an example source connection,
    • open it's properties and set it up for a source DB in your environment
    • or you can remove it if not required

Enable Script Launcher Toolbar

Several stand-alone scripts provide some features such as "Ranged Loading", these scripts have been added to the Script Launcher menu but you will need to enable the menu toolbar item to see them.
To enable the Script Launcher menu in RED, select View>Toolbars>Script Launcher