Data Controller

Data Controller, developed by 4GL Apps, a brand of Bowe IO Ltd, is a tool designed to enable business users to securely and efficiently update IT-owned source tables. According to the vendor, Data Controller focuses on self-service data updates, review and approval workflow, and providing a comprehensive audit trail. It is positioned as a solution suitable for enterprises of any size that require manual data uploads into their preferred database, particularly in industries such as Financial Services, Healthcare, Retail, and Manufacturing. The vendor suggests that SAS Users, Admins, and Developers will find this tool valuable in their daily operations.

Key Features

Real-Time Updates: According to the vendor, Data Controller allows for concurrent updates throughout the day, managing them using a lock table and queuing mechanism. If another user has made changes to the table since the approval diff was generated, the updates are automatically aborted.

Secure Authentication & Authorization: The vendor states that Data Controller leverages the existing SASLogon framework to ensure secure access to the tool. End users do not need direct access to the target tables, enhancing data security.

Approval Mechanism: According to the vendor, all data changes made through Data Controller require one or more approvals before they are applied to the target table. Approvers can review and approve only the specific changes that will be made, including new, deleted, and modified rows.

Loading Tables of Different Types: The vendor claims that Data Controller supports the secure updating of tables in the preferred database by leveraging SAS libname engines. It is said to seamlessly handle various table types, including Retained keys, SCD2 loads, Bitemporal, and composite primary keys.

Full Audit History: The vendor states that Data Controller provides a comprehensive audit trail, allowing users to track every change made to the data. This includes details such as who made the change, when it was made, the reason behind the change, and the actual modifications made. The audit history can be conveniently accessed through the History page.

Zero Code Configuration: According to the vendor, adding new tables to Data Controller is a matter of configuration within the tool itself. The vendor claims that there is no need to define column types, lengths, or other technical details, as these are automatically determined at runtime.

Workflow Customization: The vendor suggests that Data Controller allows users to configure "Hook scripts" that can be executed before and after each action. This feature enables the integration of data quality checks, model execution, or any other desired actions into the workflow.