Connections and Models

This table supplies information on dynamic connections.

Column Name	Type	Description
`fullName`	string	Full connection name
`name`	string	Connectio n name
`jndiName`	string	JNDI name
`template`	string	Translator name (e.g. `postgresql`, `mysql`, etc.)
`properties`	string	Connection properties in the CSV format (e.g. `host=localhost`, `port=5432`, `db=test_tables`, `user-name=user1`, `password=pass1)`
`failed`	boolean	Flag to signal failed/not failed state of the connection
`connectionUrl`	string	Connection URL (e.g. `jdbc:postgresql://localhost:5432/test_tables`)
`driverName`	string	Name of the driver (e.g. `org.postgresql`)
`driverClass`	string	Name of the driver class (e.g. `org.postgresql.Driver`)
`userName`	string	Username
`archive`	string	Archive file used by the resource adapter
`className`	string	Class name
`configProperties`	string	Additional configuration properties
`creationDate`	timestamp	Timestamp and time when the connection was created
`lastModifiedDate`	timestamp	Timestamp when the connection was last modified
`creator`	string	User who created the connection
`modifier`	string	User who last modified the connection
`encryptedProperties`	string	Encrypted properties

This table supplies information on all connection properties.

Column Name	Type	Description
connector	string	Full connector name
property	string	Property name
translator	string	Translator name
type	string	Data type of the property
defaultValue	string	Default value of the property
description	string	Description of the property
required	boolean	Indicates if the property is required
masked	boolean	Indicates if the property is encrypted (masked)
quoted	boolean	Indicates if the property is quoted

System table SYSADMIN.ConnectorProperties is available since v4.6

This table supplies information on the JDBC properties of CData drivers.

Column Name	Type	Description
`drivername`	string	Driver name
`name`	string	Property name
`shortdescription`	string	A brief description of the property
`type`	string	The data type of the connection property
`defaultValue`	string	The default value if one is not explicitly set
`possibleValues`	string	A comma-separated list of possible values. A validation error is thrown if another value is specified
`assignedValue`	string	Assigned property value
`required`	boolean	Indicates if the property is required
`category`	string	The category of the property
`isSessionProperty`	boolean	Indicates if the property is a session property, used to save information about the current connection
`sensitivity`	string	The sensitivity level of the property. This informs whether the property is obfuscated in logging and authentication forms
`propertyName`	string	Property name
`ordinal`	integer	The index of the parameter
`catOrdinal`	integer	The index of the parameter category
`hierarchy`	string	Shows dependent properties associated that need to be set alongside this one
`visible`	boolean	Indicates if the property is visible in the connection UI
`etc`	etc	Various miscellaneous information about the property

System table SYSADMIN.CDataJdbcProperties available since v4.6

This table supplies information on JBoss CLI templates.

Column Name	Type	Description
`id`	biginteger	Template ID
`name`	string	Template name
`createScript`	string	CLI script which creates a data source/resource adapter
`dropScript`	string	CLI script which removes a data source/resource adapter
`creationDate`	timestamp	Template creation date
`lastModifiedDate`	timestamp	Template last modification date
`creator`	string	Name of the user who created the template
`modifier`	string	Name of the user who last modified the template
`hiddenProps`	string	Comma-separated list of properties that will be stored encrypted

This table supplies information on dynamic models.

Column Name	Type	Description
`name`	string	Model name
`translator`	string	Translator name (e.g. `postgresql`, `mysql`, etc.)
`modelProperties`	string	Properties for the model (e.g. `importer.useFullSchemaName=false`, `import.schemaPattern=public`)
`translatorProperties`	string	Properties for the translator (e.g. `UseStreamingResults=true`)
`schema_text`	clob	DDL script for creating the schema
`failed`	boolean	Flag to signal failed/not failed state of the data source
`creationDate`	timestamp	Timestamp when the data source was created
`lastModifiedDate`	timestamp	Timestamp when the data source was last modified
`creator`	string	User who created the data source
`modifier`	string	User who modified the data source
`encryptedModelProperties`	string	Encrypted model properties
`encryptedTranslatorProperties`	string	Encrypted translator properties

This table supplies information on all installed CData drivers' metadata.

System table SYSADMIN.JdbcDriverMetadata available since v4.6

This table supplies information on all connection properties.

Column Name	Type	Description
translator	string	Translator name
property	string	Model property name
type	string	Data type of the property
defaultValue	string	Default value of the property
description	string	Description of the property
display	string	How the translator property will be displayed
required	boolean	Indicates if the property is required
advanced	boolean	Indicates if the property is advanced
masked	boolean	Indicates if the property is encrypted (masked)

System table SYSADMIN.ModelProperties is available since v4.6

This table supplies information about modular connectors available on the server.

Column Name	Type	Description
`name`	string	Name of the modular connector required by the `deployModularConnector` procedure
`translator`	string	Translator name of the modular connector
`version`	integer	Version of the modular connector
`deployed`	boolean	Flag indicating if the modular connector is deployed
`dependency`	string	Base modular connectors. Connectors required to be deployed before deploying this modular connector

translator, version and dependency columns of SYSADMIN.ModularConnectors are available since v4.5

This table is used by the license generator to validate the data sources provided in the allowedDatasources property.

Column Name	Type	Description
`name`	string	Translator name
`javaClass`	string	Translator java class

This table supplies information on all translator properties.

Column Name	Type	Description
`translator`	string	Translator name
`property`	string	Translator property name
type	string	Data type of the translator property
defaultValue	string	Default value of the translator property
description	string	Description of the translator property
display	string	How the translator property will be displayed
required	boolean	Flag indicating if the translator property is required
advanced	boolean	Flag indicating if the translator property is advanced
masked	boolean	Flag indicating if the translator property is encrypted

System table SYSADMIN.TranslatorProperties is available since v4.6

This table holds SMTP settings.

Column Name	Type	Description
`host`	string	SMTP server hostname/address
`port`	integer	SMTP server port
`ssl`	boolean	`TRUE` if the SMTP server requires SSL
`starttls`	boolean	`TRUE` if the SMTP server requires TLS
`username`	string	Username to connect to SMTP server if required
`password`	timestamp	Password to connect to SMTP server if required
`fromAddr`	string	Address to be used as 'from' address