Getting started
-
Download the EXASOL JDBC driver and extract the exajdbc.jar.
-
Copy the exajdbc.jar to to the Spotfire® library directory, see the following link where this directory is located: https://community.spotfire.com/s/article/spotfirer-jdbc-data-access-connectivity-details
-
Restart the Spotfire Server so the EXASOL jdbc driver is loaded.
-
Start the Spotfire Server configuration tool.
-
Go to the Configuration tab and create a new Data Source Template.
-
In the Add data source template enter EXASOL as name and copy paste the following template:
<jdbc-type-settings>
<type-name>EXASOL</type-name>
<driver>com.exasol.jdbc.EXADriver</driver>
<connection-url-pattern>
jdbc:exa:<host>:<port>;clientname=Spotfire;
</connection-url-pattern>
<ping-command>SELECT 1</ping-command>
<supports-catalogs>false</supports-catalogs>
<supports-schemas>true</supports-schemas>
<java-to-sql-type-conversions>
<type-mapping>
<from max-length="2000000">String</from>
<to>VARCHAR($$value$$)</to>
</type-mapping>
<type-mapping>
<from>Integer</from>
<to>DECIMAL(18,0)</to>
</type-mapping>
<type-mapping>
<from>Long</from>
<to>DECIMAL(36,0)</to>
</type-mapping>
<type-mapping>
<from>Float</from>
<to>REAL</to>
</type-mapping>
<type-mapping>
<from>Double</from>
<to>DOUBLE PRECISION</to>
</type-mapping>
<type-mapping>
<from>Date</from>
<to>DATE</to>
</type-mapping>
<type-mapping>
<from>DateTime</from>
<to>TIMESTAMP</to>
</type-mapping>
</java-to-sql-type-conversions>
</jdbc-type-settings>
-
Save the config, close the configuration tool and restart the server
-
Check the logs if the XML config for EXASOL was validated correctly
-
Use the Information Designer tool in the Spotfire Analyst to create a new Data Source
Recommended Comments
There are no comments to display.