search

trinodb / trino

Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io)
https://trino.io
Apache License 2.0
10.45k stars 3.01k forks source link

Add support for ODBC driver #23067

Open josefjurak opened 2 months ago

josefjurak commented 2 months ago

Please add support for ODBC (Open DataBase Connectivity) multiplatform standard. Currently there is no usable option to connect to Trino from ODBC based tools (like Power BI) There is misleading information on https://trino.io/ecosystem/client.html#odbc page, Starburst connector is not working with Trino, and Magnitude bridge is functionally limited, and is only available commercially.

josefjurak commented 1 month ago

Any plan on this? This option is necessary for many tools based on the ODBC standard. Especially Power BI or Fabric, which are the industry standards for BI analysis, reporting and visualization. Currently, there is no efficient way to connect Power BI to a Trino. There is only a simple open-source Power BI connector for Trino that only supports standard import mode (thanks for that at least). But, it is not usable in real-world scenarios, it lacks incremental import mode, or direct query mode of Power BI models.