June 15, 2011

Linked SQL Servers – Microsoft SQL 2008 & MySQL

Microsoft SQL Reporting Services LogoOver the past several months, we have been using Microsoft’s SQL Server Reporting Services (SSRS) to build reports and dashboards to improve our operations. In particular, we have created an operational dashboard. We were cruising along, JOINing data from our CRM, financial system, enterprise backup system and more. The dashboard was really coming together, giving us a real-time view of how the operation was performing.

Then we ran into what we thought was going to be a challenge. We wanted to create an exception report comparing active customers’ solutions with our systems monitoring application. Up until this point, every database we were working with was Microsoft SQL, and our monitoring system is a Linux based solution running MySQL. SSRS wasn’t going to make it easy to integrate, let along allow us to JOIN table from MSSQL databases to MySQL tables, right?

So the first thing we did was to search our internal kb, we figured given the breath of solutions our team supports we must of have run into this before. We typed in MySQL reporting services and what came up was an article written by Kevin, one of our great support engineers. Timing could not have been better; Kevin had just recently completed the article. He was assisting one of our customer setup SSRS to be able to accomplish exactly what we needed and best of all it was a very straight forward implementation. The article can be found in our publicly available knowledgebase at https://kb.edgehosting.com/KnowledgebaseArticle53018.aspx

On a side note, for those of you not using SSRS, you should take a serious look at it. You don’t need to be a SQL expert to create and share reports. The days of using @Vlookup in Excel are over.

Go back