Skip to main content

"Save" option grayed out while saving a data source in Information Designer for TIBCO Spotfire installed client

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

Problem:

"Save" option grayed out while saving a data source in Information Designer for TIBCO Spotfire installed client


Solution:

While saving a data source in Information Designer, the "Save" button might be grayed out after entering all the required field values.

User-added image

This can be seen if "connection-url-pattern" value in the data source template is updated with the data source "Connection URL" value. For example, the data source template for snowflake data source is as below.
  

<jdbc-type-settings>
<type-name>Snowflake</type-name>
<driver>net.snowflake.client.jdbc.SnowflakeDriver</driver>
<connection-url-pattern>jdbc:snowflake://&lt;ACCOUNT&gt;.snowflakecomputing.com</connection-url-pattern>
<supports-catalogs>true</supports-catalogs>
<supports-schemas>true</supports-schemas>
<supports-procedures>false</supports-procedures>
<fetch-size>10000</fetch-size>
<batch-size>100</batch-size>
<use-ansii-style-outer-join>true</use-ansii-style-outer-join>
</jdbc-type-settings>

However, if the data source template is updated as below then the save button for Data source would be disabled, even after entering all the required details. 
<jdbc-type-settings>
<type-name>Snowflake</type-name>
<driver>net.snowflake.client.jdbc.SnowflakeDriver</driver>
<connection-url-pattern>jdbc:snowflake:test.snowflakecomputing.com</connection-url-pattern>
<supports-catalogs>true</supports-catalogs>
<supports-schemas>true</supports-schemas>
<supports-procedures>false</supports-procedures>
<fetch-size>10000</fetch-size>
<batch-size>100</batch-size>
<use-ansii-style-outer-join>true</use-ansii-style-outer-join>
</jdbc-type-settings>

The connection URL for the data source " jdbc:snowflake:test.snowflakecomputing.com", should not be used in the "connection-url-pattern". Note that "Connection URL pattern" field defines what the format of the data source connection URL is,  where as the "Connection URL" field defines the data source URL in that format.  To resolve the issues, use the correct values for both "connection-url-pattern" in the data source template and "connection URL" while setting up the data source in the Information Designer. These two values cannot be the same.

Note: This issue can also be seen if the correct third party jar file is not placed under the correct path within Spotfire. Doc: Data source templates

Comments

0 comments

Article is closed for comments.