Error "Validation of the data source template definition failed: invalid XML format." when adding the TDV Kerberos data source template in Spotfire

Error "Validation of the data source template definition failed: invalid XML format." when adding the TDV Kerberos data source template in Spotfire

book

Article ID: KB0070432

calendar_today

Updated On:

Products Versions
Spotfire Server All

Description

While adding the data source template for TIBCO Data Virtualization(TDV) Kerberos present in the Community page https://community.spotfire.com/articles/spotfire/spotfire-jdbc-data-access-connectivity-details inside TIBCO Spotfire Configuration Tool >> Configuration >> Data Source Templates, throws an error: "Validation of the data source template definition failed: invalid XML format."

Issue/Introduction

While adding the TDV Kerberos data source template, Error "Validation of the data source template definition failed: invalid XML format."

Environment

All

Resolution

To resolve the above error, make use of the below TDV Kerberos data source template:

==============================
<jdbc-type-settings>
  <type-name>Composite_Kerberos_constrained</type-name>
  <driver>cs.jdbc.driver.CompositeDriver</driver>
  <connection-url-pattern>jdbc:compositesw:dbapi@&lt;server&gt;:&lt;port9401&gt;?domain=&lt;domain&gt;&amp;dataSource=&lt;data_source&gt;&amp;authenticationMethod=&lt;auth_method&gt;&amp;kerberos.spn=&lt;spn&gt;&amp;kerberos.useTicketCache=true</connection-url-pattern>
  <ping-command>SELECT 1 FROM /services/databases/system/all_domains</ping-command>
  <connection-properties>
  <connection-property>
  <key>spotfire.connection.pool.factory.data.source</key>
  <value>kerberos.data.source</value>
  </connection-property>
  <connection-property>
  <key>spotfire.kerberos.gsscredential.property</key>
  <value>userGSSCredential</value>
  </connection-property>
  </connection-properties>
  <supports-catalogs>true</supports-catalogs>
  <supports-schemas>true</supports-schemas>
  <use-ansii-style-outer-join>true</use-ansii-style-outer-join>
  <metadata-provider>com.spotfire.ws.im.ds.sql.composite.CompositeMetadataProvider</metadata-provider>
  <supports-procedures>true</supports-procedures>
</jdbc-type-settings>

==============================

Note: The connection string is different in the above template as compared to the template present on the wiki page

Additional Information

Community: TIBCO Data Virtualization (TDV) with Kerberos, Spotfire® JDBC Data Access Connectivity Details
Powered by Wolken Software