You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@doris.apache.org by "HERVOUET Christophe (External)" <ch...@kering.com.INVALID> on 2022/07/20 07:35:26 UTC

how to connect to doris from power BI

Hi  Doris  team

Congratulations on your very nice SQL DWH product
A beautiful promise

Can I ask you questions please  ?
A) LOAD : I assume your product supports Python scripting for integration ?
or "less code" ETL tool like TALEND?

B) READ : Is there  a Power BI connector ?
       - robust
       - no ODBC like
       - allows IMPORT & DIRECT QUERY modes
       - Does not require a Power BI gateway (access is public in the cloud if we want)

Is Doris accessible through a public cloud or is it necessarily an on-premises server / private cloud  ?

Thanks a lot  and best regards

Christophe Hervouet

Re:how to connect to doris from power BI

Posted by Mingyu Chen <mo...@163.com>.

Hi,
Thanks for your interest in Doris.
Doris internally implements the MySQL compatible protocol layer, so theoretically you can use any language mysql library or related tools to operate Doris.
For example, here we provide some code examples in different languages [1].

You can try to use PowerBI's MySQL connector to connect to Doris. Usually, there is no problem. If there are some compatibility problems, please contact us.

[1] https://github.com/apache/doris/tree/master/samples/connect

--

此致！Best Regards
陈明雨 Mingyu Chen

Email:
morningman@apache.org

At 2022-07-22 22:26:00, "HERVOUET Christophe (External)" <ch...@kering.com.INVALID> wrote:
>Hi  Doris  team
>
>Congratulations on your very nice SQL DWH product
>A beautiful promise
>
>Can I ask you questions please  ?
>A) LOAD : I assume your product supports Python scripting for integration ?
>or "less code" ETL tool like TALEND?
>
>B) READ : Is there  a Power BI connector ?
>       - robust
>       - no ODBC like
>       - allows IMPORT & DIRECT QUERY modes
>       - Does not require a Power BI gateway (access is public in the cloud if we want)
>
>Is Doris accessible through a public cloud or is it necessarily an on-premises server / private cloud  ?
>
>Thanks a lot  and best regards
>
>Christophe Hervouet