Integration LIMS Enterprise SDMS Description
Assays
Standard Assays βœ“ βœ“ Import any type of tabular data using custom assay designs.
Software
Client APIs βœ“ βœ“ Our APIs support all major scripting languages, including R, Java, JavaScript, and Python.
Excel βœ“ βœ“ Microsoft Excel spreadsheet data can be imported to and exported from LabKey for integration and analysis.
Jupyter Notebook βœ“ βœ“ Import Jupyter notebooks as reports and run them against live LabKey data.
MCP (Model Context Protocol) βœ“ βœ“ Connect AI agents directly to your LabKey data using the MCP server. Pull sample records, run searches, and retrieve results using natural language, without leaving your AI tool or exporting data.
Medidata Rave / CDISC ODM βœ“ Connect directly with, and import data from Medidata Rave servers.
Plotly Dash βœ“ βœ“ Supported via HTTP proxy.
R βœ“ βœ“ Connect LIMS Enterprise and SDMS to R. Connect SDMS to RStudio to query data, design and save reports, or link an existing RStudio Workbench installation. Display the results of an R script with the results updating as the underlying data changes.
REDCap βœ“ Synchronize with data in a REDCap server.
Skyline βœ“ Integrate with the Skyline targeted mass spectrometry tool.
Databases
Oracle βœ“ βœ“ Configure Oracle as an external data source.
Microsoft SQL Server βœ“ βœ“ Configure Microsoft SQL Server as an external data source.
MySQL βœ“ βœ“ Configure MySQL as an external data source.
PostgreSQL βœ“ βœ“ Configure PostgreSQL as a primary or external data source.
Authentication
CAS βœ“ βœ“ Configure single sign-on using CAS.
Duo βœ“ Configure two-factor authentication via the Duo service.
LDAP βœ“ βœ“ Configure authentication with an existing LDAP server.
SAML βœ“ βœ“ Configure authentication against a SAML provider.
TOTP βœ“ βœ“ Configure two-factor authentication using any TOTP-compatible authenticator app.
ODBC/JDBC Connections
Use these standardized interfaces to connect a variety of analysis tools to LabKey data. These are tools we have tested with ODBC and JDBC.
Access βœ“ βœ“ Use Microsoft Access tools on data housed in LabKey using an ODBC connection.
DbVisualizer βœ“ βœ“ Uses the JDBC driver to access LabKey data.
Excel βœ“ βœ“ Uses the ODBC driver to access LabKey data.
Informatica EDC βœ“ βœ“ Uses the JDBC driver to access LabKey data.
MATLAB βœ“ βœ“
Spotfire βœ“ βœ“ Uses the JDBC driver to access LabKey data from Spotfire.
Tableau βœ“ βœ“ Visualize LabKey data in Tableau via an ODBC connection.
Cloud Resources
Amazon Redshift βœ“ βœ“ Configure an Amazon Redshift database as an external data source.
Amazon S3 βœ“ βœ“ Configure Amazon S3 as a primary or external data source.
Snowflake βœ“ βœ“ Configure Snowflake as an external data source.