Mercury depends upon stored procedures to retrieve data. Your own database developer or administrator should be able to create stored procedures. And your software reseller/VAR should have a developer on staff or on contract. These are your best choices because they will already have a good understanding of the databases in use at your site. However, we will provide development services at a modest cost to help you get the most out of your investment.
Mercury can use any stored procedure that returns a tabular result set. Multiple result-sets in one stored procedure for Master/Detail reports are also supported. Any number of parameters (including none) may be used. In practice, most stored procedures tend to use between zero and six parameters.
Stored procedures that only return output parameters or a return value are not supported. Return values (if any) with tabular data are ignored.
SQL Tables, Views, and Table-Valued Functions are not supported at this time. Although we have no plans to do so, we will re-evaluate if customers ask for it.
Try Mercury on a fully-functional 14-day trial. Download and install to use with your own data or try Mercury in a remote desktop session using our demo data.