Hello, I am using Helical Insight version 5.2.1 Enterprise version. I see that you are supporting DuckDB (Databases and Relevant Drivers - Helical Insight) . Can I connect to DuckDB from a remote server using Helical Insight ?
I am able to connect to DuckDB present on my local laptop. However am not able to connect to the remote DuckDB instance.
Hello Netta,
DuckDB does not support remote connections because it’s an embedded database and works locally within the application. It does not support client server kind of architecture.
In order to use DuckDB present on some other server, some other method has to be used like tunnelling it and then connecting, or using some 3rd party tool or creating a custom API etc.
Thank You,
Helical Insight Team.