Page Comparison

Provides a direct connection with the properties configured. 

Configure the DbDef with the following properties:

• Connection Type=BASIC
• Hostname
• Port
• SSID or Service Name

Provides a connection using a service definition in the tnsnames.ora file. The service definition provides all user and database connection properties.

Configure the DbDef as follows

• TNS Alias - Provide the name of the service definition that you create in the tnsnames.ora file. 

You also provide the following on the Datical DB host:

• Environment variables
• Configuration files

SSL through Oracle Wallet

(uses TNSNAMES)

Provides a secure SSL connection using a configuration of your Oracle Wallet feature. 

Configure the DbDef as follows

• TNS Alias - Provide the name of the service definition that you create in the tnsnames.ora file. 

You also provide the following on the Datical DB host:

• Configuration files
• Environment variables

Notes

• You cannot use the Datical Accelerator for Oracle in projects or DbDefs where you are using Oracle Wallet for secure connections.  (Note that the optional accelerator/compression driver was only available with versions 7.15 or lower.  It has been deprecated for versions 7.16 and higher.) 

Provides a connection through an LDAP service. You set up connection information on the LDAP server, then configure Datical DB to use it. 

Configure the DbDef as follows

• TNS Alias - Provide the name of the service definition that you define on the LDAP server. 

You also provide the following on the Datical DB host:

• Configuration files
• Environment variables

Notes

• You cannot use the Datical Accelerator for Oracle in projects or DbDefs where you are using an LDAP connection.  (Note that the optional accelerator/compression driver was only available with versions 7.15 or lower.  It has been deprecated for versions 7.16 and higher.)