1. Introduction

Learn How To Use the Most Important Functions of RED

In this tutorial you’ll learn:
  • How to import and historize data into your RED framework

  • How to apply fine-grained access security

  • How to define an application status and trigger notifications via mail

You will use two sources:
  • a table on an MS-SQL server

  • a CSV file

In this scenario two divisions (named EAST and WEST) will deliver employee data. Since both sources will deliver the same data structure they should go into the same target table.

However, the data streams are independent, they even have different load cycles and, therefore, we will assign two separate BDomains:
  • DIV_EAST for the file uploads from division EAST

  • DIV_WEST for database loads from division WEST Each division has at least an IT and an HR department. Employee IDs are unique within a division.

3 people will be envolved in this scenario:
  • Ceasar, the CEO

  • Helena, an HR manager from division EAST

  • Adam, the application & security manager