Oracle connection configuration
Overview
When you connect to Oracle directly, select Local DB as the location, select Oracle as the data type, and configure the detailed settings.
Configuration
Basic
Connect to Oracle using basic information.
| No | Item | Description |
|---|---|---|
| 1 | User Name | Username for the Oracle database account. |
| 2 | Password | Password for the Oracle database account. |
| 3 | Connetion Type | Select Basic |
| 4 | Oracle Host | Enter the Oracle host name. |
| 5 | Oracle Port | Enter the Oracle port number. |
| 6 | SID | If you are connecting using SID, select the SID and then enter the SID value in the text box. |
| 7 | Service Name | If you are connecting using Service Name, select Service Name and then enter the value of Service Name in the text box. |
| 8 | Default Schema | If Default Schema is specified, the tables and views of the specified schema will be listed during mapping. If blank, all accessible tables and views will be listed. |
| 9 | Login script | Set the SQL script to execute whenever a connection is established. Separate multiple statements with semicolons ( ;).Example: ALTER SESSION SET NLS_DATE_FORMAT='YYYY/MM/DD HH24:MI:SS';ALTER SESSION DISABLE PARALLEL DML; |
| 10 | Enable Transactions | Specify whether to enable transaction control. When ON, transactions are enabled for each connection, and operations are executed within the same transaction. When OFF, each operation is committed automatically (autocommit). |
ODP Connection String
SDI uses ODP.NET to connect to Oracle.
You can connect to Oracle by using ODP Connection String directly.
| No | Item | Description |
|---|---|---|
| 1 | Connetion Type | Select ODP Connection String |
| 2 | ODP Connection String | Enter the details of the ODP Connection String. * Do not enter user and password information in the Connection String. Reference: Connecting to Oracle Database |
Cloud Wallet
Connect to Oracle using Cloud Wallet.
| No | Item | Description |
|---|---|---|
| 1 | Connetion Type | Select Cloud Wallet |
| 2 | Wallet File Directory | Specify the save location of the wallet file. If the Wallet File is a Zip file, decompress it and specify the decompression destination. |
| 3 | Service | Specify the TNS Name in the tnsnames.ora file or describe the details of the TNS Name. |