# Setting general connection properties

This section describes how to configure general connection properties. For an explanation of how to configure advanced connection properties, see Setting advanced connection properties.

Information note

The total number of columns per table supported in [Batch optimized apply](https://help.qlik.com/en-US/replicate/November2025/Content/Global_Common/Content/SharedEMReplicate/Customize%20Tasks/tasks_applychangtunestab.htm#Batch_apply) mode can be expressed using the following formula:

2 \* columns\_in\_original\_table + columns\_in\_primary\_key <= 999

So, for example, if the original tables has 25 columns and its Primary Key consists of 5 columns, then the total number of columns would be 55. If a table exceeds the supported number of columns, Replicate will apply all of the changes in one-by-one mode.

To add an Oracle target endpoint to Qlik Replicate:

1. In the Qlik Replicate console, click Manage Endpoint Connections to open the Manage Endpoint Connections dialog box. For more information on adding an endpoint to Qlik Replicate, see [Defining and managing endpoints](https://help.qlik.com/en-US/replicate/November2025/Content/Global_Common/Content/SharedEMReplicate/Design%20Tasks/Work_with_Endpoints.htm).

2. In the Name field, type a name for your database. This can be any name that will help to identify the database being used.

3. In the Description field, type a description that helps to identify the Oracle database. This is optional.

4. Select Target as the database role.

5. Select Oracle as the database Type.

6. Type the Oracle Connection String for the Oracle database you want to work with.

   Information note

   * When replicating to an Oracle Autonomous Data Warehouse, you first need to perform the procedure described in [Connecting to an Oracle autonomous data warehouse](https://help.qlik.com/en-US/replicate/November2025/Content/Replicate/Main/Oracle/autonomous_target.htm).
   * This information is case sensitive.

   You can type the connect string in any Oracle format, for example:

   `//host:port/service name`

   Where:

   * `host`: This is the name or IP address for the computer with the Oracle database that you are using. For example, `johnboy_W7` or `255.255.255.0`.
   * `port`: (optional) This is the TNS Listener Port number for the computer with the Oracle database that you are using. If you do not enter a port number the default Oracle TNS Listener port is used.
   * `service name`: (optional) This is the service name for the computer with the Oracle database you are using. If you do not enter a service name the default service name is used.

   You can also enter an Oracle Net keyword-value pair. For example:

   `"(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp) (HOST=dlsun242) (PORT=5521))`

   `(CONNECT_DATA=(SERVICE_NAME=bjava21)))"`

7. Type the Oracle authentication information (User Name, Password) for the authorized user for this Oracle database. If you do not know this information, see your Oracle database Administrator (DBA).

   To ensure that the password provided to Replicate is never used by any other principal, Replicate can be configured to automatically replace the user-entered password with a strong random password. For more information, see [Configuring Replicate to Automatically Replace the User-Entered Password](https://help.qlik.com/en-US/replicate/November2025/Content/Replicate/Main/Endpoints/auto_password_replace.htm).

   Information note

   Make sure that the Oracle user entered in the Oracle Authentication section has the correct access privileges. For information on how to provide the required privileges, see [Permissions](https://help.qlik.com/en-US/replicate/November2025/Content/Replicate/Main/Oracle/security_req_oracle_target.htm).

   Information note

   This information is case sensitive.

   Information note

   To determine if you are connected to the database you want to use or if the connection information you entered is correct, click Test Connection.

   If the connection is successful a message in green is displayed. If the connection fails, an error message is displayed at the bottom of the dialog box.

   To view the log entry if the connection fails, click View Log. The server log is displayed with the information for the connection failure. Note that this button is not available unless the test connection fails.