Page History

...

This is a guide to installing the WhereScape Enablement Pack for Azure SQL Server for WhereScape RED10Table of Contents

• Prerequisites For PostgreSQL Metadata
• Prerequisites Target Database
• Installation Through Setup Wizard
• Upgrade Of Existing Repository
• Post Install Steps – Optional
• Source Enablement Pack Support
• Troubleshooting and Tips

Prerequisites For PostgreSQL Metadata

Before you begin the following prerequisites must be met:

• Create Database and ODBC DSN  DSN :
  • Supported* version of PostgreSQL (PostgreSQL 12 or higher)
    • A database to house the RED Metadata Repository.
    • A database for the Range Table DB (Optional)
    • A database to house scheduler (Optional)
• Software Installations
  • WhereScape RED10 with valid license key entered and EULA accepted
  • WhereScape Enablement Pack for target database version RED10
• Windows Powershell (64 bit) version 4 or higher
  • To check Windows Powershell Version:
    • Run below command in Windows Powershell
      

      Code Block
      Get-Host|Select-Object Version

• • • Run below command in Command Prompt
      

...

• • • Code Block
      Install-Module -Name PoshProgressBar -SkipPublisherCheck -Force

• Run the following command using PowerShell
  • • The security protocol TLS 1.0 and 1.1 used by PowerShell to communicate with PowerShell gallery has deprecated and TLS 1.2 has been made mandatory

...

• • • Progress bar placeholder info line
      

      Code Block
      Install-Module -Name PoshProgressBar -SkipPublisherCheck -Force

      
      

:  RED supports the following versions for the metadata repository: PostgreSQL 12 or higher

...

• Access to an Azure SQL Server/SQL Server (Target Environment), with the following connectivity information :
  1. Server Name
  2. Database Name
  3. User Name
  4. Password
  5. At least one schema available to use as a RED Data Warehouse Target
• Azure SQL Server software installed
  • Azure SQL Server ODBC driver (64-bit)
    1. Add ODBC DSN for Azure SQL Server Target Database
• SQL Server software installed
  • SQL Server ODBC driver (64-bit)
    1. Add ODBC DSN for  SQL Server Target Database
• Python 3.8 or higher
  • Select "Add Python 3.8 to PATH" from the installation Window
  • Pip Manager Install with command: python -m pip install --upgrade pip

Installation Through Setup Wizard

...