12/7/2023 0 Comments Windows odbc managerPort: This number must match the port enabled on the server.if your server is lk., the ODBC URL might be lk. Note that for cloud-hosted instances of LabKey Server, this URL may differ from the actual server URL i.e. Server: The server you are connecting to, as listed in the External Tool Access grid.To use the more stringent "verify-ca" or "verify-full" options, you will need to install the server's certificate as trusted. Set to "require" if the target server uses TLS for a secure connection. Be sure there are no leading or trailing spaces in this path. Include a leading slash in the path, for example, "/Home" or "/Home/MyDataFolder". Database: A LabKey container path, that is, the project or folder you are connecting to.If you will need different data source configurations for different tools or different LabKey container paths, differentiate them by name of the data source. Data Source: This is the name you will select within the client tool.Enter the configuration details in the popup:.Select PostgreSQL Unicode from the list.Search for it as ODBC Data Sources (#-bit) under Windows Administrative Tools.On Windows, open the ODBC Data Source Administrator.Client tools use the ODBC driver to query this DSN. Creating a "system" DSN, as shown below, makes it available to various clients. On the client machine, create a "data source name" (DSN) to wrap a data container on LabKey Server. To cover all options, you can install both versions. For example, if you have a 32-bit version of Excel, then install the 32-bit ODBC driver, even if you have a 64-bit machine. You will need to install the version that matches your client tool, not necessarily the host machine. There are 32-bit and 64-bit drivers available. This latter is typically the x32 version which will be confirmed during installation. zip version without one of the extensions. Scroll down for the latest versions and note that the download page may show 圆4, x86 and a.Downloads for Windows are available at.On the client machine, install the latest version of the PostgreSQL ODBC driver. If you will be using a secure ODBC connection, you will need to download and install the SSL certificate from this page and install it on your local machine. To confirm that configuration has been completed, and obtain the relevant settings to use when setting up your driver, users can select (username) > External Tool Access. Configure PostgreSQL Client for Secure Connections.Prerequisite: External ODBC and JDBC Connections.An administrator must already have enabled ODBC connections on LabKey Server following this topic: This topic covers how to set up the host Windows machine to use the ODBC connection, including installation of the TLS access certificate for each user. This enables users to continue outside tools they may already be using with data stored in LabKey. Learn more or contact LabKey.Īn ODBC (Open Database Connectivity) Connection exposes the LabKey schema and queries as a data source to external clients for analysis and reporting. Premium Feature - Available in the Professional and Enterprise Editions of LabKey Server.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |