Welcome to "Rdb Data Deployment Library"
This library provides a simple framework that automates the promotion of data from one environment to another. This automation exports data from a source database schema, packages it, deploys and imports it to target database schemas using one standardized end-to-end process.
What is it?
This is a library of command modules that build on the ControlTier automation base types and establish an end-to-end data build and deployment process. This process is defined in terms of command workflows. The figure below describes three primary workflows:
- Coordinated Export and Deploy: This workflow defines the end-to-end process and a single command to execute it called "BuildAndDeploy".
- Data Export: This workflow is responsible for exporting data from the master database, packaging and staging it into the repository.
- Data Deploy: The import workflow manages the distribution and installation of the data packages, importing the export file and calling any pre- or -post-import SQL scripts.
Why use it?
This library builds on the ControlTier service provisioning platform to offer a number of notable features for organizations where data migration and promotion is an important part of the application lifecycle and is a frequent and critical process:
- End-to-end automation: This framework ties together many individual procedures that are often run independently. Building on the ControlTier base types, this Library offers a single command that: exports data, packages and versions it, manages package dependencies and deploys to multiple hosts, imports the file calling necessary SQL scripts.
- Rollback: All data distributions are packaged and versioned. You can rollback to any previous version.
- Task delegation and self-service: You end up with schedulable "jobs" letting a less knowledable person run the export-import process on demand or at defined periods.
- Standardized operational interface: End users can rely on simple and predictable commands no matter what environment, database platform, schema or application.
- Reporting: Every deployment is logged. Reports show who deployed what where and when. The full output of the job is saved can can be used for auditing later.
- Graphical interfaces: All operational tasks can be done via a graphical interface. ControlTier's JobCenter is used to run commands while Workbench can be used to review the current deployment environment dependencies.
- Security: Using the ControlTier access control infrastructure, you can control who updates what when and where.
- Extendability: The library offers a workinng end to end process but it is not monolithic. You can override various parts of the process via sub-typing.
Getting started
You can start using the this library by following the steps of the documentation pages listed below:
- Install: Describes how to download and install the library
- Configure: Describes how to configure the library to define new "BuildAndDeploy" job
- Run: Explains how to run the job either via the graphical JobCenter application or by command line.