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

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

book

Article ID: KB0076399

calendar_today

Updated On:

Products Versions
Spotfire Server 7.5 and higher

Description

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. 

Issue/Introduction

This article will help you understand why "Save" option grayed out while saving a data source in Information Designer.

Resolution

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.

Additional Information

Doc: Data source templates