Tips & Tricks
Tips & tricks that are useful for WhereScape RED
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...
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...
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...
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...
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...
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...
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 ...
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...
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...
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://...