You can set up a remote connection to another instance of LabKey Server to support ETLs that move data from one to the other. Remote connections are not a direct connection to a database; instead data is accessed through HTTP-based API calls to the target server, generally as part of an ETL.

The connection is limited to a single specified folder on the target server, connected only to a specific folder on the originating server, making it easier to limit user access to data.

Set up a Remote Connection

Select a folder on the accessing server where you want to have access to data retrieved from the target server. In this accessing folder, the dataintegration module must be enabled on the > Folder > Management > Folder Type tab for the option to manage remote connections to be available.

• To encrypt the login to the remote server, you must have an Encryption Key defined in the application.properties file.
• Navigate to the accessing folder and confirm the dataintegration module is enabled.
• Go to > Developer Links > Schema Browser > Manage Remote Connections.

• Click Create New Connection and complete the form.

• Click Save.

Once a remote connection is defined, you can click Test to see if the connection is successful.

Related Topics

• ETL: Transform Types and Tasks - Use a remote connection as a data source for an ETL module.