Notifications
Clear all
Topic starter
Has anyone successfully accessed data from an external database and displayed it using VFE?
I suspect there are ways using HL7 formats and interface engines such as QVERA and LinkLogic but what are the capabilities to connect to a non-CPS database and call tables/fields from that database.
THANK YOU in advance.
Posted : December 15, 2015 12:47 pm
I created a small C# program to interface with my other DB's within the network. It is called using RUNTEXTPROCESS(path_to_c#_program, argument_string) within the VFE form. You'll need a bit of programming knowledge to pull this off, though.
Dr. Fitzgerald had a CHUG session in 2014 about how to pull this off connecting to the CPS database, but it can be easily manipulated to pull from other databases. Here is the powerpoint: GETTING THE DATA YOU CAN’T GET - When MEL just isnt enough
Posted : December 16, 2015 4:24 am
Mikeseale's answer is the only way to do this. I have found it is best to place the C# program under the Client folder for permission reasons.
Posted : December 24, 2015 1:23 pm
