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.
Schema Browser
The included schema browser lets you search through the MEDITECH schema to find fields and understand their relationships.
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...
