create-datadirect-datasources-update-script

Creates a script file for updating Information Services data sources that use TIBCO-branded Progress DataDirect JDBC drivers.

create-datadirect-datasources-update-script 
[-b value | --bootstrap-config=value] 
[-t value | --tool-password=value] 
[--source-type=value] 
[--target-type=value] 
[--validate=<true|false>] 
[-n | --no-prompt]

Overview

Use this command to generate a script file that you can use to change the driver and data source template in all Information Services data sources that use a TIBCO-branded Progress DataDirect JDBC driver. Scans all data sources and identifies sources that are linked to a specified data source template.

When you run the output script file, it updates all the data sources to change the driver class in the connection URL, and links them to the new target data source template.

Before you run the command, you must install the vendor JDBC driver to switch to, and add a corresponding data source template. Only the JDBC drivers from the official database vendors are supported (for example, the official JDBC driver from Oracle).

Options


Option	Optional or Required	Default Value	Description
`-b value --bootstrap-config=value`	Optional	none	The path to the bootstrap configuration file. See Bootstrap.xml file for more information about this file.
`-t value --tool-password=value`	Optional	none	The configuration tool password used to decrypt the database password in the file bootstrap.xml. If the tool password is omitted, the command prompts the user for it in the console. See Bootstrap.xml file.
`--source-type=value`	Optional	none	The data source template type name for the TIBCO-branded DataDirect driver to update data sources for. Required if you provided a target-type. If you provide no source-type and no target-type, the generated script file updates all data sources that use TIBCO-branded DataDirect drivers, provided that you have a data source template for the official vendor drivers.
`--target-type=value`	Optional	none	The data source template type name to update your data sources to. The data source template must be for the JDBC driver from the official database vendor.
`--validate=<true\|false>`	Optional	true	Specifies whether to validate the data source with the new settings before saving it.
`-n --no-prompt`	Optional	none	Specifies whether to prompt for confirmation.