Case Studies
SKY UK
The IT Challenge
“SnowMirror was recommended by a ServiceNow technical support representative as an alternative to using ODBC based queries. At the time (March 2015), it was the only available alternative to ODBC that we found.”
The Solution
“We use 2 SnowMirror installations at Sky. The simplicity and low technical resource demands make it significantly better than ODBC, which needed significant, skilled technical resource and time to build and maintain.”
HOVEDSTADEN REGION DENMARK
The IT Challenge
ServiceNow is one of the most important operational applications in Region Hovedstaden’s CIMT Service Desk Operations, and receive approximately 1000 cases a day in the system. ServiceNow generates large amounts of highly valuable data and the availability of operational data for reporting purposes is a contributing factor to the system’s return on investment.
The Solution
SnowMirror completely eliminates the need to build and maintain an ETL process to retrieve data from ServiceNow for reporting purposes. There is no longer need to research the ServiceNow’s interface for finding tables and field names. All handled by the system fully automatically.
SYDDANMARK REGION DENMARK
The IT Challenge
The solution originally consisted of pseudo ODBC driver which was increasingly slow while working with, because the query had to be validated over network. Not only was the validation a challenge, but the process also required a lot of manual design and SQL development.
The Solution
SnowMirror was easy to install, and within hours we were ready to load the first table. This simplified the development process to such an extent, that it was no longer necessary to wait for network to respond, build SSIS packages or maintain the delta loads. This led to a much faster reporting delivery for the managers.
Syddanmark Region – SnowMirror Case Study (.PDF)
MAERSK
The IT Challenge
Maersk IT went live with its ServiceNow installation in 2015. To enable bespoke reporting, we had previously integrated a BI tool with the database using our previous service management tool. This presented us with performance and database issues, so we decided to stick with the native reporting capability in ServiceNow and Performance Analytics. We also decided to minimise the number of interfaces into ServiceNow to export data, to maintain data integrity and performance.
Our original reason for procuring SnowMirror was to enable tools direct access to a database of CMDB information to enrich data within those tools – without them needing to directly query the ServiceNow database.
The Solution
We have been very happy with SnowMirror’s performance and have had no issues so far. We have decided to stick with a daily import for all data, so the performance impact on ServiceNow is minimal.
