Asset | Asset Type ID | Dependencies, Substitution Values, and Other Considerations | |
Continuous query projects | XML | Dependencies: None. Substitution values: For each database source defined in the project, you can substitute the following properties: | |
Property | Description | ||
JdbcConnectionUrl | The URL to be used to connect to the database. | ||
Username | The user name to be used to connect to the database. | ||
Password | The password for the user specified in Username. | ||
A database source in the composite file has the same URL and user name values that it did at design time. These values become the default values for the JdbcConnectionUrl and Username properties at deployment time. If you leave the JdbcConnectionUrl and Username property fields empty at deployment time, the default values (those that were assigned to the database source at design-time) are assigned to the database source when it is deployed. The password for a database source, however, is never included in the composite file. Therefore, the Password property does not have an associated default value that can be used for deployment. Because it has no default value, you must explicitly assign a value to the Password property for each database source in the composite file. Note: If multiple database sources use the same Password value, select all of them in the Configurable Components panel, specify the password value and then click Save Substitutions. Doing this will assign the specified password to all of the selected data sources in one step. |