validate-data-source
Facilitates testing and troubleshooting of data source templates for Information Services data sources.
validate-data-source
[-c value | --configuration=value]
[-b value | --bootstrap-config=value]
<-n value | --name=value>
<template-definition-file>
[--get-metadata]
<-u value | --user=value>
<-p value | --password=value>
[--catalog-name=value]
<--connection-url=value>
[--temp-table-write-allowed]
[--output-file=value]
[--schema-name=value]
[--max-connections=value]
[--min-connections=value]
{--session-open-commandsvalue}
{--session-close-commandsvalue}
{--initialization-commandsvalue}
Overview
Use this command to run a connection test towards a JDBC-compliant
data source that you want to access data from with Information Services, using
the configurations from a data source template
.xml file. The purpose of the test is to help you
to assess the compatibility of the data source template with the data source,
the installed JDBC driver, and Spotfire Server, before you add the data source
template to the Spotfire configuration.
Note: It is only supported to validate data sources and data source
templates with username and password authentication.
Options
Option | Optional or Required | Default Value | Description |
---|---|---|---|
|
Optional | configuration.xml | The path to the server configuration file. |
|
Optional | none | The path to the bootstrap configuration file. See Bootstrap.xml file for more information about this file. |
|
Mandatory | none | Specifies the name for the data source to test. The name can be any string value. |
|
Mandatory | none | Specifies the path to the data source template .xml file. |
|
Optional | False | Specifies whether to fetch metadata (for catalog/schema/tables) from the data source. |
|
Mandatory | none | Specifies the username for the data source. |
|
Mandatory | none | Specifies the password for the data source. |
|
Optional | none | Specifies the catalog name in the data source. |
|
Mandatory | none | Specifies the connection URL for the data source connection. |
|
Optional | False | Specifies whether temporary table creation is allowed for the data source. |
|
Optional | none | Specifies the path where to log the console output in a file. |
|
Optional | none | Specifies the schema name in the data source. |
|
Optional | none | Specifies the maximum number of connections allowed for the data source. |
|
Optional | none | Specifies the minimum number of connections allowed for the data source. |
|
Optional | none | Specifies a list of session open commands. This argument is optional and may be specified multiple times with different values. |
|
Optional | none | Specifies a list of session close commands. This argument is optional and may be specified multiple times with different values. |
|
Optional | none | Specifies a list of initialization commands. This argument is optional and may be specified multiple times with different values. |
Parent topic: Command-line reference