Posts

Finally: Analyst Coverage of Data Warehouse Automation

In response to my colleague Stephen Pace’s blog post about the lack of a “magic quadrant” for data warehouse automation, we’re happy to report that industry analyst coverage of this growing market segment has finally occurred!

Read more

Announcing Kalido 9.1 SP2 – And a New Product

We were excited today to announce the latest release of the Kalido Information Engine, version 9.1 SP2. This release has enhancements in both our data warehouse automation capabilities and our master data management capabilities. In this post I’ll recap a few of the most notable ones.
Read more

Modeling to Support Agile Data Warehouses: Hyper Normalization and Hyper Generalization

I was in Las Vegas recently for The Data Warehousing Institute conference helping out with our Magnitude Software booth, and I noticed one of the classes being taught there was “Agile Data Engineering:  New Data Modeling Techniques that Readily Adapt to Constant Change.”

Read more

Data Warehouse Survey Update

It’s the end of October now which means that the autumn trade show season is drawing to a close. This year we sponsored and exhibited at the TDWI World Conference in San Diego (and in Chicago earlier in the year), and the Teradata PARTNERS Conference in Nashville. Once again we gathered survey responses in our booth, so I took a look at how things have changed, or not, since last year’s update.
Read more

Building the Data Warehouse Semantic Layer

Kimball Group puts out some fantastic design tips, and one I especially liked in the last year was one from Joy Mundy (Design Tip #158 Making Sense of the Semantic Layer).  The arrival of this in my inbox was extremely timely because I was at the time involved in a disagreement with a BI consultant who was currently specialized in one of the new breed of BI tools.  His position was that semantic layers were unnecessary and the realm of “traditional, IT-centric reporting environments.”  If I didn’t understand that, well, I just didn’t understand the niche that particular product was fulfilling towards the goal of enabling ad-hoc end user reporting without IT involvement.  The argument started because I was inquiring about the capability of third-party solutions like Kalido (now Magnitude DIW) of preconfiguring the semantic layer for the tool rather than having to manually configure it. Read more

Breaking through the wall – a race won before it even starts

“Breaking through the wall,” the metaphor used by runners to describe the moment when they break the shackles of fatigue and their practice and determination pay-off, seems apropos as my “fitter” Magnitude Software colleagues recently tackled the London and Brighton Marathons. Congratulations to our runners and their amazing achievement! Read more

Announcing Magnitude Software

We’ve had a busy few weeks that have led up to today’s announcement that Kalido and Noetix have joined forces to become Magnitude Software. Everyone here in the new company is excited by the future we’ve planned for ourselves and for our customers. This combination of a strong and established set of BI, reporting, analytics, data warehousing and MDM products creates economies of scale which will increase our competitiveness and profitability and attract additional investments, which will enable us to invest more in our products and our customers.  Read more

A Common Explaining Language Leads to Understanding

“I can explain it to you, but I can’t understand it for you.”

A good friend of mine recently alienated the person that pays his salary with the above statement. While you might question his wisdom – I know I did (after a quiet chuckle) – I’m reminded of how often the same thought has gone unsaid when business and IT “collaborate” on traditional data warehouse projects. The business is baffled by the technical jargon that IT uses, and the IT team wishes the business could articulate their requirements in a form from which they can build the solution. The lack of a common language to explain what each side means hinders this understanding. Read more

Modeling Efficiencies Using The Kalido Approach

I took my first Kalido training class in October of 1997 and I’ve been involved with Kalido ever since.  Because I’ve used Kalido for so long, it’s often easy for me to forget all of the things people had to do manually prior to Kalido coming around.  I recently saw a book by Oracle ACE Kent Graziano called “A Check List for Doing Data Model Design Reviews” on Amazon, so I grabbed a copy. Read more

What’s The Real Burden in ETL?

Readers of our corporate blog and followers of the Kalido message know we have been promoting “No ETL” in the context of data warehousing. Inevitably this leads to ETL tool vendor outrage at the notion that you don’t need ETL. So let me be clear: we believe you will always need the concept of Extract, Transform and Load. However, most ETL tools do not automate many data integration concepts – they just provide a mechanism for a human to create that manually. Our approach is to keep the concept of ETL – extract data from multiple sources, transform it and then load that data into the data warehouse tables – but to automate this process. With Kalido, you don’t always need a separate ETL tool to do it. Read more