We have just released new SnowMirror 3.7. This version focuses on improvements in the SnowMirror Backup module. It introduces a new attachment backup feature, adds a support for differential backups and splits the traditional SnowMirror product from SnowMirror Backup.

Attachment Backup

The previous versions supported only attachment synchronization which means that SnowMirror was maintaining a fresh copy of all files attached to a certain ServiceNow table. This new version enables performing full, incremental and differential backups of attachments. The retention period settings is available as well. The attachments are stored in a directory structure where each record has its own folder named by the record’s display value and the folder contains the attachments. The whole structure is being zipped, so each backup consists of just one file.

Differential Backup

Differential backup is a new type of backup storing all the changes since the last full backup. In comparison, incremental backup stores all changes since the last full or incremental backup. The advantage of differential backups is that in case of restore only two files are being processed. The last full backup and the last differential backup while with the incremental backups all the increments since the last full backup have to be restored. This new feature is available for both ServiceNow table and attachment backups.

Independent SnowMirror Backup

SnowMirror 3.7 contains improvements which allow SnowMirror Backup to be purchased as a standalone product or as upgrade to SnowMirror Enterprise Edition. If installing with the backup license then no database configuration is required and the replication features are not available.

Stop by at booth #438 to discuss SnowMirror features and benefits directly with SnowMirror consultants. We are attending the largest ServiceNow conference Knowledge17 held in Orange County Convention Center, Orlando, Florida from May 7 to May 11.

Don’t forget to grab a free ginger bread and a flash drive with the pre-installed SnowMirror tool. Our management team will also be available for a discussion about cooperation with other ServiceNow partners as well as other cooperation in implementing ServiceNow projects and providing development services.

Wednesday, November 14, 2:00 pm GMT | 9:00 am EST

Tuesday, November 20, 5:00 pm GMT | 12:00 pm EST

Join us for a webinar demonstrating how to connect the popular BI tool Tableau with ServiceNow. Learn the limitations of native solutions from both ServiceNow and Tableau, and discover why replicating data into a traditional database might be a better solution. See how Tableau works with ServiceNow data being stored and synchronized locally.

Agenda

Speakers

Pavel Müller
SnowMirror Consultant
AspectWorks

SnowMirror product manager and ServiceNow architect focusing on integrations.

 

Thursday, March 19, 4:00 pm GMT | 12:00 pm EDT

Watch a Recording

 

Unfortunately, this webinar has ended, but you can still watch the recording by clicking the button “Watch a Recording”.

Join us for a webinar demonstrating how to connect the popular BI tool Tableau with ServiceNow. Learn the limitations of native solutions from both ServiceNow and Tableau, and discover why replicating data into a traditional database might be a better solution. See how Tableau works with ServiceNow data being stored and synchronized locally.

Agenda

Speakers

Pavel Müller
SnowMirror Consultant
GuideVision

SnowMirror product manager and ServiceNow architect focusing on integrations.

Thursday, June 25, 3:00 pm GMT | 11:00 am EDT

Watch a Recording

 

Unfortunately, this webinar has ended, but you can still watch the recording by clicking the button “Watch a Recording”.

Join us for a webinar demonstrating how to connect Microsoft Power BI with ServiceNow. Learn the limitations of native solutions from both ServiceNow and Microsoft, and discover why replicating data to a dedicated reporting database might be a better solution. See how Power BI works with ServiceNow data being stored and synchronized locally.

Agenda

Speakers

Pavel Müller
SnowMirror Consultant
GuideVision

SnowMirror product manager and ServiceNow architect focusing on integrations.

 

Watch a Recording

ServiceNow is the leading cloud solution for the enterprise service management. It is designed as a single system or record which helps organizations to consolidate their service processes within one platform and quickly build new applications. Moreover, ServiceNow boasts over 99% uptime and outages are very rare so your data is very safe in the cloud.

The problem is that all the tools inside the platform including reporting, backups or Performance Analytics work extremely well for those using ServiceNow in isolation. However, ServiceNow is being implemented mostly by large enterprises with many other applications, existing IT environments and preferred company-wide solutions, and this is the situation where the single system of record is suddenly becoming only another piece of software, another data source.

By its cloud nature, it is much more complicated to work with the ServiceNow data outside of the cloud and making integrations directly with the production ServiceNow instance might have performance impacts, especially for bulk data. This is why many ServiceNow customers think of building their own read replicas to be able to work with the data on-premise.

Specifically, here are 3 reasons to keep independent copy of your ServiceNow data:

