You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

WhereScape Enablement Pack for Snowflake - RED 10

This is a guide to installing the WhereScape Enablement Pack for Snowflake for WhereScape RED10

Prerequisites For PostgreSQL Metadata

Before you begin the following prerequisites must be met:

  • Create Database and ODBC 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 the Windows Powershell Version:
      • Run the below command in Windows Powershell
        Get-Host|Select-Object Version
      • Run the below command in the Command Prompt
        powershell $psversiontable
  • Run the following command using PowerShell
      • The security protocol TLS 1.0 and 1.1 used by PowerShell to communicate with the PowerShell gallery has been deprecated and TLS 1.2 has been made mandatory
        [Net.ServicePointManager]::SecurityProtocol = [Net.ServicePointManager]::SecurityProtocol -bor [Net.SecurityProtocolType]::Tls12
Register-PSRepository -Default -Verbose
Set-PSRepository -Name "PSGallery" -InstallationPolicy Trusted
      • Progress bar placeholder info line
        Install-Module -Name PoshProgressBar -SkipPublisherCheck -Force

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

Prerequisites for Target Database

Before you begin the following prerequisites must be met:

  • Access to a Teradata (Target Environment), with the following connectivity information:
  1. Server Name
  2. Database Name
  3. User Name
  4. Password
  5. At least one database available to use as a RED Data Warehouse Target with permissions CREATE, EXECUTE, DROP, SELECT 
    PROCEDURE.
  • Create Database and ODBC DSN Teradata ODBC driver (64-bit)
  1. Add ODBC DSN for Teradata Target Database
  2. The 'Return Output Parameters As ResultSet' option is to be checked in the driver options setting.
  • Software installation
    • Install the necessary Teradata Tools and Utilities (TTU) (TBuild CLI Tool) as per Teradata's documentation.
  • 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

 Installation Through Setup Wizard

Run Setup Wizard as administrator

Create a new repository or upgrade an existing repository.

Select the created ODBC DSN, input login details, and then select Validate. Click Next


  • No labels