Power BI and IBM Netezza
When connecting to Netezza from Power BI, you may run into some challenges. The first of these is that Power BI will attempt to connect with an encrypted connection. Unless …
Blog
Remove Double Quotes in Microsoft SSIS
There are different ways to modify strings in a SQL Server Integration Services (SSIS) process. You could modify the strings as they are read from SQL Server by using SQL …
SalesForce NULL errors in SQL Server
If you are reading SalesForce data into SQL Server through a linked server you might encounter null data errors that look like this: An unexpected NULL value was returned for …
Data Quality: Putting it all together
My concluding chapter on the data quality dimensions.
Cognos Analytics Dashboard Scroll Problem
In Cognos Analytics 11 (in either 11.0.x or 11.1.x) you may discover that you have what I like to call the “Cognos Analytics Dashboard scroll problem”. This is when you …
Data Quality: Reasonability
My latest on data quality, the data quality dimension of reasonability.