--- title: "Installing the standalone Windows ODBC driver to connect a BI app to Luminesce" slug: "installing-the-standalone-windows-odbc-driver-to-connect-a-bi-app-to-luminesce" updated: 2025-04-30T13:55:40Z published: 2025-04-30T13:55:40Z canonical: "support.lusid.com/installing-the-standalone-windows-odbc-driver-to-connect-a-bi-app-to-luminesce" --- > ## Documentation Index > Fetch the complete documentation index at: https://support.lusid.com/llms.txt > Use this file to discover all available pages before exploring further. # Installing the standalone Windows ODBC driver to connect a BI app to Luminesce If you have a Windows computer and an ODBC-aware BI app such as Tableau or Excel, you can install the Luminesce ODBC driver to query Luminesce providers directly from a familiar interface. To do this, you require: - Administrative privileges on a Windows 7 SP1+ computer - .NET Framework 4.7.2+ > [!NOTE] > Note > > If you have Power BI Desktop from the Microsoft Store, you can follow the ODBC driver installation instructions in the [Luminesce Power BI Connector](/v1/docs/installing-the-power-bi-connector-to-connect-power-bi-desktop-to-luminesce) article instead. If you have a non-Windows computer or a JDBC-aware BI app, see [this article](/v1/docs/installing-the-windows-dbc-server-driver-and-odbcjdbc-client-drivers-to-connect-bi-apps-to-luminesce). ## Installing the driver 1. As a LUSID user with the `lusid-administrator` role, navigate to `https://<your-domain>.lusid.com/honeycomb/swagger/index.html`, where `<your-domain>` is the root of your LUSID domain, for example `acmecorp`. If you do not have the `lusid-administrator` role, [see the appendix](/v1/docs/installing-the-standalone-windows-odbc-driver-to-connect-a-bi-app-to-luminesce#appendix-a-allowing-nonadministrative-users-to-download-binaries). 2. Use Swagger's **Try it out** button for the `DownloadBinary` API to request the `Odbc_Win64_Driver` binary: ![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/download odbc binaries(2).png) 3. Click the **Download file** link in the response to download the binary to your browser's download location: ![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/download file(2).png) 4. Launch the MSI in your preferred way, for example at the command line: ```plaintext msiexec /i Finbourne.Luminesce.ODBCWin64..msi ``` The MSI is currently unsigned, but it's safe to override any warnings: ![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/188aa283-6557-4514-90f6-08201153e33d.png) 5. On the **Custom Setup** screen, we recommend the default option of installing both 32-bit and 64-bit builds (even on a 64-bit system, since a typical Excel installation is 32-bit): ![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/9cab2cee-5de7-4cef-ba90-65cafc7e62a6.png) ## Configuring driver settings If you installed the 64-bit build: 1. Search for the **ODBC Data Sources (64-bit)** app using the Windows **Start** menu: ![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/51c50a8c-ba9b-4720-b45f-ce8a10d89019.png) 2. In the **ODBC Data Source Administrator (64-bit)** dialog, open the **System DSN** tab and choose to **Configure** the 64-bit build (the 32-bit build is listed but must be configured using the equivalent **ODBC Data Source Administrator (32-bit)** dialog): ![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/c2bd51c2-a9d7-443f-b5a4-6ea9283eec75.png) 3. In the **Luminesce ODBC Driver Configuration** dialog, enter the prefix of your LUSID domain, for example `acmecorp` for an `acmecorp.lusid.com` domain: ![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/681e48de-a832-4671-b0c5-14ebd9010014.png) 4. Choose an authentication method: - If you want an interactive login using the OAuth 2.0 PKCE flow, retain the default **Embedded web browser** option in the **User authentication** area (to use a browser component based on IE), or choose **System web browser** (which may satisfy CORS requirement in some environments). End users are prompted to sign in to LUSID using their username, password and MFA type the first time they run a query in a BI app, and subsequent times on token expiry (some apps may spawn multiple processes, which may each cause authentication challenges to occur). - To authenticate silently using the OAuth 2.0 Resource Owner flow, enter your **Client application** ID and **Client secret** in the **Service authentication** area. You are prompted for your LUSID username and password when you set up the new data source or the first time you run a query (depending on the app), but not subsequently. Note the client secret is stored in the system registry in plain text. [See how to generate a client ID and secret](/v1/docs/how-do-i-generate-and-reveal-a-client-secret). If you installed the 32-bit build as well, repeat steps 1-4 for that variant. ## Using a BI app to query a Luminesce provider The following example showcases using Excel to query the `Lusid.Instrument` provider supplied by FINBOURNE. > **Note:** An end user must have a valid LUSID user account and sufficient access control permissions to query the chosen providers. [Find out more](/v1/docs/creating-policies-to-control-access-to-providers-for-different-luminesce-end-users). 1. In Excel, select **Get Data > From Other Sources > From ODBC** from the **Data** menu: ![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/dc35859b-73ff-450d-87d3-c58ebbcda698.png) 2. In the **From ODBC** dialog, choose **Luminesce** from the **Data source name** dropdown: ![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/4e4a7898-4df7-41ba-a1f3-fb3d5e63054d.png) 3. When prompted, authenticate to LUSID using the username and password of a LUSID user. 4. In the **Navigator** dialog, choose one or more Luminesce providers to query, for example `Lusid.Instrument`: ![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/0990d44c-7798-4e41-8480-f9f46e98bc88.png) 5. Choose to **Load** data into Excel, for example: ![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/6f607c31-aa4d-475f-9959-89f2e16734aa.png) Note you can write an explicit [Luminesce SQL query](/v1/docs/understanding-the-luminesce-sql-query-syntax) in the **Advanced options** area of the **From ODBC** dialog (step 2). You can also specify parameters in the connection string in order to [cache result data](/v1/docs/caching-luminesce-query-results-from-bi-apps-for-faster-execution) for faster execution: ![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/6642404d-6f71-436f-82b7-1481cb6aefe4.png) ## Accessing logs By default, logs are written to: - 32-bit build: `C:\Windows\Temp\FinbourneLuminesce\ODBC32Logs` - 64-bit build: `C:\Windows\Temp\FinbourneLuminesce\ODBC64Logs` You can adjust the base directory (`C:\Windows\Temp\FinbourneLuminesce`) using the `LOGPATH` argument when running the MSI. ## Uninstalling the driver On Windows, you can uninstall the driver using **Add or remove programs** in the usual way, for example: ![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/7bcb0cc3-ea28-4514-99b0-f273f626d292.png) ## Appendix A: Allowing non-administrative users to download binaries Once a license is granted, users with the `lusid-administrator` role have permission to download the binaries out-of-the-box. To enable less privileged users to download, [create a feature policy](https://lusid.document360.io/v1/docs/how-do-i-create-a-feature-policy) consisting of the following JSON, assign it to a role, and the role to their LUSID user. For example, for `PowerBi_Connector` and `Odbc_Win64_Driver` you might create the following policy: ```json { "description": "User can download Power BI Connector and Windows ODBC Driver binaries", "applications": [ "Honeycomb" ], "grant": "Allow", "selectors": [ { "idSelectorDefinition": { "identifier": { "code": "PowerBi_Connector", "scope": "Honeycomb" }, "actions": [ { "scope": "Honeycomb", "activity": "DownloadBinary", "entity": "Feature" } ], "name": "Power BI connector binary", "description": "User can download Power BI Connector binary" } }, { "idSelectorDefinition": { "identifier": { "code": "Odbc_Win64_Driver", "scope": "Honeycomb" }, "actions": [ { "scope": "Honeycomb", "activity": "DownloadBinary", "entity": "Feature" } ], "name": "Windows ODBC driver binary", "description": "User can download Windows ODBC driver binary" } } ], "when": { "activate": "2023-01-01T00:00:00.0000000+00:00", "deactivate": "9999-12-31T23:59:59.9999999+00:00" } } ```