Evaluating Mercury with your Own GP Data

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 simple.


Every Mercury report is associated with a data “Connection” that specifies a server and a database.  And all of the sample GP reports use the same data Connection.


So: all you have to do is edit one Connection, changing the properties so that the connection points to your server (and desired company database) instead of ours, and you’re done!  Your sample GP reports will instantly use your own data.


For complete information on creating and editing Connections, see the Mercury documentation on Admin > Connections


In the Mercury main window:

  1. Click on Admin Tools in the Settings ribbon.

  2. Click Connections

  3. Click on the “GP1” connection to select it.  The connection’s properties are displayed in the lower grid.

  4. Click the “Edit” button on the toolstrip.

  5. Optional, but recommended: edit the connection’s description so that it’s meaningful in your context.

  6. Change various connection properties

    1. Data Source = your GP server name or IP address

    2. Initial Catalog = your GP Company database name

    3. Integrated Security: if you use Windows Authentication to access your database, change this to Yes -- and you're done.  The user who runs Mercury must have appropriate select permissions on the views and tables used in these reports.

Otherwise, leave Integrated Security as “No” and also change these:

  1. User ID = a valid SQL login-name on your server

  2. Password = the password associated with the SQL login


To simplify your evaluation, we suggest that you create a new Sql Login and add it to the DYNGRP role in the GP database.  You can delete the login at the end of the evaluation.


Note: the password is masked, and it is also encrypted before being saved with the Connection.


  1. Click the “Save” toolstrip button when you’re done.


Here’s an example showing edited values for the GP1 connection, just prior to saving.





    • Related Articles

    • Microsoft Dynamics GP Actions

      By using Mercury "Actions" in a report based on a Dynamics GP database, you can: Open an underlying GP form associated with the data (a drillback) Open an attached document Each of these is features is discussed in detail below. For a general ...
    • 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) ...
    • Installing Mercury

      Requirements Microsoft Windows 64-bit (Windows 7 or higher) .NET Framework 4.8 or higher  If you’re installing a trial, there are no restrictions or limitations, and no credit card is required. Some Background Report layouts and other metadata are ...
    • Mercury Overview

      What is Mercury? Mercury is a general-purpose reporting and analysis tool that works with a variety of databases - for example: SQL Server, MySQL, Business Central (and other OData sources), CSV files, and others. Reporting and analysis are no longer ...
    • Mercury Quick Start for Users

      Thank you for installing Mercury! Here you’ll find a quick introduction – what you see when you launch Mercury, and a few examples of how to run reports. When You Launch Mercury Depending on whether your organization already has Mercury, you’ll ...