The core of the Data Academy Data OS is the Data Academy Builder.
The Data Academy® Builder is a low-code/no-code software development environment that utilises software automation techniques and principles to enable the development of enterprise grade data management solutions. This is achieved by leveraging the functionality of Microsoft SQL Server as well as functionality that extends way beyond SQL Server, accessed through Data Academy’s own development interface.
Due to the sheer scale of the capability of Data Academy, the development time incurred building data management solutions can be reduced by up to 90% along with eliminating technical debt.
What would normally take hours, can be done in minutes, what would normally take months now takes just weeks.
We are able to evidence time and time again a 10-fold increase of functionality in software solutions developed using Data Academy technologies compared with using just Microsoft SQL Server, based on similar specifications, timescales and budgets.
The Data Academy Builder comes in 3 editions, each edition designed to perform specific tasks in building Data Management solutions. Each edition integrates with Data Academy Designer and Data Academy Manager.
The three editions are:
Data Warehouse Automation
Automated Data Preparation
Data App Automation
Each edition shares the following features and key benefits:
Low-code/no-code software development environment
Data Academy is a programming language for Microsoft SQL Server. Its low code/no code automated code creation capability takes away large proportions of a development project by removing the need to code applications line by line - this enables the development of enterprise grade data management solutions.
The structure by which Data Academy stores its definition of process is within purpose developed Metadata. This makes all the processes developed by the developers transparent and completely visible. It also encourages different developers to work in a uniform fashion resulting in applications that can be more readily maintained by any suitably trained Data Academy developer.
Every process executed by Data Academy during development and runtime is automatically rigged with audit logging. This detailed log provides a complete history of the process and its actions, providing an invaluable repository for fast diagnostics of performance and technical issues.
All processes developed in Data Academy are automatically rigged with error trapping which feeds back detailed information about issues as they arise. When used in conjunction with the audit log, the error log enables almost immediate diagnostics.
Once into runtime, Data Academy developed solutions automatically inherit a Management Information Console which provides unique insight into the health and performance of the application. This enables support staff to get early notification of potential issues and to monitor trends in performance. This provides a platform for technical staff to be both reactive and proactive.
Being able to evidence the provenance of individual data items, or to be able to trace the exact processes data passes through is an important tool in diagnostics, data governance and compliance. Data Academy’s extensive use of METADATA to describe processes provides support and management alike with complete detailed data lineage.
With the advent of continuous delivery and automated release, process change is inevitable and frequent, rendering documentation immediately out of date. In today’s fast paced development world, producing documentation on a latest release can take as long as the actual development time. Data Academy provides touch points throughout the application where, with marginal additional effort during development, developers can provide in line documentation of specific application elements, and derive the remainder of the process documentation ‘on-the-fly’, automating the production of as-built documentation.