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
