If you want to work with data that your company keeps in SQL databases, Mercury relies on stored procedures or views for data retrieval.
Your own database developer or administrator should be able to create stored procedures and views (you may be comfortable doing this yourself). 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 Mercury subscription.
A few notes on stored procedures:
Neither direct access to SQL tables, nor the use of Table-Valued Functions, is supported at this time – you can retrieve whatever you need via stored procedures or views. But if customers request those features, we are happy to re-evaluate.
Start with a fully functional 14-day free trial. No restrictions or limitations.