![]() On the Tableau Server's command line, install the Tableau PostgreSQL ODBC driver with gdebi:įor example: sudo gdebi tableau-postgresql-odbc_b On the Tableau Server's command line, download the file with wget and paste the copied URL. This post assumes you have Tableau Server installed on a Ubuntu operating system.įind the latest PostgreSQL database drivers on Tableau's Driver Download page. Download the PostgreSQL Database Drivers From Tableau 3 min read Tableau Error: Unable to connect to the data sourceĪfter a fresh Tableau Server install, if you haven't installed PostgreSQL database drivers, you will run into this error when trying to view a Tableau Dashboard that has a live connection to PostgreSQL.Verify if the report is displaying properly and can connect to Apache Kylin correctly by opening it directly in Tableau Server web application. Pop up should be displayed with the preview of the report rendered by the server Important: For data source Authentication set Embedded - this is very important for data refresh to work, however keep in mind that the credentials will be embeded in the report thenĥ. Choose the settings for publishing like Project, select sheetsģ. In Tableau Desktop from top menu select Server -> PublishĢ. To publish the data source and the report follow these steps:ġ. Publishing reports from Tableau Desktop to Tableau Server Finish designing your data source and then switch to worksheets, dashboards If you’re forced to switch to extract mode - consider creating a custom query against Apache Kylin’s cubes to retrieve as small amount of data as possible as it will help the report to perform well.ĥ. Recommendation is to start with live mode to utilize performance of Apache Kylin. Some of the functions might not work in live mode as for the other data sources - it’s just how Tableau works. Important: Decide if you want the data source be in live or extract mode. You should be able to see the tables/cubes in the Apache Kylin’s project Configure the connection in the following way: Use “Other Databases (JDBC)” to create connection for the data sourceģ. ![]() Creating report in Tableau Desktop - connecting to Apache KylinĢ. Some more details regarding jdbc connection from Tableau are well described in Tableau’s documentation. ![]() Tableau Server and Tableau Desktop on Windowsįor either Tableau Server or Tableau Desktop that is installed on a Windows machine, copy the driver’s jar file to the following location C:\Program Files\Tableau\Drivers and restart Tableau Server or reopen Tableau Desktop. The server is now ready to create and refresh data from Apache Kylin. CentOS, copy the driver’s jar file to the following location: /opt/tableau/tableau_driver/jdbc/ and restart Tableau Server. If you have installed Tableau Server in a Linux box, e.g. The compiled jar is located in the following location: jdbc/target/kylin-jdbc-X.Y.Z.jar Tableau Server on Linux Mvn clean package -DskipTests -am -pl jdbc The fix was applied for version 3, so if for some reason you need a jar for earlier version, you have to apply the fix on the lower version’s codebase and compile yourself. Note: To make JDBC driver work properly, there has been a fix recently that upgraded one of the libraries used by the driver. You can either get it from the compiled package available on the download page from lib folder or compile it on your own using instructions below. Prerequisites Apache Kylin JDBC Driverįirst we need to get Apache Kylin JDBC Driver - kylin-jdbc-X.Y.Z.jar file. The configuration is platform independent - it works for both Windows and Linux installations of Tableau Server.įor the time of writing this guide we tested that it works with Kylin 3.0.0 and Tableau Server 2019.1. ![]() This document describes how to connect Tableau to Apache Kylin OLAP server, particularly (but not only) in live mode to use both reporting and analytics features of Tableau together with Apache Kylin’s fast query processing engine. Connecting Tableau Desktop and Tableau Server with Apache Kylin
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |