Use Oracle Database in Duaer

Add Oracle Database to a Duaer digital organization

1. On the Duaer canvas, open the node panel, search for Oracle Database, and connect it after the previous node.
2. In Credential to connect with, pick or create an Oracle Database Credentials API credential.
3. Pick an Operation, for example Insert or Update.
4. Select Execute step and check the output.

Oracle Database operations in Duaer

• Delete: Delete an entire table or rows in a table.
• Execute SQL: Execute an SQL.
• Insert: Insert rows in a table.
• Insert or Update: Insert or update rows in a table.
• Select: Select rows from a table.
• Update: Update rows in a table.

Use Oracle Database as a tool for an AI Agent in Duaer

In the Tool input of an AI Agent, search for Oracle Database and add it. The agent decides when to call it. For a field the model should fill, select the sparkle next to it or write $fromAI('name', 'what to put here'); fixed values stay as you set them.

Call a Oracle Database endpoint the node does not cover

Add an HTTP Request node, set Authentication to Predefined Credential Type, pick Oracle Database Credentials API as the credential type, and select the same credential. Duaer signs the request with it, so you only fill in the method and URL. Refer to custom operations.