Product: TIBCO Spotfire®
While adding the TDV Kerberos data source template, Error "Validation of the data source template definition failed: invalid XML format."
While adding the data source template for TIBCO Data Virtualization(TDV) Kerberos present in the TIBCO Wiki Page(https://community.tibco.com/wiki/tibco-spotfire-jdbc-data-access-connectivity-details#toc-36) inside TIBCO Spotfire Configuration Tool >> Configuration >> Data Source Templates, throws an error: "Validation of the data source template definition failed: invalid XML format."
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@<server>:<port9401>?domain=<domain>&dataSource=<data_source>&authenticationMethod=<auth_method>&kerberos.spn=<spn>&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
https://community.tibco.com/wiki/tibco-spotfire-jdbc-data-access-connectivity-details#toc-36