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.
You can also use Oracle files as a source. For more information, see Using a file as a source.
To add an Oracle XStream source endpoint to Qlik Replicate
- In Tasks view, click Manage Endpoint Connections to open the Manage Endpoints Connections dialog box. Then click the New Endpoint Connection button.
- In the Name field, type a name for your database. This can be any name that will help to identify the database being used.
- In the Description field, type a description that helps to identify the Oracle database. This is optional.
-
Select Source as the database role.
-
Select Oracle XStream as the database Type.
Information noteWhen this endpoint is used as a duplicated source in a Log Stream Staging setup, select the Read changes from log stream staging folder check box and then select the relevant Log Stream Staging task from the drop-down list.
For information on setting up and managing Log Stream Staging tasks, see Using the Log Stream.
-
Type the Connection String for the Oracle XStream database you want to work with. 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 XStream database that you are using. For example,johnboy_W7
or255.255.255.0
.port
: (optional) This is the TNS Listener Port number for the computer with the Oracle XStream 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 XStream 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)))"
-
Enter the Username and password of an authorized user of the Oracle XStream database. If you do not know this information, contact your DBA.
Information noteThis information is case sensitive.
Information noteMake sure that the specified user has the correct access privileges. For information on the required privileges, see Permissions.
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.
Capturing changes after a RAC switchover
If you need to run a switchover procedure on your RAC environment with multiple standby nodes, do the following steps to ensure the continuity of CDC.
-
Run a task using the primary RAC node as a source.
-
Stop the task.
-
Perform the switchover procedure. This changes your primary RAC node to a standby role and makes your standby node your primary RAC node.
-
Change the credentials to those of your new primary RAC node.
-
Resume the task. All the events that were triggered when the task was stopped will be replicated automatically and the changes will be captured accordingly.