Datasource Templates

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> 
  <fetch-size>10000</fetch-size> 
  <batch-size>100</batch-size> 
  <table-types>TABLE, VIEW</table-types> 
  <supports-catalogs>true</supports-catalogs> 
  <supports-schemas>true</supports-schemas> 
  <supports-procedures>true</supports-procedures> 
</jdbc-type-settings>

 JTopen / AS400

<!-- START of new AS400 Driver com.ibm.as400.access.AS400JDBCDriver.class -->
  <data-source-template>
        <enabled>true</enabled>
        <definition><![CDATA[<jdbc-type-settings>
    <type-name>as400_jdbc_jtopen</type-name>
    <driver>com.ibm.as400.access.AS400JDBCDriver</driver>
  <connection-url-pattern>jdbc:as400://&lt;systemName&gt;/&lt;defaultSchema&gt;;&lt;listOfProperties&gt;</connection-url-pattern>
  </jdbc-type-settings>]]></definition>
        <name>AS400 (JTOPEN)</name>
    </data-source-template>
  <!-- END of new AS400 Driver com.ibm.as400.access.AS400JDBCDriver.class -->

KDB

<jdbc-type-settings>
<type-name>KDB</type-name>
<driver>jdbc</driver>
<connection-url-pattern>jdbc:q:&lt;host&gt;:&lt;port1521&gt;</connection-url-pattern> <ping-command>SELECT 1</ping-command>
<metadata-provider>com.spotfire.ws.im.ds.sql.BasicJDBCMetadataProvider</metadata-provider>
<fetch-size>10000</fetch-size>
<batch-size>100</batch-size>
<table-types>TABLE, VIEW</table-types>
<supports-catalogs>false</supports-catalogs>
<supports-schemas>false</supports-schemas>
<supports-procedures>false</supports-procedures>
<max-in-clause-size>1000</max-in-clause-size>
</jdbc-type-settings>

VectorWise

<jdbc-type-settings>
  <type-name>VectorWise</type-name>
  <display-name>vectorwise</display-name>
  <driver>com.ingres.jdbc.IngresDriver</driver>
  <connection-url-pattern>jdbc:ingres://&lt;host&gt;:&lt;port&gt;/&lt;dbname&gt;</connection-url-pattern>
  <supports-catalogs>true</supports-catalogs>
  <supports-schemas>true</supports-schemas>
</jdbc-type-settings>

Postgres / Redshift

(when using redshift you may have to increase batchsize and fetch size to a big number like 100000)

<jdbc-type-settings>
  <type-name>PostgreSQL</type-name>
  <driver>org.postgresql.Driver</driver>
  <connection-url-pattern>jdbc:postgresql://&lt;host&gt;:&lt;port&gt;/&lt;database&gt;</connection-url-pattern>
  <ping-command>SELECT 1</ping-command>
  <metadata-provider>com.spotfire.ws.im.ds.sql.BasicJDBCMetadataProvider</metadata-provider>
  <fetch-size>10000</fetch-size>
  <batch-size>100</batch-size>
  <table-types>TABLE, VIEW</table-types>
  <supports-catalogs>true</supports-catalogs>
  <supports-schemas>true</supports-schemas>
  <supports-procedures>true</supports-procedures>
  <max-in-clause-size>1000</max-in-clause-size>
  <condition-list-threshold>7000</condition-list-threshold>
  <expand-in-clause>false</expand-in-clause>
  <table-expression-pattern>[$$schema$$.]$$table$$[@$$catalog$$]</table-expression-pattern>
  <procedure-expression-pattern>[$$schema$$.]$$procedure$$[@$$catalog$$]</procedure-expression-pattern>
  <create-temp-table-command>CREATE GLOBAL TEMPORARY TABLE $$name$$ $$column_list$$ ON COMMIT PRESERVE ROWS</create-temp-table-command>
  <drop-temp-table-command>TRUNCATE TABLE $$name$$;DROP TABLE $$name$$</drop-temp-table-command>
  <lob-threshold>2000</lob-threshold>
  <procedure-table-jdbc-type>-10</procedure-table-jdbc-type>
  <sql-runtime>com.spotfire.ws.im.ds.sql.postgresql.PostgresSQLRuntime</sql-runtime>
</jdbc-type-settings>

TEIID

    <jdbc-type-settings>

    <type-name>teiid</type-name>

    <driver>org.teiid.jdbc.TeiidDriver</driver>

    <connection-url-pattern>jdbc:teiid:&lt;vdb-name&gt;@mm:&lt;host&gt;:&lt;port&gt;</connection-url-pattern>

    <ping-command>SELECT 1</ping-command>

    <metadata-provider>com.spotfire.ws.im.ds.sql.BasicJDBCMetadataProvider</metadata-provider>

    <fetch-size>10000</fetch-size>

    <batch-size>100</batch-size>

    <table-expression-pattern>[$$schema$$.]$$table$$</table-expression-pattern>

    <table-types>TABLE, VIEW</table-types>

    <supports-catalogs>true</supports-catalogs>

    <supports-schemas>true</supports-schemas>

    <supports-procedures>true</supports-procedures>

  </jdbc-type-settings>