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.