Analytics tools tips and tricks

just leaving it here in case someone is interested, this is possible with some scripting and using spotfire html text areas also check this option https://tibbr.tibcommunity.com/tibbr/#!/messages/92938

These are basic templates that will get you started, you may need to do additonal mappings etc in some cases. let me know if you find anything and I am more than happy to update the template here Vertica <jdbc-type-settings>    <type-name>Vertica</type-name>    <driver>com.vertica.jdbc.Driver</driver>    <connection-url-pattern>jdbc:vertica://host:port/db,dbadmin,dbpassowrd</connection-url-pattern>    <ping-command>SELECT 1 FROM DUAL</ping-command> </jdbc-type-settings>   Netezza <jdbc-type-settings>   <type-name>netezza</type-name>   <display-name>netezza</display-name>   <driver>org.netezza.Driver</driver>   <connection-url-pattern>jdbc:netezza://<host>/<database></connection-url-pattern>   <ping-command>Select 1</ping-command>  ...