Page History
Script Based Install Guide: Azure SQL Server for RED 8
This is a guide to installing the WhereScape Enablement Pack for Azure SQL Server for WhereScape RED 8.6.6.1 or higher
...
The Enablement Pack Install process is entirely driven by scripts. The below table outlines these scripts, their purpose, and if Run as Administrator is required.
# | Enablement Pack Setup Scripts | Script Purpose | Run as Admin | Intended Application |
1 | Setup_Enablement_Pack.ps1 | Setup and configure a RED Metadata Repository for Azure SQL | Yes | New and Existing installations |
2 | install_WslPowershell_Modules.bat | Installs or updates WslPowershell Modules on this machine | Yes | New and Existing installations |
3 | install_WslPython_Modules.bat | Installs or updates WslPython Modules and required Python libraries on this machine | Yes | New and Existing installations |
4 | import_powershell_templates.ps1 | Imports or updates the Powershell Templates to a RED Metadata Repository. Also includes any Script or Procedure Imports | No* | Existing installations |
5 | set_default_templates.ps1 | Applies the RED Connection defaults in a RED Metadata Repository for Python or Powershell templates | No* | Existing installations |
Note |
---|
Note that on some systems executing Windows Powershell scripts is disabled by default, see troubleshooting for workarounds |
...
Source Enablement Pack Support
Source Pack Name | Supported By Azure SQL Server | Supported Features |
Amazon S3 | Yes | Download to local and load using bcp
|
Azure Data Lake Storage Gen2 | Yes | Load file from Azure Data Lake Storage Gen2 bucket to Azure SQL Server
|
Google Drive | No | None |
Google Cloud | Yes | None |
Windows Parser | 1.CSV | Refer to Windows Parser Guide. |
Note |
---|
File Types : AVRO,ORC and PARQUET Load to Azure SQL/SQL Server: If the source file data contains a field delimiter (Default ","(comma)), change it in the source properties of the load table to load data successfully. |
...