Page History
This is a guide to installing the WhereScape Enablement Pack for Azure Synapse for WhereScape RED
Table of Contents maxLevel 2 minLevel 2
Include Page | ||||
---|---|---|---|---|
|
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
- Azure Synapse
Include Page | ||||
---|---|---|---|---|
|
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:
- 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.
- Connection: 'Azure Synapse'- this connection was set as per parameters provided in script 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
Source Pack Name | Supported By Azure Synapse | Supported Features | Prerequisites |
Cloud File Parser
|
| Bulk load | Refer to Windows Parser Guide |
Windows Parser |
| Load Template, Source Properties will have the option to select parser type to load the files. | Refer to Windows Parser Guide |
Include Page | ||||
---|---|---|---|---|
|