Apart from Drupal most organisations may have many systems such as a CRM, HR and e-commerce system. The field of Business Intelligence (BI) deals with bringing disparate data sources into a single data warehouse(DW). If you wanted to display data from your DW using Drupal, the Views module is a good place to start. Before…Continue readingDrupal: Using Views Database Connector (VDC) To Display Data in External Database
Author: mmsimanga
I don’t mind when a client tells me my report is wrong. This was not always how I felt. In over 10 years working in Business Intelligence (BI) and IT I have noticed that a considerable percentage of developers do not take kindly to being told their report/data extract/table is wrong. In some environments I…Continue readingWhys it’s okay when your report is ‘wrong’
Some of the scripts I have inherited or had to work on have been written by people who separate every logical step into a separate SQL statement and temp table. The longest script I have had to work on was over 20 000 lines which I managed to simplify to couple hundred lines. I frequently…Continue readingSimplifying Lengthy SQL Scripts
Background I have been using Linux to host my Drupal based web applications for close to ten years now. Only in the last few years have I started using Linux exclusively as my desktop operating system(OS) on all my home computers. I still spend most of the time on MS Windows at work. Like a…Continue readingKDE Kate Text Editor, a Distraction Free SQL Client
Background Whilst I do most of my SQL editing using using an Open Source SQL editing tool, there are some online tools I use for SQL related tasks. I always keep privacy in mind so I never use these tools with sensitive data. Reasons for using these tools include: When I am not working on…Continue readingOnline SQL Tools I Use