Oracle
Set up an Oracle connection in the workspace for the database actions to use.
Oracle
Connects an Oracle database to the workspace. The Oracle database actions in your robots use this connection.
Fields
Connection string
Enter the Oracle database's connection string. Either shape works:
192.168.0.1:1521/ORCL
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.1)(PORT=1521))(CONNECT_DATA=(SID=ORCL)))
User
The username to authenticate against the Oracle database with.
Password
That user's password.
Library directory
Optional. The path to the Oracle Instant Client installation on the machine the robot will run on.
Example:
C:\oracle\instantclient_21_12
This field is only needed when the system uses Oracle's thick mode. In the default (thin) mode, the connection works without the Oracle Instant Client installed.
Ask your database administrator whether your environment needs thick mode. If it does, download the Instant Client from oracle.com/database/technologies/instant-client.
Using it in the Designer
For a robot to use this connection, add the Oracle - Connection action to the flow. In the action's settings, pick the connection saved in the workspace. Later Oracle actions (query, insert, update and the rest) use it automatically.