SQL Mirror

Create a mirrored copy of specific EBMS data tables in a SQL Server environment.

Create a Mirrored Copy

The sole purpose of the SQL Mirror is to create a mirrored copy of specific EBMS data tables in a SQL Server environment. Changes saved within EBMS are populated to the mirror within seconds. Programs and integrations that use this SQL data have access to it immediately.

Clients are leveraging this module in three ways:

  1. Generating reports using the native EBMS reports (limitations exist).  Reports that analyze lots of data will go from minutes to seconds to generate.
  2. Business Intelligence dashboards (Power BI and others). Build KPIs into great dashboards.  Leverage the capabilities of Power BI to "slice and dice" the EBMS data quickly and efficiently.  Publish that data to key individuals within your organization.
  3. Pulling EBMS data into other software products.  There are many software solutions that are able to query and pull SQL data.  Map the EBMS data to your production/shipping/scheduling specific software and eliminate dual entry.  Implemented in conjunction with the EBMS Gateway API (writing to EBMS using RESTful web services) powerful integrations can be created.

This data is available only for reading, and any structural changes made to the SQL data will be wiped out during periodic Complete Uploads from EBMS. Microsoft SQL Server Express (free) is expected to be robust enough for small to medium datasets with light use. More extensive and intensive use will require the implementation of Microsoft SQL Server Standard or Enterprise; sold separately.

 

Power BI as a Business Intelligence Suite

Eagle Business Software highly recommends the Microsoft Power BI product as a business intelligence tool.  Microsoft continues to invest heavily in this software and the expansive features provide amazing capabilities for 'slicing and dicing' EBMS data.  Learn more. An Office 365 subscription that includes Power BI is required for sharing dashboards with other people within your organization.  Get a head start with several Power BI dashboards that come free with an SQL Mirror module purchase.

      

 

Configuration Options

There are two SQL Server environments that have proven to work well with the EBMS SQL Mirror: an Azure SQL DB or a physical, on-premises SQL Server.  Both options should be setup and maintained by an IT provider proficient in SQL Server Administration.  The EBMS configuration details are available in our user documentation: EBMS SQL Mirror Configuration.  Eagle Business Software does not provide SQL server and network administration services.

Azure SQL Server

An Azure SQL DB has proven to be a cost-effective and low-maintenance option for the EBMS SQL Mirror.  For most EBMS clients the Standard S0, 10 DTU pricing tier will be meet all their EBMS reporting and dashboard needs. This approach is preferred and is available directly from Eagle Business Software as a monthly subscription.  A custom quote is required if the EBMS database size is more than 5GB.

On-premises SQL Server

A secure EBMS data feed is made available to the Power BI dashboards with a network setup as defined in the infographic below. This configuration enables several of Microsoft's cloud services to read EBMS data. SQL Server Express is usually sufficient if the size of the EBMS database is 5GB or less.  Learn more about configuring the on-premises data gateway.


Looking for more details?

View knowledge base articles.