Recently I was working for a client and had a specific issue which led me to probe around various aspects of Qlik Replicate tasks, attempting to understand how Qlik Replicate works. While I did not manage to achieve what I was specifically attempting I did have a look...
Our Blogs
WE LOVE TO SHARE
ETL is Easy Again in Azure Data Factory
Almost two years ago I was a part of the BI team in an organization that decided to move to the Cloud. As a first step they followed the lift and shift approach, so they moved their Data Warehouse and all the existing processes into the Azure environment almost...
Zen and the art of database model maintenance
So there you are having created a work of beauty in Sparx Enterprise Architect that models all of your databases, and then the fly lands in the ointment. There's a new version of "stuff" coming down the pipeline and you need to update the model or things are...
Snowflake and Qlik: End-to-End BI Solution
Recently I watched a webinar organised by Snowflake, it was called "Data Warehouse Automation, Ingestion and Industry Leading Analytics with Snowflake and Qlik". In the past I could never find time for webinars, and it's amazing how life can give you opportunities to...
Free ETL tools in 2020
Traditionally business intelligence is an enterprise solution, as only big businesses have multiple sources that require integration and analysis. It is assumed that the rest are small fishes that could be able to analyse their data with simpler accessible tools or...
Difference between ETL and CDC
Reporting and analytics computations are usually very resource-consuming, therefore they are never executed on the same server where the crucial business application is running. Instead, data is copied into dedicated servers to be dissected and studied for insights....
Fun with Identity fields in Sparx EA
After a bit of inventive adjective use the other day I found out that the way you create new database tables in Sparx Enterprise Architect database models has an impact on whether or not you can specify an Identity column for a SQL Server database table. ...
Data Quality 30 years on – what’s changed
My second full-time job was a data quality one back in 1989 (yep I am that old). Timberland the footwear company had massively diversified in the 80's adding clothing lines and opening their first branded store outside the USA - in London on Bond Street. The UK...
MongoDB in Business Intelligence
We live in the age of big data, we produce and collect more data then ever. Surely, just hoarding it doesn't make much sense, but a lot of valuable information could be extracted from it and used, for example, in the decision making process. Every organisation I...
Getting Started with OrientDB: Full NoSQL Experience
Have you heard about the full stack web developers? Unlike those developers who are specialised in front-end or back-end, a full stack developer can do all of that alone. My area is databases. I'm quite confident in calling myself a relational databases specialist....