Forum Discussion
Creating a connector that uses a native component / ADBC
Hi SQLGuy,
Thanks for followup
Yes, you are right the libadbc_driver_flightsql.dll file is present in Power BI Desktop, but currently there’s no official guide or example from Microsoft on how to use it in custom connectors. Since Power BI’s M language runs in a sandbox, it can’t directly use native DLLs like this. Microsoft’s own connectors like Snowflake are built using C#, and they can work with these DLLs, but those methods and code are not shared publicly on GitHub.
For Deephaven, where performance really matters, using an ADBC-to-ODBC bridge would be a good temporary idea but as you said, right now, there’s no such bridge available. So if you want to get native performance, the it's technically possible but not officially supported where your code loads the DLL using P/Invoke and connects it with M code. But yes, this is a bit complicated and not officially supported at this time.
The broken link you saw earlier was probably just a placeholder.
We also hope Microsoft brings proper support for ADBC in the future. If anything official comes, we will surely update it here.
Hope this helps if you have any queries we are happy to assist you further.
Thank you.
Hi SQLGuy,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.
Regards,
Harshitha.
Hi SQLGuy,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.
Regards,
Harshitha.Hi SQLGuy,
I wanted to follow up and see if you have had a chance to review the information that was shared. If you have any additional questions or need further clarification, please don’t hesitate to reach out. I am here to assist with any concerns you might have.
Regards,
Harshitha.I have reviewed it, but I still do not see any ODBC/ADBC bridge actually existing. I have submitted an inquiry to the MS Fabric team to see what else I can find about the Connector creation process for new drivers.
