Use this tab to provideAnalytic Workspace Manager with the the information it needs to connect to Oracle Database.
Description
Up to 30 characters that uniquely identify this connection. You can use any printable characters including spaces and ASCII symbols.
Connection Information
The details of the service you wish to connect to. You can identify a service in either of the following ways:
Specify the connection information using the Easy Connect Naming method, which requires no prior setup. Use the format host_name:port_number:database_SID. For example: myhost:1521:orcl
Providing these three pieces of information enables the database connection to be opened using the thin JDBC driver, which will work from any client computer.
Specify a TNSNAMES entry. For example: orcl_myhost
You can find the available TNSNAMES entries listed in the tnsnames.ora file on the client computer from which you are connecting. Providing a TNSNAMES entry requires that you have an OCI JDBC driver installed on your client and that a connection has already been defined using a tool such as Oracle Net Configuration Assistant.
Contact your DBA for further information.
Database Compatibility Mode
A setting in the initialization file for a database. It enables the DBA to run a newer version of Oracle Database so that it uses only the features of an older version. You do not have access to any of the features implemented in versions more recent than the compatibility mode setting. (Visible only on property sheet with an open analytic workspace)
Database Language
The language in which the database is running. Any messages returned from the database are in this language. (Visible only on property sheet with an open analytic workspace)
Copyright © 2003, 2007, Oracle. All rights reserved.