The integration moves lab results entered in LabKey over to OpenClinica, so
we can more easily include that information in reports involving clinical
I did it using a Python script, which calls the (very comprehensive) LabKey
API to retrieve JSON data, maps the data to OpenClinica items, and calls
the OpenClinica SOAP API to schedule events / insert data, using .
This script is then run every night as a scheduled task on a server. Data
mapping failures, or other problems, are written to log files for the
project team to review and resolve.
If scripting isn't your thing, or you need something user facing, LabKey
has a rather nice data extraction interface where you can save and export
datasets in a range of formats, such as CSV. You could then use the
DataUploader tool  to map and import this to OpenClinica (not sure if
 handles repeat visits yet, otherwise there's ODIN  or the Access
Data Uploader , or the built in XML import UI).
I'm not certain about moving data from OpenClinica to LabKey, but it would
be a similar story - use the OC REST API (or extracts, or datamart) to
retrieve data from OC, and load into LabKey with a script or via the
website user interface.
So I guess like many clinical software system integrations, it's not
exactly plug and play
if you have any other questions feel free to ask.
(see readme on
On 17 Oct 2016 5:29 am, "sunbaghdad"
sunbaghdad sent you a message
I have read that your are using LabKey to connect with OpenClinica, can you
please tell me how did you do that ?
Or what tools do I need to make it happen ?