Skip to content
English
Go to sera4.com
  • There are no suggestions because the search field is empty.

Teleporte Data in ClickHouse

This guide explains how to install the required ODBC driver, prepare the connection details, and connect Power BI Desktop to ClickHouse.

1. Installation of the ODBC Driver

Before connecting Power BI to ClickHouse, install the ClickHouse ODBC Driver on your Windows computer.

Before you begin

Make sure you have:

  • A Windows computer with administrator permissions.
  • Power BI Desktop is installed.
  • A 64-bit version of Power BI Desktop, in most cases.

The ODBC driver and Power BI Desktop must use the same architecture. For most current installations, use the 64-bit driver.

Download the ClickHouse ODBC Driver

  1. Open the official ClickHouse ODBC Driver releases page.
  2. Open the latest stable release.
  3. Download the Windows 64-bit .msi installer from Assets.

Install the driver

  1. Open the downloaded .msi file.
  2. If Windows displays a security warning, select Run or Allow.
  3. Follow the installation wizard and accept the license agreement.
  4. Keep the default installation options unless your organization requires a different location.
  5. Select Install.
  6. Select Finish when the installation is complete.

Verify the installation

  1. Open the Windows Start menu.
  2. Search for ODBC Data Sources.
  3. Open ODBC Data Sources (64-bit).
  4. Select the Drivers tab.
  5. Confirm that a ClickHouse ODBC driver appears in the list.

Windows provides separate ODBC administrators for 32-bit and 64-bit applications:

  • 64-bit ODBC Administrator: C:\Windows\System32\odbcad32.exe
  • 32-bit ODBC Administrator: C:\Windows\SysWOW64\odbcad32.exe

Use the administrator that matches your Power BI Desktop installation.

Restart your computer

After installing the ODBC driver:

  1. Close Power BI Desktop completely.
  2. Restart the Windows computer.
  3. Open Power BI Desktop again after Windows has restarted.

2. What You Need Before Connecting Power BI Desktop to ClickHouse

Connection information from Sera4

You need the following information from Sera4:

  • Host
  • Port
  • Database
  • ClickHouse username
  • ClickHouse password

If you do not have this information, contact Sera4 Customer Support at CS@sera4.com. 

Provide your public IP address to Sera4

Sera4 needs to allow your public IP address before your computer can connect to the Teleporte ClickHouse database.

To find your public IP address:

  1. Open Windows PowerShell.
  2. Run the following command:
    (Invoke-RestMethod -Uri "https://api.ipify.org").Trim()
  3. Copy the result and send it to Sera4 Customer Support at CS@sera4.com.

Your public IP address may change if your internet provider assigns dynamic IP addresses. If your connection stops working after an IP address change, send the new address to Sera4.

3. Steps to Connect Power BI Desktop to ClickHouse

  1. Open Power BI Desktop.
  2. Select Home > Get data.
  3. Select the ClickHouse connector.
  4. Select Connect.
  5. Enter the connection information provided by Sera4:
    • Host: Enter the ClickHouse host. (Make sure you DON'T add "https://" at the beginning)
    • Port: Enter the ClickHouse port.
    • Database: Enter the database name.
    • Options: Leave blank unless Sera4 provides specific options.
    • Data connectivity mode: Select Import or DirectQuery, according to your reporting requirements. We recommend using DirectQuery due to the large amount of data.
  6. Select OK.
  7. When prompted for authentication, select the ClickHouse username and password authentication method.
  8. Enter the ClickHouse username and password provided by Sera4.
  9. Select Connect.
  10. In the Navigator window, select the Teleporte tables you want to use.

    teleporte-power-bi
  11. Select Load to import the data directly into Power BI, or select Transform Data to make changes before loading it.

4. You Are Ready to Use Your Teleporte Data

Your Teleporte data is now connected to Power BI Desktop and is ready to use. You can create reports, dashboards, charts, and other visualizations using the available Teleporte tables and fields.

The following image shows an example of Teleporte data being visualized in Power BI:

image (54)

If the connection fails

Check the following:

  • The host, port, and database were entered exactly as provided by Sera4.
  • The username and password are correct.
  • Your public IP address has been provided to Sera4. Make sure you have a confirmation via email.
  • The ClickHouse ODBC driver was installed successfully.
  • Power BI Desktop was closed, and Windows was restarted after installation.
  • Your computer has network access to the ClickHouse service.

For additional help, contact Sera4 Customer Support at CS@sera4.com.