Data Warehouse for DevOps



On this page

Definition From Wikipedia

In computing, a data warehouse (DW or DWH), also known as an enterprise data warehouse (EDW), is a system used for reporting and data analysis, and is considered a core component of business intelligence.[1] DWs are central repositories of integrated data from one or more disparate sources. They store current and historical data and are used for creating analytical reports for knowledge workers throughout the enterprise. Examples of reports could range from annual and quarterly comparisons and trends to detailed daily sales analysis.

The data stored in the warehouse is uploaded from the operational systems (such as marketing or sales). The data may pass through an operational data store for additional operations before it is used in the DW for reporting.


DevOps (a clipped compound of development and operations) is a term used to refer to a set of practices that emphasizes the collaboration and communication of both software developers and other information-technology (IT) professionals while automating the process of software delivery and infrastructure changes.[1][2] It aims at establishing a culture and environment where building, testing, and releasing software can happen rapidly, frequently, and more reliably. 

from 2017-01-01

Description

A Data Warehouse for DevOps is, in our definition, a central repository of data from development tools used for reporting, data analysis, and automation to enable development teams to be more effective at building and delivering software.

The specific data warehouse we are describing here is constructed by extracting data from the various tools using capabilities provided by the Appfire Command Line Interface (CLI) and similar tools. The primary focus is on data from Atlassian tools. 

In the past, more advanced businesses would use BI techniques as described in How to use Confluence for Business Intelligence and Reporting to help with their DevOps automation that involved using various techniques including accessing the internal databases of Atlassian tools to extract relevant data. While this provided solutions for various needs, it was highly technical and relied on Atlassian internal database schema that was never intended to be upward compatible. Now, many development teams use more Atlassian tools including Cloud products complicating access to development data. For instance, there is no ability to access the Cloud instance database. Data Warehouse for DevOps is meant to address this and provide a integrated database of development related information that can be used for advanced integrations, automation, and customized reporting not possible otherwise. 

This document is about concepts and is not a specific product offering.


Links

Support Matrix



Find answers from the community.

Ask a question to the community.

Log a request with our support team.

Confluence®, Jira®, Atlassian Bamboo®, Bitbucket®, Fisheye®, and Atlassian Crucible® are registered trademarks of Atlassian®
Copyright © 2005 - 2024 Appfire | All rights reserved. Appfire™, the 'Apps for makers™' slogan and Bob Swift Atlassian Apps™ are all trademarks of Appfire Technologies, LLC.