Forum Discussion
How to connect PowerBI with Crate Database?
Solution SageHi Anonymous ,
As mentioned in that article, CrateDB supports the PostgreSQL wire protocol, we can use PostgreSQL ODBC driver to connect to it as an ODBC source.
The ODBC Data Source Administrator has 32-bit and 64-bit edition, we need to choose the same one of the driver, if you download the 64-bit driver, then please open 64-bit ODBC Data Source Administrator.
Then you will see it if you have installed the psqlodbc_11_01_0000 driver:
Best Regards,
Teige
Thank you TeigeGao for the reply. It seems like the problem was that I didn't download the x64 version.
However, now I have another problem that prevents me from connecting to the database.
As I said, the database program (Crate) is started through docker-compose.yml file. The Crate DB is running on http://192.168.99.100:4200 (this is the docker machine's IP with the Crate's port).
When I try to configure the PostgreSQL OBCD Driver, I don't know what to type on "Server" field.
So far I've tried "localhost", "127.0.0.1","0.0.0.0", "192.168.99.100" but none of these works.
So my question is, which IP address should I type on the "server" field?