Search

Your Notifications (0)

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

Knowledge Base
ChemDraw and ChemOffice+ Products Signals Notebook E-Notebook and ChemBioOffice Enterprise Spotfire and Signals Spotfire Products Image Artist Spectrus, Percepta, Katalyst, Luminata and more
Downloads
Downloads
Community
Ideas Portal Product Basics
About Support
Legal Resources Support and Maintenance Plans Product Life Cycle Support News
Contact Support

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

Mike Roe
  • Updated
Date Posted:
Product: TIBCO Spotfire®

 

Summary:

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

 

Details:

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



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. 

 

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.

 

Reference:

Doc: Data source templates

 

Related articles

Comments

0 comments

Article is closed for comments.