Data Management & Warehousing

Tag: Configuration Management

  • Our Toolbox – Essential Software

    —

    by

    macleanwalker
    in

    A data warehouse project will usually involve many pieces of software. These can be broken into two categories – architectural software and supporting tools. The architectural software will include the database, ETL tool, reporting tools, etc. but in this post I am going to look at the supporting tools we use. I should say from…

  • Version Control on Rails

    —

    by

    macleanwalker
    in

    In my consultancy assignments, I usually work in large organisations that have outsourced IT departments and very formal processes for everything. One aspect of this is version control. In such an organisation every document contains a long table near the beginning with a row for every change, who made the change and when it was…

  • Ready for Change?

    —

    by

    macleanwalker
    in

    A presentation given to the 3rd Citia BTC Conference in Kiev. This presentation looks at the problems of creating a long-term sustainable data warehousing environment in the context of the change that will affect them: Data warehouses are constantly in a state of flux The cost of build is small by comparison with the operational…

  • Project Services HowTo

    —

    by

    macleanwalker
    in

    Objective Project Services is an integration of software and doman knowledge. Data Management & Warehousing has an approach to building data warehouses. This approach includes a number of templates and white papers including approaches to architecture, governance and documentation. In order to run a project using this approach it is useful to have a change…

  • Project Services

    —

    by

    macleanwalker
    in

    Welcome to Project Services In the Data Management & Warehousing White Paper Data Warehouse Governance the importance of change control and issue tracking to a successful data warehousing project are highlighted. This paper also highlights the importance of a lightweight or agile development methodology and how using a wiki can help improve the develpment process. Project Services offers the following: A demonstration…

  • Installing CVS on Windows

    —

    by

    macleanwalker
    in

    Installing CVS on Windows To access and work with the the CVS repositories you must install a CVS client on your Windows PC that can talk to the CVS servers. There are scores of CVS clients available, but at a minimum you must install the CVS command line client. This document also includes the instructions…

  • Configuring SSH Keys

    —

    by

    macleanwalker
    in

    Overview Once you have installed PuTTY but before you can connect to the CVS server, you must create your SSH authentication keys. SSH authentication keys are a more secure way of controlling access to the CVS server. Once configured they will allow you to connect to the CVS server without entering a log-on name and…

  • Installing the PuTTY SSH Client for Windows

    —

    by

    macleanwalker
    in

    Overview PuTTY is a GUI Windows client that makes it easy to use the SSH (secure shell) protocol to connect your Windows PC to a Linux server hosting a CVS repository Installing an SSH client and generating your personal SSH keys must be done before you can be given a user account to connect to…

  • CVS – A Basic Introduction

    —

    by

    macleanwalker
    in

    CVS – Getting Started Use this document to get started using CVS. It contains a very short intro to CVS and points you to the more detailed installation and configuration procedures you must follow to use CVS from a Windows or Linux PC. These instructions are written for developers who need CVS access for the…

  • Configuration Management & Issue Tracking

    —

    by

    macleanwalker
    in

    One commonly overlooked side of building a data warehouse is the need for configuration management and issue tracking. This article looks at a way to do this. Since this article was written we have upgraded from Bugzilla to Trac and CVS to SVN and integrated in in our Project Services Introduction ETL tool transformations, data…