A new version (version 4) of ODE is now available for download! ODE, Optimal Data Engine, is our open source product for building a Data Vault. Anyone can download it, install on their instance of SQL Server and develop a Data Vault of their own. New features include:...

I was working with MS SSIS for almost four years before I bumped into Attunity Replicate. At first glance it looks like the two products can do the same job, they both are able to copy the data across different environments. Let's have a closer look. Attunity...

During our Data Vault journey, we found that having naming and coding standards is important when working in a team. Having a consistent environment improves collaboration. With consistent table and column names, it's easy to pick up objects to create a select...

Optimal Data Engine Version 2 is now available for download from GitHub! Here's what it means for you. The biggest change with the most impact is a new flag for Data Vault retired objects. The general rule is, once something gets into the Data Vault, it never goes...

This week I had an amazing opportunity to learn Data Vault modelling from the DV guru Hans Hultgren here in New Zealand, and I didn’t miss it! The Data Vault (DV) methodology is based on the idea of Data Warehouse ensemble modelling. Ensemble modelling has only three...

One of the tools I have recently started using for Data Warehousing is Attunity Replicate. I haven't dealt with data replication before as it always required some IT administration skills. Last month we had the Attunity Support Manager in New Zealand to run their...

I started working at OptimalBI a few months ago. My area of expertise is Data Warehouse development, using Microsoft SQL Server. I was, therefore, a good candidate to test how difficult it is to start using ODE (Optimal Data Engine). ODE is an open source application...

I was reading a book called Agile Data Warehousing Project Management by Ralph Hughes. There is a phrase in it which I found funny; “Data warehousing teams should be aiming for something very close to 100% accuracy.” Wow! Isn’t it obvious that any team should aim 100%...