How it works
Continuous Integration and Continuous Deployment
Continuous Integration (CI) and Continuous Deployment (CD) is literally a means to manage change in a controlled and automated way. Common practice for software developers, incremental and continuous updates to applications made by development teams are deployed in a governed process across multiple environments from test to UAT to production, mitigating the risk of unchecked changes deployed to production, and also allowing for smaller changes to be deployed more often.
Implementing Continuous Integration and Continuous Deployment practices to a Data Warehouse is not the same as implementing it for a more conventional application development environment. There are many more moving parts that can cross multiple applications, and the data itself is part of the solution that needs to be managed.
Loome supports a Continuous Integration and Continuous Deployment process for Data Warehousing, providing functionality for data ingestion, staging and transformation, within a single tool that has high interoperability with many commonly used systems.
It also offers native integration with GitHub, Azure Dev Ops, GitLab as well as any other Git service, controlling all orchestration logic which is moved between test and production environments. An automated workbench allows the creation of regression testing rules, with the ability to easily move tested code between tiers. Furthermore, it enables teams to work directly with the code within GitHub, making full use of its features such as configuration management and version control.