Skip to main content

Data Source Template for AWS Redshift using the Redshift JDBC driver.

Rich Talbot
  • Created
Date Posted:
Product: TIBCO Spotfire®

Problem:

Data Source Template for AWS Redshift using the Redshift JDBC driver.


Solution:


When using the JDBC41 driver, use the following template.

====================================================== AWS Redshift com.amazon.redshift.jdbc41.Driver jdbc:redshift://endpoint:port/database SELECT 1 com.spotfire.ws.im.ds.sql.BasicJDBCMetadataProvider 10000 100 TABLE, VIEW true true true 1000 10000 false [$$catalog$$.][$$schema$$.]$$table$$ [$$catalog$$.][$$schema$$.]$$procedure$$ to_char($$value$$, 'HH24:MI:SS') $$value$$ ======================================================

When using the JDBC4 driver, use the following template.

================================================= AWS Redshift com.amazon.redshift.jdbc4.Driver jdbc:redshift://endpoint:port/database SELECT 1 com.spotfire.ws.im.ds.sql.BasicJDBCMetadataProvider 10000 100 TABLE, VIEW true true true 1000 10000 false [$$catalog$$.][$$schema$$.]$$table$$ [$$catalog$$.][$$schema$$.]$$procedure$$ to_char($$value$$, 'HH24:MI:SS') $$value$$

=================================================

http://docs.aws.amazon.com/redshift/latest/mgmt/configure-jdbc-connection.html

Related articles

Comments

0 comments

Article is closed for comments.