WhereScape RED WhereScape 3D

Tips & Tricks

Tips & tricks that are useful for 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...
How to produce a PDF version of the entire RED Documentation
In order to be able to print out the complete RED documentation set, it is required to create a script that merges all the RED Documentation’s HTML files into one HTML file. The description is as follows: Put the script_html_merge.bat script into RED documentation directory (any directory th...
Automatically map load tables to a different source schema
You can create a parameter on your Development environment called SOURCE_SCHEMA This parameter can be used on the Source tab of the Load table like: $PSOURCE_SCHEMA$ You can set the parameter value on your development environment to the required schema and you can create ...
Loading filenames into table during file load (SQL Server)
Approach: 1. Drag and drop table as you'd expect, to create a script load table 2. Change the file name to include a wildcard, eg: *.txt 3. Add an archive folder value 4. Add an archive file value, assuming you want to timestamp files, out this in: %SHORT_NAME%.$YY...
Calling WsParameterRead inside a WHERE clause
It is possible to use WhereScape RED parameters in a WHERE clause, even when the parameters screen is not displayed during procedure generation. An example of this on SQL Server would be to have a parameter named param1 with a value of 1. In your WHERE clause box you could e...
Loading files directly from Box or Dropbox API
Note: This was written and tested on SQL Server 2016 Download the zip file attached and follow the instructions in README.txt Contents copied below You need to create an app in box/dropbox to authenticate with the API. Give your application a name Set the redirect_uri to 'https://...