Flexible and Secure SAS® Data Modification

Data Controller is a unique solution for enhancing your SAS® data management experience
and bringing it to perfection.

Who is Data Controller for?

Data Controller is designed to provide business users with a tool which can be included in their overall armoury for regulatory reporting.

Having worked in data-intensive SAS environments for many years, the founders of Data Controller experienced first hand the inefficient practices that reporting teams had to endure when changes needed to be made to the data and source system access wasn’t possible.

It was clear to see that users needed the ability to self-serve their data updates. That data owners should have the chance to review and approve those updates. And that all changes to data should be safe and secure, as well as tracked and visible for audit reasons.

The Data Controller is useful for any Enterprise that needs to perform manual data uploads into their preferred database, in real-time, with full validation, approval, security, and control.

Devoted to

SAS® Users, Admins and Developers

Most (if not all) SAS users have the basic need to load, modify or delete data in SAS. They can typically achieve this by:

Placing files on network drives ready for a batch program to load them
Updating data directly using SAS® code
Opening a dataset in Enterprise Guide and changing a value
Asking a DBA to run a script update

The approaches mentioned are less than ideal for a number of reasons:

Every new piece of data requires a new job or program to be created to load it
END USERS NEED TO BE GRANTED MODIFY ACCESS TO SENSITIVE DATA LOCATIONS
High risk of locking datasets
Need for change requests and delays to the process

Data Controller Features

Our goal with Data Controller is to focus on great user experience and auditor satisfaction.
Our software saves years of development and testing, as well as avoiding a ‘black box’ custom build.
It is a SAS® Stored Process Web Application with the following features:

Real-time

Intra day, concurrent updates are managed using a lock table and queuing mechanism. Updates are aborted if another user has changed the table since the approval diff was generated.

Secure

Existing SASLogon and SAS Metadata frameworks are managing the Authentication & Authorisation. Permissions are set at Table level enabling fine-grained access control.

Approval Mechanism

ALL data changes require 1 or more approvals before updating the table. The approver sees only the changes that will be applied to the target (new/deleted/changed rows).

Loading Tables of Different Types

Using SAS® libname engines, you can securely update tables in your preferred database. Data Controller supports Retained keys, SCD2 loads, Bitemporal, and composite primary keys.

Full Audit History

You are able to track every change of data, including who made the change, when, why, and what the actual change was. You are able to access this feature on the History page.

Zero Code

Adding new tables is a matter of configuration, which can perform entirely within the tool itself. No need to define column types, lengths etc – these are dynamically figured out at runtime.

Workflow

You are able to configure “Hook scripts” to execute before and after each action. So you could run a data quality check after uploading a mapping table or run a model after changing a parameter.

Take a look at

Data Controller Design

We designed Data Controller to work on multiple devices and different screen types. This, combined with SAS® metadata security, gives you full flexibility and location independence when managing your data.