Stored Procedures are not supported in TIBCO Spotfire connector for Amazon Redshift when using Amazon Redshift Cluster v1.0.7152 and lower

Stored Procedures are not supported in TIBCO Spotfire connector for Amazon Redshift when using Amazon Redshift Cluster v1.0.7152 and lower

When connecting to an Amazon Redshift database cluster v1.0.7152 or lower through TIBCO Spotfire connector in TIBCO Spotfire Analyst, stored procedures may fail to load. Custom user defined functions used in Redshift database are similar to stored procedures. But Redshift cluster v1.0.7152 and lower only supports "create scalar" user defined functions (UDF) while Amazon Redshift data connector in TIBCO Spotfire Analyst only supports "create table" user defined functions. Hence the stored procedures cannot be loaded through the Amazon Redshift data connector in TIBCO Spotfire Analyst when connected to Amazon Redshift Cluster v1.0.7152 and lower.

To use the stored procedures in the TIBCO Spotfire Amazon Redshift data connector, upgrade your Amazon Redshift Cluster to version 1.0.7562 or higher. See Amazon Redshift now supports stored procedures for more details. Doc: Details on Amazon Redshift Connection

• https://docs.tibco.com/pub/sfire-analyst/10.3.1/doc/html/en-US/TIB_sfire-analyst_UsersGuide/connectors/amazon-redshift/redshift_details_on_amazon_redshift_connection.htm

• https://aws.amazon.com/about-aws/whats-new/2019/05/amazon-redshift-now-supports-stored-procedures/

• Unsupported features:
  • https://docs.aws.amazon.com/redshift/latest/dg/c_unsupported-postgresql-features.html
• User defined functions:
  • https://docs.aws.amazon.com/redshift/latest/dg/user-defined-functions.html
  • https://docs.aws.amazon.com/redshift/latest/dg/r_CREATE_FUNCTION.html