External Study Database for participant demographics - best way to integrate with sample management and assays

LabKey Support Forum (Inactive)
External Study Database for participant demographics - best way to integrate with sample management and assays Jon (LabKey DevOps)  2017-07-04 23:43
Status: Closed
 
Thanks for confirming Steve.

You have a few options depending on whether the external schema is in the same DB as your LabKey schemas or in a different DB.

- If this external schema is within the same database as your LabKey schemas, you could configure a lookup or something similar after configuring this as an external schema.

- If this external schema is coming from a separate database, you could set it up as an external schema as well, but you would have no ability to do lookups.

https://www.labkey.org/Documentation/wiki-page.view?name=externalSchemas

But regardless of how the information is being presented to LabKey initially, neither of these options would allow it to just appear as a demographics dataset in a study.

In order to have that data appear as a demographics dataset, you would need to create an ETL module that would copy the data from the external schema and place it into the study schema's demographics dataset.

https://www.labkey.org/Documentation/wiki-page.view?name=etlModule

Regards,

Jon