Connect to Oracle Dialog
The Connect to Oracle dialog helps you to specify the information for connecting to an Oracle database via the connection plug-in. It appears when you do one of the following:
- Select OK in the Create Connection to Oracle dialog.
- Select Oracle and select OK in the New Data Source dialog.
- In the Catalog Manager, right-click a data source and select New JDBC Connection from the shortcut menu, then select Oracle in the Select Connection Type dialog and select OK.
Displays the Oracle JDBC driver name that this connection uses.
Specifies the way using which to connect to the Oracle database: Service Name, SID, or TNS.
Specifies the host name or IP address of the database server.
Specifies the port of the database server.
Specifies the service name/SID/TNS of the database instance that you want Logi Report Designer to connect with by default.
Specifies the user ID used for accessing the database.
Specifies the password used for accessing the database.
Specifies to show the URL used for connecting to the database server.
Displays the URL which is formulated by the information you have provided. You can also type the valid JDBC URL in the text box to establish the connection to the database server. The URL format is regulated by the driver itself. When Service Name is selected as the connection type, the format is
jdbc:oracle:thin:@//<host>:<port>/<service_name>; when SID is selected, the format is
jdbc:oracle:thin:@<host>:<port>:<SID>; for TNS, the format is
Tests whether the specified connection information can connect to the database successfully.
More Options/Less Options
Shows or hides the options for experienced users to configure the connection to meet the special requirements of the database. Go here for details about the options.
Creates the connection to the Oracle database and closes the dialog.
Cancels the connection creation and closes the dialog.
Displays the help document about this feature.
Please sign in to leave a comment.