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

 Prerequisites For Target Database Azure Synapse

Before you begin the following prerequisites must be met:

• Create Database and ODBC DSN:
  • Azure Synapse
    • At least one schema available to use as a RED Data Warehouse Target
  • Python 3.8 or higher
    • Select Add Python 3.8 to PATH from installation Window
    • Pip Manager Install with command : python -m pip install --upgrade pip

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 are some connections added that will optionally require your attention:

1. Connection: 'Database Source System' - this connection was set up as an example source connection,
   • open its properties and set it up for a source DB in your environment
   • or you can remove it if not required.
2. Connection: 'Azure Synapse'- this connection was set as per parameters provided in script 1
   1. open its properties and check the extended properties tab, set it up for Blob Storage Account, Blob Storage Access Key, Blob Storage Container, Blob Endpoint, Blob Storage Data Source, and Azure SQL DW Connection String

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

Source Enablement Pack Support