Stored Procedures

Adhoc Query Solutions

CrossCompass will allow end-users and programmers alike the ability to perform adhoc queries on various data sources.

CrossCompass will also enable data extraction via database stored procedures via a user friendly interface.

Normally query tools only execute database views setup for reporting purposes whereas stored procedures are used to control external application access to tables. But why not create stored procedures to add the flexibility of parameters that views cannot provide.

In fact if required, user queries against the database can be restricted to only being able to execute views and stored procedures via a simple to use user interface.

You may also have various systems with different databases. The users (if allowed) can see all the views & procedures all in one screen. The user is a member of a group and each group's access to views and procedures is controlled by the administration suite.

The user having extracted the data can manipulate the results in many ways:

• Re-order the output columns in the grid. 
• Drag & Drop the columns to group the data
• Merge the data with Excel or CSV or both

Once extracted and manipulated the grid contents can be saved into various formats such as Access, XML/HTML, CSV/Excel and PDF.

The user can also design a report via our report designer suite. This report can then be deployed for groups of users to execute.

Installations

Flexible Usage and Licensing as CrossCompass will allow the query engine to be used in different ways and the associated prices reflects this usage.

Power Users 
These users have the full extent of CrossCompass functionality:

• Accessing multiple data sources including CSV/Excel
• Merging data with CSV & Excel.
• Executing bespoke reports and filtering data.

Standard Users 
These users are presented with a simpler interface and can:

• Access multiple data sources. 
• Merge data with CSV & Excel.

• Access only database content. 
• Execute bespoke reports and filter data.

Restricted Users 
These users are presented with a view/stored procedure execution interface to:

• Invoke the pre-defined views.
• Invoke the stored procedures with parameters.

Lightweight Users 
These users are presented with a report execution interface to:

• Execute bespoke reports.

In an installation all types of users can exist depending on the requirement. 

All in all adding total flexibility to licensing.

For more information on the stored procedures capabilities of CrossCompass please download the overview documentation:

CrossCompass and Stored procedures (PDF)

or Download the system