Tableau User's Guide for Altibase#
Introduction#
This guide provides information on how to use Altibase on Tableau Desktop.
What is Tableau?#
Tableau is a data visualization tool focusing on business intelligence (BI). It supports Windows and Mac OS. For more details, please refer to the Tableau website.
Info
For errors and improvements related to this document, please contact the technical support portal or technical support center.
- Technical support portal: http://support.altibase.com/en
- Technical support center: +82-2-2082-1114
Info
This document is provided for informational purposes only and is subject to change without prior notice. It may contain errors, and Altibase makes no express or implied warranties of any kind, including but not limited to warranties of merchantability or fitness for a particular purpose.
The development, release, and timing of any features or functionality described for Altibase products in this document are at the sole discretion of Altibase.
Altibase may hold patents, trademarks, copyrights, or other intellectual property rights related to the contents of this document.
Software Requirements#
Tableau#
- JDK 1.8 (64bit) or higher
- Supports JDBC API Specification 4.0 or later
- Type-4 JDBC Driver (Pure Java)
- For more details about the software requirements, please refer to the Tableau website
This guide is based on the interoperability test with TableauDesktop-64bit-2021-4-4.
Altibase#
- JDK 1.8 (64bit) or higher
- Altibase Server 7.1.0.7.1 or later
- JDBC driver for Altibase 7.1.0.5.6 or later which partially supports JDBC API Specification 4.2 is required
How to Use Altibase on Tableau#
-
Meet the prerequisites for the Altibase Server to connect to Tableau.
-
Add the following property in $ALTIBASE_HOME/conf/altibase.properties then run the server
- TIMESTAMP_TO_DATE = 1
-
Download and execute mysql_date_function.sql
iSQL> connect sys/manager; iSQL> @mysql_date_function.sql
-
-
Install Tableau.
-
Copy and paste Altibase JDBC driver in C:\Program Files\Tableau\Drivers.
-
Altibase 7.1
Use $ALTIBASE_HOME/lib/Altibase42.jar. (From Altibase 7.1.0.5.6, JDBC driver that partially supports JDBC API Specification 4.2 is provided additionally)
-
Altibase 7.2
Use $ALTIBASE_HOME/lib/Altibase.jar.
-
-
Open Tableau, go to Connect > To a Server > More... and click Other Databases (JDBC).

-
Fill in the following entries to log in.
- URL: jdbc:Altibase://host_ip:port_no/database_name
- Username: User account
- Password: User password
- Properties File: Choose Altibase JDBC Driver (Below image is for Altibase 7.1)

-
The image below will be shown after logging in. Select the database from the list and select Tableau for schema.
