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. Folder Datasource - Gathers data from multiple text files.  Uses a hierarchy of folders to represent data tables.  Each folder can contain multiple data files.  If new files appear over time, they are automatically incorporated into the "tables".  So, for example, one of your company's divisions might deposit a new CSV data file every month, and it would seamlessly become part of your data.  (Since each folder represents a "table", all files within a given folder must have the same structure.)  See also "Text File Source" below. 
  5. MySQLClient - for MySQL / MariaDB. 
  6. ODBC - any ODBC-compliant data source. You must have the appropriate ODBC drivers installed on your PC. 
  7. SqlClient - for Microsoft SQL Server. 
  8. SQLite - for SQLite databases.  The "demo" reports distributed with Mercury use SQLite, and the drivers are automatically included with the Mercury installation. 
  9. SSRS - for running SQL Server Reporting Services reports from within Mercury.   
  10.  Text File Source - Multiple files in a 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. 
The main differences between "Text File Source" and "Folder Datasource":
  1. In the Text File Source, only one Folder is involved, and the file structures don't have to be the same.
  2. The Text File Source only knows about the files you describe.  If a new file (with a different name) shows up in the folder, it will NOT automatically be recognized. 
    • Related Articles

    • 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) SQL Statements The query is ...
    • 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 is ...
    • 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 ...