1. iWay Integration Tools
  2. Chapter 1. iWay Components
  3. 1.2. Concept: iWay Generics
  4. Generics - RDBMS Adapter
  5. Generic - RDBMS Adapter (Oracle RDBMS)

Generic - RDBMS Adapter (Oracle RDBMS)

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