Connection.Oracle Details

Element Details: Connection.Oracle

Available in: Logi Info

Source code name: Connection.Oracle

The Connection.Oracle element sets the parameters required to connect to a Oracle database.

In order to use this element you must have installed the Oracle client software. The client is typically included on your Oracle CD or can be downloaded from the Oracle web site.

If you are having trouble running web reports using native oracle connections, check that the proper account has access to the Oracle client directory.

Element Group:Relational Databases

ATTRIBUTES

Click attribute Name to drill down for more information.

Name

Possible Values

Description

CommandTimeOut

UserDefined

The CommandTimeOut attribute specifies the amount of time, in seconds, before the request to connect to the data source is presumed to have failed. For most data sources, the default value is 60 seconds. For MySql, the default is 30 seconds.

UserDefined

(Required) The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition.

OracleConnectionString

UserDefined

A full connection string to the Oracle database. If a value is defined, it will override all other settings for the connection element and use this string to connect to the database. Oracle Parameter elements are still processed and added to the string.

OracleDatabase

UserDefined

(Required) For Oracle connections use the service name. Since many Oracle installations share the same SID, if you don't know the service name then you can try the SID.

OraclePassword

UserDefined

The password for the Oracle database.

OraclePort

UserDefined

The port address of the Oracle database. Default to port 1521.

OracleServer

UserDefined

(Required) The host name of the Oracle database server.

OracleUser

UserDefined

(Required) The user name for the Oracle database.