TUTORIAL

 

Intro to OpenGate

Introduction

OpenGate is a database access technology for real-time data retrieval from MEDITECH’s Expanse, Client/Server and MAGIC platforms. OpenGate uses a SQL style syntax to query MEDITECH data directly. All OpenGate queries have a common set of keywords that define the fields and conditions of the data being requested from the database.

Included with OpenGate are the following:

  • Query Analyzer -a development tool for designing and writing queries

  • SSRS add-on - query data directly into Reporting Services Reports – no staging of data in SQL

  • SQL CLR integration - allows data to be queried directly into Microsoft SQL Server

  • Web service - query MEDITECH data directly through a web service for your custom applications

  • Database driver - ADO.NET database driver that can be used with any .NET development project

 

Query Analyzer

Query Analyzer makes use of OpenGate and allows for the development of queries with its extremely helpful toolset. This includes a schema browser for searching through the MEDITECH schema and examining data relationships.

OpenGate Query Analyzer

 

 

Schema Browser

The included schema browser lets you search through the MEDITECH schema to find fields and understand their relationships.

OpenGate Schema Browser.png

 

 

OpenGate Syntax

 

Select [NPR Element or M-AT Field]

From/Join [NPR Segment or M-AT Record]

Where [Condition on Element or Field]

 

SELECT

The SELECT clause defines the fields that will be returned in the query result.

FROM/JOIN

The FROM clause defines the indexes and records that OpenGate will use in order to gather the fields in the SELECT clause(s).

WHERE

The WHERE clause allows predicates to be added to the query so that records are only returned when they have certain properties

Select

MisPerson.IdX.Id,

MisPerson.IdX.IdType,

MisPerson.IdX.Active,

MisPerson.IdX.IsProvider

FROM MisPerson.IdX

JOIN MisPerson.Main

Use OpenGate within SQL Server, SSRS, C#, Web Service and more...

Bed Board App Using OpenGate
OpenGate SSRS Labor Board
Bed Usage Reports

©2020 by Blue Elm Company

Query Analyzer

Go to link