Oracle
Use the Oracle database connector to connect to your Oracle database
Add connector
Select Connectors in Hub menu and select Add Connector.
Select Oracle Connector.
Enter the name and optionally a description.
Enter the configuration values for different environments.
Select Save.
Configuration values
Configuration | Description |
---|---|
Agent Group | Agent group where the connector should be executed |
Hostname | IP address or host name |
Port | Port number. The standard port is 1521 |
Username | Username of the Global database user |
Password | Password for the Global database user |
Service Name Type Selector | Choose which type of name is given. Service Name: Service name is the TNS alias that you give when you remotely connect to your database and this Service name is recorded in Tnsnames. SID: Oracle Service ID is the unique name that uniquely identifies your instance/database. |
Service Name / SID | Value for service name or the SID |
Connection Timeout | Connection timeout, in seconds, to use when executing a script or a query. If not set, the default value of 90 seconds will be used |
Schema/AppOwner | Database schema name |
Initialization Command | Optional command to execute immediately after successful login |
Cleanup Command | An optional command to execute on the database after the operation has been completed. |
Command Timeout | Command timeout, in seconds, to use when executing a script or a query. If not set, the default value of 90 seconds will be used |
Edit connector
Hover over the connector card and the context menu will appear, select Edit.
You can now change or the configuration values for different environments name, description.
Delete connector
Hover over the connector card and the context menu will appear, select Delete.
Confirm and the connector will be deleted.
Deleting a connector can not be undone.
Last updated