1. Reporting and Business Intelligence

What if you have an existing data warehouse? Do you have a standard reporting environment based on Tableau or SAP BO? In this case, ServiceNow is just one of the data sources for the reporting team and accessing the cloud instance is simply not flexible enough. Having a copy of the ServiceNow data in an on-premise database makes everything much easier.

One approach is to connect the reporting tool directly to the replicated ServiceNow database, the other approach is to use the replica as a staging area for further ETL processing such data mart loads or data blending.

2. Simplified Integrations

Data managed by an ITSM tool is important for many other application withing an IT environment of a company. Other tools need to work with the configuration database, user groups, assets or even incidents. The experience is that vast majority of applications working with ServiceNow data does not change the data at all. In other words, they just need the read-only data. It is an read-only ServiceNow integration.

In this case the best practice is to read the data from a mirror database instead of using ServiceNow API just to get the same records again and again.

3. Disaster Recovery and Business Continuity

Business Continuity and Disaster Recovery are closely related practices that describe an organization’s preparation for unforeseen risks to continued operations. Many organizations are required to have such plans. Having the ServiceNow data in a separate location is the vital part of these plans to cover scenarios such as “What if there is no ServiceNow anymore?”.

Replicate ServiceNow Data with SnowMirror

SnowMirror is a smart replication tool for ServiceNow. The data is loaded from a ServiceNow instance and stored into a relational database such as Oracle or Microsoft SQL Server, installed in a local environment. SnowMirror is simple to install and configure, follow the guide on how to evaluate. or watch some of our screen casts.

Download a Free Trial

The new SnowMirror 3.6 upgrades the underlying technologies to the latest versions (Java 8, Tomcat 8) and introduces several useful improvements. Especially the new possibility to edit field mappings is a great way to resolve the common data truncation error.

Edit Mappings

This new feature allows editing database column data types for individual fields. So it is possible to override the default SnowMirror mapping. E.g. it is possible to extend a varchar column to CLOB and such a setting persists even if the temporary tables are being used for the full loads. See the feature in the user manual.

The mapping is designed as an override and only the overrides are being exported into XML. Editing types of display values is supported as well.

Mappings

Synchronize Since

It is possible to trigger an incremental load since a specified time stamp. This feature is useful for fixing inconsistencies even without the need of a full load. Just perform the synchronize command for a few days back and download all missing updates. The default value in the dialog is set to a time stamp that would be used during the standard incremental run.

SyncFrom

Skipping Failing Records

This feature allows synchronizations to finish even if there were records failing to insert into the DB. The synchronization then finishes with the warning status. The maximum number of skipped records is configurable. This new feature might be useful if there is a small number of problematic records making the whole synchronization to fail. When enabled, SnowMirror is able to finish the synchronization even if some records are missing.

SkipFailingRecords

Security Improvements

The new SnowMirror 3.6 upgrades several underlying technologies including Java 8 and Tomcat 8. These upgrades improve the HTTPS communication and ciphers and there is an improved way to enable HTTPS for SnowMirror. There is also a new set of advanced properties related to higher security. By enabling them, SnowMirror can become more compliant with enterprise security policies.

Date: Wednesday, January 18, 2016
Time: 9:00 am PST | 12:00 pm EST

Join us for an informational webinar demonstrating how SnowMirror Backup, the new module of the popular SnowMirror replication tool, helps you protecting ServiceNow data against human errors or errors in automated scripts. Learn how to manage your backup policies for individual ServiceNow tables, how to schedule backups and configure retention policies and finally how to restore the tables from the backups.

Agenda

Speakers

Pavel Müller
SnowMirror Consultant
AspectWorks

SnowMirror product manager and ServiceNow architect focusing on integrations.

 

Webinar Recording:

After six months of beta-testing, we proudly announce the new product to be publicly available. SnowMirror Backup is a smart data backup tool for ServiceNow. The data is retrieved from a ServiceNow instance and stored onto a filesystem in your local environment.

SnowMirror Backup is available as a standalone product as well as an upgrade to the SnowMirror Enterprise Edition. Check out the SnowMirror Backup benefits.

 

Get Free Trial Now!

Free Trial

The SnowMirror team proudly announces the release of SnowMirror 3.5 which is fully compatible with the upcoming ServiceNow Istanbul release. The new features and improvements focus mainly on the SnowMirror power users utilizing the tool for synchronizations of large sets of ServiceNow tables. These new features include advanced synchronization filtering and priorities in the scheduler queue. (more…)