Duaer

Integrations

Use Microsoft SQL in Duaer

In Duaer, the Microsoft SQL node works with Microsoft SQL from a workflow. It offers 4 operations: Execute Query, Insert, Update, and Delete.

Add Microsoft SQL to a Duaer workflow

  1. On the Duaer canvas, open the node panel, search for Microsoft SQL, and connect it after the previous node.
  2. In Credential to connect with, pick or create a Microsoft SQL credential. Refer to Microsoft SQL credentials.
  3. Pick an Operation, for example Update.
  4. Fill the fields that operation shows, such as Table, Update Key, and Columns.
  5. If needed, select Add Option for the optional settings listed below.
  6. Select Execute step and check the output.

Microsoft SQL operations in Duaer

  • Execute Query: Execute an SQL query.
  • Insert: Insert rows in database.
  • Update: Update rows in database.
  • Delete: Delete rows in database.

Microsoft SQL options in Duaer

Under Add Option, Microsoft SQL offers Query Parameters.

Use Microsoft SQL as a tool for an AI Agent in Duaer

In the Tool input of an AI Agent, search for Microsoft SQL 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 Microsoft SQL endpoint the node does not cover

Add an HTTP Request node, set Authentication to Predefined Credential Type, pick Microsoft SQL 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.

Questions

What can the Microsoft SQL node do in Duaer?

In Duaer, Microsoft SQL offers Execute Query, Insert, Update, and Delete.

Which credential does Microsoft SQL use in Duaer?

Duaer's Microsoft SQL uses a Microsoft SQL credential. The secret stays in the credential, not in node parameters.

In this section