Oracle CDC Account
Overview
You can use this account type to establish a connection between Oracle CDC Snap and Oracle CDC services.
Prerequisites
- Valid permission to use the Oracle LogMiner.
Account settings
- Expression icon (
): JavaScript
syntax to access SnapLogic Expressions to set field values dynamically (if enabled). If
disabled, you can provide a static value. Learn more. - SnapGPT (
): Generates SnapLogic Expressions
based on natural language using SnapGPT. Learn
more. - Suggestion icon (
): Populates a
list of values dynamically based on your Account configuration. - Upload
: Uploads files. Learn more.
| Field / field set | Type | Description |
|---|---|---|
| Label | String |
Required. Specify a unique label for the account. Default value: N/A Example: Oracle CDC HR Account |
| Hostname | String/Expression | Required. Specify the server address to which the application must connect. Default value: N/A Example:
|
| Port | Integer/Expression | Required. Specify the port number of the database server to which the application must connect. Default value: 1521 Example: 1521 |
| Username | String/Expression | Required. Specify the user of the database. Default value: N/A Example: HR |
| Password | String/Expression | Required. Specify the password used to connect to the data source. It is used as the default password when retrieving connections. The password must be valid to set up the data source. Default value: N/A Example: Password123DB |
| Service name | String/Expression | Required. Specify the service name to which the application must connect. Default value: N/A Example: ORCL |
| Container name | String/Expression | Specify the container name to which the application must connect when it uses a
pluggable database. Default value: N/A Example: ORCLPDB |
Troubleshooting
TNS:listener does not currently know of the service requested in the connect descriptor
Oracle service is down.
Ensure the Oracle service is up and running.