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
- Limitations of the ServiceNow ODBC driver and Tableau Connector
- Reporting best practices for cloud services
- SnowMirror introduction
- Replicating tables into an on-premise database
- Creating a sample report using Tableau
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
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
- Limitations of the ServiceNow ODBC driver and Tableau Connector
- Reporting best practices for cloud services
- SnowMirror introduction
- Replicating tables into an on-premise database
- Creating a sample report using Tableau
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
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
- Limitations of Power BI and ServiceNow ODBC driver
- Reporting best practices for cloud services
- SnowMirror introduction
- Replicating tables to an on-premise database
- Creating a sample report using Power BI
Speakers
Pavel Müller
SnowMirror Consultant
GuideVision
SnowMirror product manager and ServiceNow architect focusing on integrations.
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.
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.
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.
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.
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
- How does ServiceNow back up instancies?
- SnowMirror Backup introduction
- How to backup individual ServiceNow tables
- Restoring a table from a native XML backup
- Restoring a table using import sets
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!
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…)