Ad Hoc Reporting for InterSystems Platforms now on Open Exchange

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: 

https://www.youtube.com/embed/xM5LKB0G25E
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

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.