Connecting to Oracle
To connect to an Oracle server, you need to specify the database server host name or IP address, the port the Oracle server is running on, the service name or SID, the user name and password to log in with.
Your Oracle server must be available through the Internet in order for Skyvia to connect to it. Oracle Cloud is also supported.
If you are connecting to Oracle server on your local computer, allow such connections in your firewall. If you are connecting to a computer in your local network, you should use port forwarding.
Skyvia will access your server from the IP 22.214.171.124.
You need to specify the following parameters for Oracle connection:
- Name — connection name that will be used to identify the connection in the objects list and when selecting a connection for a package.
- Server — name or IP address of the Oracle server host to connect to.
- Port — Oracle server connection port; default value is 1521.
- Connection Syntax — this parameter determines whether to use Service Name or SID to connect.
- Service Name — alias to an Oracle database instance (or many instances) to use.
- SID — unique name for an Oracle database instance.
- User — user name to log in with.
- Password — password to log in with.
- Connect as — this parameter specifies how you want to connect to the Oracle server. This parameter is set to ‘Normal’ by default. Alternatively, you can select administrative privileges, such as SYSDBA, SYSOPER, SYSASM, SYSBACKUP, SYSDG, SYSKM.
If you need to pass UTF8 characters to an Oracle database, click Advanced Settings and select the Unicode check box.
In Advanced Settings, you can also select the Unicode check box to use Unicode encoding for the connection and specify the Command Timeout interval. The latter specifies the wait time before terminating an attempt to execute a command and generating an error. Note that it is the time to wait for any server reply since the command was sent to a server, and it doesn’t include the time necessary to fetch data if the command selects some data.
Additionally, Advanced Settings include the Connection Timeout parameter. This parameter determines the time (in seconds) to wait while trying to establish a connection before terminating the attempt and reporting an error. Generally, you don’t need to modify it, but in some specific cases, when a connection to the database server is not good, you may try increasing their values.