Connections and Models

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

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

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

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

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

driverName

string

Driver name

propertyName

string

Driver property name

propertyValue

string

Property value

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)

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

name

string

Translator name

javaClass

string

Translator java class

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

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