Connections and Models

This table supplies information on dynamic connections.

Column Name	Type	Description
`fullName`	string	Full connection name
`name`	string	Connection 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

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

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.

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)

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

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

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