Open Exchange App Ad Hoc Reporting for InterSystems Platforms now on Open Exchange

Primary tabs

Hello InterSystems Community,

We're excited to announce that we've completed our first Open Exchange submission for InterSystems platforms.

BridgeWorks VDM is an ad hoc reporting and graphical SQL query builder application that was designed for any user who needs access to their SQL projections in InterSystems Caché, InterSystems IRIS, InterSystems IRIS for Health databases as well as access to InterSystems DeepSee and InterSystems IRIS BI Cubes with minimal SQL scripting experience.  

VDM features:

  • Drag and a drop query builder
  • Interactive Data and Pivot grids
  • Charting and Gauges
  • Data Visualizations
  • Banded Report Writer
  • Report Scheduling and Batching
  • Web reporting capabilities
  • Data export to PDF, Excel, HTML, Word, CSV, Text Files, Image and more

VDM leverages the Managed Provider for .Net to communicate with InterSystems databases, and no ODBC drivers are needed to access the SQL projections for InterSystems Caché, InterSystems IRIS and InterSystems IRIS for Health.  VDM accesses DeepSee.RESTClient.cls for building MDX queries and communication with InterSystems DeepSee and InterSystems IRIS BI.

Video walk through: 

 

 

Notes:

While VDM is not a SQL syntax editor, the graphical query builder can be bypassed and SQL scripts can be pasted directly into the Advanced Query form for execution against your InterSystems database.

The InterSystems DeepSee and InterSystems IRIS BI features are currently EAP.

Community feedback on our project is appreciated.