Integrating InsightEdge with Tableau
This topic describes how to integrate Tableau with InsightEdge in a Microsoft Windows environment 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
Integrating InsightEdge with Tableau
The GigaSpaces Tableau integration creates a JDBC connector for Tableau, so that Tableau Desktop can query the InsightEdge data grid directly using the InsightEdge JDBC driver. The integration 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 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.
Setting up the GigaSpaces-InsightEdge Connector for Tableau
The GigaSpaces-InsightEdgeconnector 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 implement 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 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 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.
To configure the data source after Tableau 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 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