IPeople Direct

• Leverage real-time access to all NPR, $T, and M-AT LIVE MEDITECH data using SQL. No Magic code required!
• Connect real-time to other MAGIC and NPR-based vendor applications
• Query multiple applications simultaneously eliminating the need for fragments
• Access over 4,500 additional MEDITECH tables that are otherwise inaccessible through the NPR Report Writer
• Easily access MEDITECH Custom Defined Screen (CDS) data
• Identify relationships between tables, fields, and applications with IPeople’s SmartJoin technology

REPORT WRITING IPeople Direct allows you to query your live MEDITECH data through applications such as Excel, Access, and Crystal Reports. Link multiple tables, applications, and catalogs; select desired fields; and return data effortlessly into the PC-based front-end application.

CUSTOM FORMS and VIEWS IPeople Direct allows users to employ any web scripting language that supports ODBC/ADO.NET to retrieve data and display the results on a web form. Consider also that by creating an ADO connection, users can build Visual Basic front-end user applications that display MEDITECH data in real-time.

TABLE VIEWER Preview data to ensure accurate table/field selection during the report or interface development process. Quickly identify fields, tables, and table relationships in MEDITECH.

SMARTJOIN TECHNOLOGY Create efficient joins across tables, applications and catalogs simultaneously, eliminating the need for fragments. Our SmartJoin technology provides a listing of efficient joins across 3 million table/field combinations and alerts users of errors if an inaccurate join is attempted.

SECURITY Control which data can be accessed by a user at the facility, database, table and column levels. IPeople’s security layer supports Windows Authentication, defined MEDITECH user/password or customized IPeople Connect user/password.

AUDIT LOGS Monitor user activity by tracking user information, activity date and time, and executed SQL statements.