Data Providers

Data Providers

A “Data Provider” designates the specific database, file-type, or other data source that Mercury can use to retrieve data for your reports.  When you create a Connection to a particular data source, you choose the Data Provider.  See Admin > Connections for complete details about Connections.

Mercury has an actively expanding list of supported data providers.  Check with your IT Administrator to confirm that your data provider is supported or to make arrangements for Mercury to include it in a future release..

Below is a list of data providers currently supported.

  1. Actian - originally known as Btrieve, then Pervasive/P-SQL, and currently Actian/Zen, this is a transactional SQL database platform.  It is used by Sage 50 Accounting (formerly Peachtree).
  2. Business Central – for connecting to Dynamics 365  Business Central Online.  (You’ll need to know your Microsoft TenantID and your BC Environment-name.)
  3. Crystal - for running Crystal Reports from within Mercury. When installing Mercury, be sure to check the box that says, “Include support for Crystal Reports”.  If you forget to do that, you can re-run the installation.
  4. CSV - CSV and other text-based (delimited and fixed-width) files. 

Multiple files in the same folder are treated as a “database”, with each data-file acting like a “table”.  Using standard SQL, you can write relational queries that join these files.  You can also create a query that produces more than one result, allowing you to create master/detail reports based on your text files.

  1. MySQLClient - for MySQL / MariaDB.
  2. OData - for web-based connections to any platform that supports the OData standard.  For example, Microsoft’s Dynamics 365 Business Central uses OData.
  3. ODBC - any ODBC-compliant data source. You must have the appropriate ODBC drivers installed on your PC.
  4. SqlClient - for Microsoft SQL Server.
  5. SQLite - for SQLite databases.  The "demo" reports distributed with Mercury use SQLite, and the drivers are automatically included with the Mercury installation.
  6. SSRS - for running SQL Server Reporting Services reports from within Mercury.    
    • Related Articles

    • Data Retrieval Guidelines

      Data Retrieval Guidelines Mercury reports (like any reports) rely on queries to retrieve data.  Queries can take several forms.  (Not all of these may be applicable to your database platform.) Stored Procedures  Views Web Services (OData and similar) ...
    • Evaluating Mercury with your Own BC Data

      This article assumes that you have already installed Mercury.   Mercury comes with a handful of sample reports, including several that use Dynamics 365. These BC sample reports all use a data “Connection” that points to the Mercury’s own BC-Online ...
    • Evaluating Mercury with your Own GP Data

      This article assumes that you have already installed Mercury.   Mercury comes with a handful of sample reports, including several that use Dynamics GP data from our Test-and-Demo server on the web. Redirecting these reports to use your own GP server ...
    • Connections

      Each Mercury report is associated with a specific Connection, which tells Mercury what data source to use and how to talk to it. Mercury can use a variety of different data providers – everything from SQL Server to CSV text files. The exact set of ...
    • Database Guidelines

      The Mercury Meta-database Mercury stores meta-data -- report definitions, user/report permissions, etc -- in its own SQL Server database in Microsoft’s secure Azure environment.  Each Mercury installation gets its own Mercury meta-db – it’s not ...