SQL Connection Properties

The string value that uniquely identifies the metadata.

The name of the metadata object.

Specifies the JDBC connection URL, such as jdbc:sqlserver://localhost;DatabaseName=MyDatabase

The URL can be tokenized.

SQLDatabaseType.Unspecified

The JDBC-compliant relational database type.

This property is optional, but it allows database-specific functionality to be leveraged. For example, the "Microsoft" SQL Server database type allows for the possibility of using Windows authentication via the AuthenticationMode property.

See also: AuthenticationMode

The name of the JDBC driver class, such as com.microsoft.sqlserver.jdbc.SQLServerDriver.

Specifies the fully qualified JNDI data source, such as java:comp/env/jdbc/MyDataSource

The DataSource can be tokenized. A Username and Password may also be specified for a JNDI data source.

Note: Some application servers use aliases that eliminate the need for the 'java:comp/env/' prefix to the JNDI Data Source.

SQLCredentialsPolicy.SpecifyUsernameAndPassword

Indicates whether both the username and password, only the username, or neither the username or password are required for the connection to be a valid JDBC connection.

Depending on the authentication protocol used for the SQL connection, the setting is used to inform the Dodeca service as to whether or not to treat the lack of credentials as an exception.

SQLConnectionMethod.ServerBased

The caption used by the SQL Login Dialog when prompting the user to provide credentials for this connection.

SQLAuthenticationMode.SQLAuthentication

The authentication mode to utilize when executing queries against the relational database.

SQLAuthentication - Connects to the relational database with the username and password assigned to the connection object and executes SQL queries as the provided user.

WindowsAuthentication - Connects to the relational database with the username and password assigned to the connection object and executes SQL queries as the current Windows user via impersonation.

When WindowsAuthentication is utilized, the user assigned to the connection object must have impersonate permission for end-user accounts.

See also: Database

The JDBC password.

The password can be tokenized.

false

When an authentication service is associated with the Dodeca application, the UseAuthenticatedUsernameAndPassword property controls whether the authenticated username and password are used as the SQL connection username and password.

The JDBC user name.

The user name can be tokenized.