Dear Fellow OC users and Devs,
I have been trying get my hands on creating a Data Mart for the OpenClinica as explained at the link http://en.wikibooks.org/wiki/OpenClinica_User_Manual/CommunityDataMart
. I had to make a couple of changes to the sql script as it was originally tested on Postgres 9.2 and I wanted to test this on studies running on ver. 8.4. Please find attached a copy of the final script. I have also installed an ODBC driver for postgres 8.4 but when I try to connect to the database from the Access Processor I get the error the application has been stopped due to runtime error. A screen short of my config setting is attached. Has anyone managed to get through setting up the Community Data Mart? If you happened to have bumped onto a similar issue, how did you manage to resolve it?
Thanks in advance for your help and contributions.