How to connect PowerBI with Crate Database?

[Anonymous]

I have a database on Crate DB. The database program is started through docker-compose.yml file. Is there any step by step guide on how to connect PowerBI with Crate DB?

I've already followd this tutorial https://crate.io/a/use-power-bi-with-cratedb-for-end-to-end-data-warehousing-and-business-intelligen..., however, under the "Configure the ODBC Data Source", where it says to add the "PostgreSQL Unicode", I don't see that option on my computer. I have already installed the driver that it says at the beginning of the guide. What might be the problem?

Thank you a lot

[TeigeGao]

Hi @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

[Anonymous]

Hello @TeigeGao .Thank you for the reply. Seems like the problem was I didn't download the x64 version.

However, now I have another problem that prevents me from connecting to Crate DB.

As I said, the database program (Crate) is started through docker-compose.yml file. Crate 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?

[Anonymous]

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?