| Table of Contents |
|---|
Database Credentials
...
We strongly recommend to use runtime credentials because it is more secure than stored credentials (due to the possibility of the stored password being decoded).
See Securing the Database Connection.
...
- Composite Archive (Windows and Linux):
jar:file:/C:/Users/Pete/DaticalDBCompositeRepo-4.26.4467.zip!/jar:file:/home/Users/Pete/DaticalDBCompositeRepo-4.26.4467.zip\!/ - Extracted Archive (Windows and Linux):
file:/C:/Users/Pete/DaticalDBCompositeRepo-4.26.4467/file:/home/Pete/DaticalDBCompositeRepo-4.26.4467/
...
newDbDef
Creates a new dbDef based on the key/value pairs specified as arguments.
- Oracle
- Inline Credentials: OracleDbDef
- Run-Time Supplied Credentials: DelayedCredentialOracleDbDef
- SQL Server
- Inline Credentials: SqlServerDbDef
- Run-Time Supplied Credentials: DelayedCredentialSqlServerDbDef
- Postgres Enterprise DB
- Inline Credentials: PostgresqlDbDef
- Run-Time Supplied Credentials: DelayedCredentialPostgresDbDef
- DB2
- Inline Credentials: Db2DbDef
- Run-Time Supplied Credentials: DelayedCredentialDb2DbDef
- (deprecated) MySQL Inline Credentials: MysqlDbDef
USAGE
newDbDef DbDefClass <value> name <value> hostname <value> port <value> username <value> password <value> database <value> ... <key> <value>
AVAILABLE KEYS
DbDefClass - Database Type. (OracleDbDef|Db2DbDef|MysqlDbDef|SqlServerDbDef|PostgresqlDbDef|DelayedCredentialOracleDbDef|DelayedCredentialSqlServerDbDef|DelayedCredentialPostgresDbDef|DelayedCredentialDb2DbDef)
name - The name for the dbDef. Used in the CLI and GUI as an alias for this connection.
hostname - The hostname/ip of the target database server.
port - The port number for JDBC connections to the target database server.
username - The database user name to use for the connection.
password - The password for the database user.
database - (MySQL|DB2|PostGRE) The name of the database to manage. Not applicable to Oracle databases.
databaseName - (SQLServer) The name of the database to manage.
instanceName - (SQLServer) The name of the instance to manage.
applicationName - (SQLServer) The name of the database application to manage.
sid - (Oracle) The name of the Oracle SID to manage.
serviceName - (Oracle) The name of the Oracle Service to manage.
- tnsName - (Oracle) The TNS name for the Oracle host and service to manage. Requires the
tnsnames.oraconfiguration file on the client. defaultSchemaName - The name of the schema to manage.
- defaultCatalogName - The name of the catalog to manage.
contexts - A comma separated list of contexts.
- labels - A comma separated list of labels.
- dbDefType - One of "standard" (default, for a managed database) or "dmcdb" for the Deployment Monitoring Console Database.
- storageOptionCollectedAtSnapshot - (true/false) Collect storage options for database objects (table, index, etc.)
...
USAGE: set enableSqlParser true | false
true- use SQL Parser to parse DIRECT and DATA_DML scripts into the object model for subsequent validation with rules and forecast.false- disable SQL Parser.externalStoredLogic- Set whether stored logic definitions (stored procedures, etc.) are stored in external files or within the project changelog.
...
runtimeCredentials- controls whether database credentials are stored or prompted at run time. Default: false. If set to true, all stored credentials are removed and you are prompted for database credentials during forecasting and deployment. If set to false, database credentials are encoded and stored in the project. We strongly recommend to use runtime credentials because it is more secure than stored credentials (due to the possibility of the stored password being decoded).
USAGE set runtimeCredentials true|false
...
requireoptions- true or false, whether contexts and labels are required for Forecast and DeployruntimeCredentials -true or false, whether user is prompted at run time for database user credentials. Otherwise stored encoded credentials are used. We strongly recommend to use runtime credentials because it is more secure than stored credentials (due to the possibility of a stored password being decoded).scriptExecutionTimeout -number of seconds, 0 if unlimited.
...