Integrating InsightEdge with Tableau Desktop
This topic describes how to integrate Tableau Desktop with InsightEdge using the InsightEdge JDBC connector to retrieve data for visualization and business intelligence needs.
Your host machine must have the following installed:
Java 8 or higher
Tableau version 2019.1 or higher
(2020.1 or later includes simpler connector integration)
(MacOS only) Maven Artifacts
Setting Up the InsightEdge JDBC Connector
The GigaSpaces-Tableau integration package provides an automated script that creates the JDBC connector for Tableau Desktop, so that Tableau Desktop can query the InsightEdge data grid directly using the InsightEdge JDBC driver. You can customize some default values for the setup process if necessary, as well as create standalone packages for other Tableau users so they can run analytics on data from InsightEdge .
The integration package is available in the
<product>/tools/tableau folder of the InsightEdge software package. It contains the following files:
gs-tableau.bat- runs the setup process for the GigaSpaces-InsightEdge JDBC connector.
gs-tableau-env- environment variables that can be used to customize certain default values for the setup process.
gs-tableau-package- script that creates a standalone connector package.
Adding the InsightEdge JDBC Driver to Tableau
In Tableau 2020.2 and later, a class loader isolation option was introduced.
It is necessary to disable this option by editing the
gs-tableau.bat script as follows:
Under :RUN_TABLEAU, add this parameter to the "start" line:
The GigaSpaces-InsightEdge connector is based on the Tableau Connector SDK and JDBC integration. The setup process includes providing proprietary requirements about various file locations and execution arguments. GigaSpaces provides a script that automates the setup process and starts Tableau Desktop with the GigaSpaces-InsightEdge connector enabled.
To setup the GigaSpaces-Tableau integration, run the
The first time this script runs it requires elevated permissions, because it automatically packages and copies the InsightEdge JDBC driver to Tableau's installation files, which generally reside in the
Program Files folder.
Customizing the Setup Process
If necessary, you can customize some of the default setup process values, such as the location of the Tableau installation folder or the JDBC driver heap size. To do this, open the
product>/tools/tableau/gs-tableau.env script and edit the required environment variables.
Creating a Standalone Connector Package
If your organization includes Tableau Desktop users who aren't developers (for example, data scientists that don't need InsightEdge installed locally) you can provide a standalone connector package so that these users can integrate the GigaSpaces-InsightEdge connector with their Tableau Desktop installation and perform the necessary analytics on the InsightEdge data.
To create the connector package, run the
gs-tableau-package script from the
<product>tools\tableau folder. This package can then be distributed and installed on any machine to enable accessing InsightEdge data using Tableau Desktop.
In order to integrate Tableau Desktop with InsightEdge in a MacOS environment, you have to create the InsightEdge JDBC driver, copy it to the Drivers folder in the Tableau Desktop program files, and then point to the InsightEdge JDBC connector in Tableau Dektop. This process requires that you have Maven Artifacts already installed on the host machine where you will create the InsightEdge-Tableau integration.
Adding the InsightEdge JDBC Driver to Tableau
To add the InsightEdge JDBC driver to Tableau:
If the JDBC driver was not yet created, run the following command to create the
Run the following command to copy the JDBC driver to the Tableau Drivers folder.
Run the Tableau Desktop application with a pointer (the
-DConnectPluginsPathsystem property) to the InsightEdge JDBC driver in the Tableau program files, as shown in this sample command:
"/Applications/Tableau Desktop 2019.2.app/Contents/MacOS/Tableau" -DConnectPluginsPath=$$GS_HOME/tools/tableau
Connecting to the Space
To configure the data source after Tableau Desktop is started:
Click Connect in the Tableau desktop, and select Gigaspaces InsightEdge as the data source.
If Gigaspaces InsightEdge does not appear in the Connect menu on first access ,click More and select Gigaspaces InsightEdge from the alphabetic list.
- In the Gigaspaces InsightEdge window, configure the options as follows:
- Type the Server host name or IP address. Include the port number if the Space is not using the default port.
- (Optional) If your InsightEdge system includes AnalyticsXtreme, you can type True for Enable AnalyticsXtreme.
- Type the Space name.
- (Optional) Add Advanced Parameters for the JDBC connection as key-value pairs.
If your system is configured with a secure Space, type the Username and Password.
For more information about secure Spaces, see the Security section of the Administration guide.
Click Sign In to connect to the InsightEdge data grid.
Verify that Tableau Desktop can see the tables in your Space.
If your data source uses POJOs, they must be configured for java.sql.Date rather than java.util.Date.
Querying the Space using Tableau
After the setup process is complete and the connection has been configured, you can execute queries against the InsightEdge data grid.
Predictive Stock Pricing Demo