rdbms adapter (generic)

Description - A generic for connecting to Progress RDBMS (Openedge Database).


Parameter Groups

 ParameterTypeDescription
*Host:stringName or IP address of the Progress server.
*Port:integerThe port number of the Progress server.
* - denotes required
 ParameterTypeDescription
*User ID:stringUser ID that can access the database
Password:stringPassword associated with the specified user ID.
*Database:stringThe schema that will be used as the default schema.
* - denotes required
 ParameterTypeDescription
Node Maximum:integerMaximum number of nodes to retrieve.
* - denotes required
 ParameterTypeDescription
URL:stringAllows you to specify optional settings for the JDBC URL.
* - denotes required
Description - A generic for connecting to PostgreSQL.


Parameter Groups

 ParameterTypeDescription
*Host:stringName or IP address of the Progress server.
*Port:integerThe port number of the Progress server.
* - denotes required
 ParameterTypeDescription
*User ID:stringUser ID that can access the database
*Password:stringPassword associated with the specified user ID.
*Database:stringThe schema that will be used as the default schema.
* - denotes required
 ParameterTypeDescription
Node Maximum:integerMaximum number of nodes to retrieve.
* - denotes required
 ParameterTypeDescription
URL:stringAllows you to specify optional settings for the JDBC URL.
* - denotes required
Description - A generic for connecting to Oracle RDBMS.


Parameter Groups

 ParameterTypeDescription
*Host:stringName or IP address of the Oracle server.
*Port:integerThe port number of the Oracle server.
*SID:stringA unique name for an Oracle database instance.
* - denotes required
 ParameterTypeDescription
*User ID:stringThe Oracle username to authenticate the connection.
*Password:stringThe Oracle password to authenticate the connection.
* - denotes required
 ParameterTypeDescription
Connection Name:stringThe connection name you want to use for the Oracle RAC configuration.
TCP Timeout:stringThe number of milliseconds before the connection times out.
Connection Descriptor or LDAP URL:stringThe connection description URL, which is found in the tnsnames.ora file of the Oracle RAC configuration.
Oracle Name Server (ONS):stringThe node setting for each Oracle system in the cluster, which includes host and port number. ie orac1:6200,orac2:6200
* - denotes required
 ParameterTypeDescription
URL:stringAllows you to specify optional settings for the JDBC URL.
* - denotes required
 ParameterTypeDescription
Node Maximum:integerMaximum number of nodes to retrieve.
* - denotes required
Description - A generic for connecting to Microsoft SQL Server.


Parameter Groups

 ParameterTypeDescription
*Host:stringName or IP address of the Microsoft SQL server.
*Port:stringThe port number of the Microsoft SQL server.
* - denotes required
 ParameterTypeDescription
*User ID:stringThe Microsoft SQL username to authenticate the connection.
Password:stringThe Microsoft SQL password to authenticate the connection.
*Database:stringThe schema that will be used as the default schema.
* - denotes required
 ParameterTypeDescription
URL:string
* - denotes required
 ParameterTypeDescription
Node Maximum:integerMaximum number of nodes to retrieve.
* - denotes required
Description - A generic for connecting to a IBM DB2 Database Server.


Parameter Groups

 ParameterTypeDescription
*Host:stringName or IP address of the DB2 server.
*Port:stringThe port number of the DB2 server.
* - denotes required
 ParameterTypeDescription
*User ID:stringThe DB2 username to authenticate the connection.
Password:stringThe DB2 password to authenticate the connection.
*Database:stringThe schema that will be used as the default schema.
* - denotes required
 ParameterTypeDescription
*Driver Type:stringThe type of JDBC driver used for database connectivity.

Select from one of the following options:
  • jcc driver (type 4) - This driver is pure Java and implements the network protocol for a specific data source
URL:string
* - denotes required
 ParameterTypeDescription
Node Maximum:integerMaximum number of nodes to retrieve.
* - denotes required
Description - A generic for connecting to HSQLDB (Hyper SQL Database).


Parameter Groups

 ParameterTypeDescription
*Type:stringThe method of running the HSQL database.

Select from one of the following options:
  • Standalone
  • Server
  • Web Server
  • In-Memory
* - denotes required
 ParameterTypeDescription
*User ID:stringUser ID that can access the database
Password:stringPassword associated with the specified user ID.
* - denotes required
 ParameterTypeDescription
Node Maximum:integerMaximum number of nodes to retrieve.
* - denotes required
 ParameterTypeDescription
Database File Path:stringThe full path to the database file.
* - denotes required
 ParameterTypeDescription
Host:stringThe name of the machine on which the database is running.
Port:stringThe port number on which the database is listening.
Server Name:stringName of the database server.
* - denotes required
 ParameterTypeDescription
URL:stringAllows you to specify optional settings for the JDBC URL.
* - denotes required
Description - A generic for connecting to a JNDI Datasource.


Parameter Groups

 ParameterTypeDescription
*Initial Context Factory:stringJNDI context.INITIAL_CONTEXT_FACTORY that is provided by the JNDI service provider.
*Provider URL:stringThe URL to use to contact the JNDI provider. This value corresponds to the standard JNDI property, java.naming.provider.url
*JNDI Name:stringJNDI name of a queue to which events are emitted.
*DBMS:stringThe target database-management system

Select from one of the following options:
  • None
  • Oracle
  • Sql Server
  • Sybase
  • DB2_type2
  • DB2_type3
  • DB2_type4
  • Informix
  • EDA Server
  • Progress
  • MySQL
  • PostgreSQL
  • Cache
  • Domino
  • DominoODBC
  • HSQL
  • Teradata
  • ODBC
  • Other
* - denotes required
 ParameterTypeDescription
Node Maximum:integerMaximum number of nodes to retrieve.
* - denotes required
Description - A generic for connecting to MySQL Server.

 

Parameter Groups

  Parameter Type Description
* Host: string Name or IP address of the MySQL server.
* Port: string The port number of the MySQL server.
* - denotes required
  Parameter Type Description
* User ID: string The MySQL username to authenticate the connection.
  Password: string The MySQL password to authenticate the connection.
* Database: string The schema that will be used as the default schema.
* - denotes required
  Parameter Type Description
  URL: string  
* - denotes required
  Parameter Type Description
  Node Maximum: integer Maximum number of nodes to retrieve.
* - denotes required