Shop

Your Notifications (0)

There are currently no notifications. You're all set!

Demos Trials
Knowledge Base
ChemDraw and ChemOffice+ Products Signals Notebook E-Notebook and ChemBioOffice Enterprise Spotfire and Signals Spotfire Products Columbus Signals Image Artist
Downloads
Downloads
Community
Support Forums Ideas Portal Product Basics
About Support
Legal Resources Support and Maintenance Plans Product Life Cycle Support News
Contact Support

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

Rich Talbot
  • Updated
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

Related articles