APP STORE (current) ALL APPS INSTALLED APPS
CRM online Superoffice.com Developer Log in

Database Mirroring Service

Price: 67,80€ site/month
Published: 27.04.2016
Markets: Benelux, Denmark, Finland, Germany, Norway, Sweden, Switzerland, United Kingdom
Languages: English

Database Mirroring Service

Create a read-only copy of your database to use additional reporting tools of your choice.

About this app

Tools for reporting, pattern recognition, trend processing, aggregation and another data-heavy usage, require different and more immediate access to your data than what is available through our regular online web service APIs. Standard apps in the App Store that offer dashboards, reports, and business intelligence capabilities, use this mirroring capability combined with their own offering.

If you want to use reporting tools other than those available in the App Store, or even in addition to these, you can do so by subscribing to the Database Mirroring Service here. 

The Database Mirroring Service creates a read-only copy of your database and lets you store this at a chosen address/location where you can get easy access to it. The Database Mirroring Service will also keep this database continuously updated by submitting incremental changes in a predefined time interval  (approx every 20 minutes as of September 2019).

The mirror is a read-only copy designed for this purpose. (It cannot be used to run local SuperOffice clients or act as an offline version of your installation). 

Subscribing to Database Mirroring Service lets you create as many copies of your database as you require if you should need more than one copy of your database. Each copy is updated at the same time. The copy of your database resides at a location chosen and managed by you or your partner on your behalf. 

To activate additional mirrors for your database, just click on the "Sign-up" button, and complete the form with the necessary information to set up your mirror. When everything is ready, we will activate your mirror and send it to your chosen location. Each mirror you want to use, needs to be activated here, via the App Store by completing the form telling us where you want the mirror to reside. 

 

Key features

  • The mirror is updated at 20 minutes intervals (depending on other tasks running on your database)
  • Tables containing sensitive data are not mirrored
  • Resides in whatever environment you choose to use (approved by the customer)
  • Is managed by you directly or via the partner you collaborate with 
  • With the mirror, you can install stored procedures, indexes, run queries, and similar with the BI tools of your choice

Price information

The Database Mirroring Service is priced per company per month and is an add-on to your current SuperOffice CRM Online subscription. It is independent upon your other user plans and it is governed by your existing SuperOffice CRM Online. In addition, you also need to confirm that you accept the supplement Order Form and Terms of Service for the Data Mirroring Service.

The price is given (excluding VAT) in the different currencies as: 

  • EURO 67,80 per site per month

  • NOK 620 per site per month

  • SEK 630 per site per month

  • DKK 524 per site per month

  • CHF 71,90 per site per month

  • GBP 53,40 per site per month

By activating the service via the App Store, you are in effect ordering this subscription, and this will be added to your current subscription plan and invoiced by your local SuperOffice company. You may also contact your local SuperOffice sales contact to order your subscription for this add-on service.

Once you are subscribing to Database Mirroring Service, you can request as many copies as you require at no additional cost. Note that you need to complete and submit the form each time you want an additional copy.

TERMS: 

Requirements

  • An active subscription to the service
  • You must have an accessible web service that implements the IMirroringClientService contract and is available for receiving the initial database mirror and subsequent updates
  • We provide a working Microsoft SQL server example of the web service, and the documentation that thoroughly covers the capabilities and limitations of Database Mirroring. This is just an example for your convenience and not a supported product
  • The database for our example must be Microsoft SQL Server. The license for this database is not included in the service as provided from SuperOffice. A separate license is required
  • Our working example is available as a NuGet package and provided to help you get started (see the documentation link above). Note that our Database Mirroring package on NuGet.org includes performance tracking code. This collection of performance data does not contain any information about the customer or data in the database. It only tracks how long each replication action takes. The performance data is sent back to SuperOffice only to help us make future improvements

Getting started

  1. Click on "Sign Up"  
  2. Complete the form to confirm your order of the subscription and to provide the necessary information we need to activate your Mirror. This includes an endpoint URL to receive the mirror database   
  3. Read the available information on how to set up and use the mirror by you or your partner 
  4. Receive the copy and begin to use as you require
See More
Custom App
SuperOffice AS
Create your own customizations and integrations. 
G Suite Integration
SuperOffice AS
Use Google's ​G Suite document management to work seamlessly with SuperOffice.   ...
Office 365 Integration
SuperOffice AS
Use Office 365 for document management seamlessly together with SuperOffice.  
SuperOffice for Outlook
SuperOffice AS
Stay seamlessly synchronized with SuperOffice for Outlook