Executing Database Queries in Workflows

Setting Up Database Queries
Testing and Validation
Best Practices


Executing database queries within Canonic workflows allows for dynamic interaction with your database. Whether you're fetching, updating, or inserting data, you can seamlessly integrate these actions within your workflows.

Setting Up Database Queries

To execute database queries within a Canonic workflow:

1. Add a DB Query Node

  • Placement: Determine where in your workflow you need to query your database.
  • Add Node: Add a DB Query node at the chosen point.

2. Configure the Query

  • Select Database: Choose the database you're querying (e.g., MongoDB, MySQL).
  • Write Query: Input your SQL or NoSQL query in the node's configuration.

    • Example for SQL: SELECT * FROM users WHERE last_login > '2024-01-01'.
    • Example for NoSQL: { "lastLogin": { "$gt": "2024-01-01" } }.


3. Authenticate

  • Connection Details: Provide necessary authentication details like connection strings, usernames, and passwords.

Testing and Validation

  • Input Test Data: Use realistic test data to simulate the database queries.
  • Execute Workflow: Run the workflow and observe the execution of your database queries.
  • Analyze Results: Check the outputs and ensure the query results are as expected.

Best Practices

  • Optimize Queries: Ensure your queries are efficient, especially for large datasets.

Note: Efficiently executing database queries within Canonic workflows enhances your data manipulation capabilities. Proper setup, testing, and adherence to best practices ensure successful database interactions.

Did you find what you were looking for?
What went wrong?
Need more help?We have a thriving Discordcommunity that can help you with all things Canonic. →