Select the type of database from the drop-down list:
Database Type, Server Host, Server Port, Database Name, Driver Name and Connection URL are always displayed in the Connection Wizard. The remaining fields are shown/hidden based on the selection of Database Type.
For example, if you select "Oracle" as a database type, then all the fields related to Oracle are shown and the remaining fields are hidden.
Note: If you select SQLSERVER as the Database Type and you want to use Windows Authentication (integrated security), leave all fields blank except the Connection URL field. In this field, enter something similar to the following example:
"jdbc:sqlserver//ms-db-host:1433;DatabaseName=dbname;integratedSecurity=true"
If you define Host, Port, Database Name or SQL Server Instance name, the operator creates the URL based on those values instead of using the one you configured in the Connection URL field with integratedSecurity set to true.)
Note: If Other is selected as the Database Type, enter the User Name and Password to be used to connect to the database (if required) in the Database Server Login parameters.
If your database is not listed in the Database Type drop-down list, enter it here.
Specifies the host where database is running.
Specifies the database server port.
Specifies the name of the database.
Specifies the database driver name (the Java class that interfaces with the database).
Specifies a database URL is a Universal Resource Locator (URL) that specifies a particular type of database server (compatible with the local JDBC driver) and a particular host.
This field is updated as information is entered into the Connection Wizard.
The following properties only display if they apply to specified Database Type.
Available when Sybase is selected as the database type. This field specifies the amount of memory used by the driver to cache insensitive result set data. Valid values are:
All data is cached.
All data is cached, up to 2GB.
This is the buffer size; must be positive, and a power of 2. This value is specified in kilobytes.
Available when Sybase is selected as the database type. Select from either True or False.
Available when Sybase is selected as the database type. Specifies the connection protocol for Sybase. The default connection protocol is Tds. The connection string differs based on the server type.
Available when Sybase is selected as the database type. Specifies the Sybase server types. Select one of the following from the drop-down list:
Available when Oracle is selected as the database type. Specifies the driver type for Oracle. Select one of the following from the drop-down list:
The thin driver is a pure Java implementation of the Oracle networking protocol (Net8). Being self-contained, it may be used on any machine with or without Oracle installed, or distributed with application classes in an applet.
The OCI (type 2) driver consists of java wrappers to the low-level Oracle call interface (OCI) libraries used by utilities such as SQL*Plus to access the database server. The OCI driver can potentially improve performance over the thin driver, however, it requires the OCI libraries to be installed on a local machine.
The KPRB driver is used for Java stored procedures and database JSPs.
Available when Oracle is selected as the database type. A support expression that specifies the Oracle service ID.
Available when Oracle is selected as the database type. Translates a local database alias to all the connectivity information needed to connect to the database. This includes IP address, port, database Service ID, or service name, and so on. This information is stored in a file called tnsnames.ora in the Oracle directory.
Available when Oracle is selected as the database type. Oracle supports the following multiple data encryptions for the client:
RC4_40, RC4_56, RC4_128, RC4_256
DES40C, DES56C, 3DES112, 3DES168
SSL, AES256, AES192, AES128
Specify one of these values that will be set as properties as part of the connection. The encryption levels RC4_128 and RC4_256 are for domestic editions only.
Available when Oracle is selected as the database type. Specifies the Oracle Client Checksum value (a number calculated by the database from all the bytes stored in a data or redo block). Oracle supports MD5 checksum. For more information, refer to the Oracle documentation.
Available when SQLServer is selected as the database type. On a given server, you can run multiple SQLServer services, each with their own ports, logins, and databases. Each of these services is called an instance of SQL Server. This field specifies a particular instance name for SQLServer.
Available when Hypersonic is selected as the database type. Select one of the following from the drop-down list:
|
Copyright © 2014 CA.
All rights reserved.
|
|