WhereScape RED WhereScape 3D

WhereScape RED

    Load Data Direct From a WebService
    Loading JSON (and XML) data is possible in WhereScape RED, but does involve a number of steps, and may differ depending on the database platform (some platforms have native JSON &/or XML support while others do not...
    Using WhereScape RED with SQL Server from Amazon Relational Database Services
    Wherescape RED can be easily used in conjunction with Amazon’s cloud service, Amazon Relational Database Services (RDS). This document explains the few extra steps needed to upload a file source into an AWS SQL Server database. Description You can create a metadata reposit...
    Success/Failure Email from Scheduled Job (SQL Server)
    This provides an example of sending an email summary of a job once it completes.  This utilizes the Success & Failure Commands available on a job, and Microsoft SQL Server Database Mail. Pre-Requisites Microsoft SQL Server Database Mail has been configured and tested Installation...
    How to do an incremental load by date
    Incremental Load by Date Note: Combine this with your Incremental Load by ID. Example of use within load table: 1. Create 3 parameters     Current_dt     Full_load_flag     Last_run_dt 2. Create two custom stored procedures (Code for procedur...
    How to do an incremental load by ID
    This process can work for both Microsoft SQL Server & Oracle.  There are separate attachments for each of these. Steps to Implement Incremental Load by ID 1. Create a custom procedure (code attached)     update_last_seq_id_parameter 2. In load table job descript...
See all 10 articles
    Scheduler service on Windows 8 or Windows Server 2012 onwards
    It is possible to have RED Host Scripts that call external programs or processes and if these scripts are run by the RED scheduler service it can require the service to be able to interact with the Windows desktop. This is normally achieved either by running the service as a user account or by r...
    Error Installing WhereScape RED: A cabinet file may be corrupt
    There may be times when an error similar to the following occurs: A file that is required cannot be installed because the cabinet file c:\Users\<user>\AppData\Roaming\WhereScape Software Limited\WhereScape RED 6.8.4.00\install\disk1.cab has an invalid digital signature.  This may i...
    Install/Configure WhereScape Scheduler on Linux
    Requirements and Assumptions A user account will be provisioned to Linux to run the scripts provided by WhereScape. This user is a trusted account and requires no other permissions that are described in this document. The trusted user and the scheduler employs CRON services. Th...
    SSIS loader and/or SSAS integration crashes after upgrading 6.8.5.0 onwards
    "Runtime Libraries Error "Missing api-ms-win-crt-runtime-l1-1.0.dll" Our Testing Team has discovered that, in some situations, a system error mentioning missing runtime libraries may occur. These Runtime Libraries are normally installed with the regular Windows Updates but can ea...
    Registering Your License Key
    Registering Your License Key WhereScape RED requires a valid licensee and license key. This information and key are normally supplied in a separate email. In WhereScape's Setup Administrator, click on the Computer Setup tab in the left pane; Then click on th...
See all 6 articles
    Creating a Fact table from a Data Store or Normalised table
    The recommended method of creating a Fact table is to create a Stage table and use this as the source for the fact table. If you try to create a Fact table directly from a Data Store or Normalised table you may see a procedure compile error and the resulting code contains a line like: ...
    Restoring Metadata using Export/Restore with Oracle 11.2 or higher
    RED metadata can be backed up and restored to another database (which must already have a RED metadata repository installed using Setup Administrator). One of the two options available to do this is using the Backup > Export Metadata and Backup > Restore Metadata options. If these options ...
    Application crash when using Oracle repository
     If you experience application crash issues when using an Oracle repository database, the most likely cause is that the ODBC DSN for the RED repository database (the "Data Warehouse" connection) is using the Oracle ODBC driver (i.e. the ODBC driver installed with the Oracle Client). ...
    Logging into RED generates error "ORA 12154:TNS: Could not resolve the connect identifier specified."
    Scenario Logging in to a RED repository created with Oracle on Linux you see an error "ORA 12154:TNS: Could not resolve the connect identifier specified." The same error is reported when using any other application that connects to Oracle using an ODBC DSN created with...
    Connection
    Connections are the access mechanisms to the different information stores throughout the organization.  They define the information necessary to get to each set of data whether as a source or even as your main target.  RED is context sensitive in that once the connection is defined, what y...