This is what I found from this web-site.
http://www.virec.research.med.va.gov/DataSourcesName/VISTA/VISTAaccess.htm#SQL
SQL
<http://www.virec.research.med.va.gov/DataSourcesName/VISTA/VISTAaccess.htm#Top>
Investigators planning to construct a relational database of VistA
data will find that few sites offer direct access to VistA data using
SQL (Structured Query Language). Instead, data are most often exported
from VistA with an M or MUMPS ( Massachusetts General Hospital Utility
Multi-Programming System) program and then mapped to a relational
database .
Commercially available software applications like MUMPS Data Extractor
(MDE) and KB SQL allow direct SQL access to MUMPS data. Another
M-based SQL mapping system is built into VistA's Cache. A few sites
have the necessary software for direct M-to-SQL access but several
more tried and abandoned it. They found it was too expensive and/or
put too much strain on the operation of the local VistA system.
The VA FileMan application SQL Interface (SQLI) was an attempt to
provide the data dictionary information needed to map VA FileMan files
to a relational database. SQLI is not able to provide access to VA
FileMan data on its own. Instead, it provides information about VA
FileMan's internal data dictionary to an M-to-SQL application like KB
SQL or MDE. Since the available M-to-SQL products can map VA FileMan
data without help from SQLI, SQLI has not been heavily used.
Molly
Cameron Schlehuber wrote:
VistA uses the Data Extracts package to collect and pass out data
specifically for the purposes of management decisions support for budget
analysis, projection, business changes for better use of resources etc. The
tool used for the analysis is a COTS product ($$$$$).
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Eriam
Schaffter
Sent: Wednesday, April 13, 2005 9:21 AM
To: hardhats-members@lists.sourceforge.net
Subject: [Hardhats-members] Hospital Cost analysis
Hello all this is Eriam Schaffter
I'm in europe and i'm working on a cost analysis software for hospitals.
Is there such a module in OpenVista ?
If not i would investigate the need for integration of OpenVista with
the software i'm working on, could you tell me if there would be an
interest for such a solution (a light business intelligence tool) in the
world of OpenVista.
For integration techniques i'll have to go into the code but is there
any way to fetch datas from Openvista with sql queries ?
Thanks
Eriam Schaffter
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
Hardhats-members mailing list
Hardhats-members@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hardhats-members
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_ide95&alloc_id396&opĚk
_______________________________________________
Hardhats-members mailing list
Hardhats-members@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hardhats-members
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_ide95&alloc_id396&op=click
_______________________________________________
Hardhats-members mailing list
Hardhats-members@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hardhats-members