Skip to content

Oracle connection configuration


When you connect to Oracle directly, select Local DB as the location, select Oracle as the data type, and configure the detailed settings.



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
5 Oracle Port
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.

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.
Back to top