The Connector simplifies data exchange between Camunda 8 and both MySQL, MSSQL and PostgreSQL databases, allowing users to easily read and write data directly in a Camunda process.
This enables a wide range of process blueprints \/ use cases which can be executed on our platform without any additional installation \/ development
User Problem
As a user, I'm currently forced to rely on external, unsupported connectors (infosys) or invest time and resources into developing custom solutions to read and write data in our MySQL, MSSQL and PostgreSQL databases, leading to increased complexity, potential security risks, and higher maintenance costs.
Release Notes
Seamless Data Exchange with Camunda 8 and Databases
The new Database Connector for Camunda 8 simplifies data exchange with MySQL, MSSQL, MariaDB, and PostgreSQL databases, allowing you to easily read and write data directly within your Camunda processes. This integration enables a wide range of process blueprints and use cases to be executed on our platform without any additional installation or development. With the new Camunda Connector, you can now seamlessly integrate database operations into your workflows. This feature reduces complexity, enhances security, and lowers maintenance costs by providing a robust and efficient method for data exchange directly within the Camunda platform.
User Stories
Must have:
Query: As a user, I want to query data from MSSQL, MySQL and PostgreSQL databases directly within Camunda workflows to integrate current information into our processes seamlessly.
Add: As a user, I want to write new entries into MSSQL, MySQL and PostgreSQL databases from Camunda workflows to automate processes like customer registrations or order entries efficiently.
Update: As a user, I want to update existing entries in MSSQL, MySQL and PostgreSQL databases through Camunda workflows to ensure our databases always contain up-to-date information.
Delete: As a user, I want to delete entries in MSSQL, MySQL and PostgreSQL databases controlled by Camunda workflows to simplify data maintenance and ensure data quality.
Variable support: As a user, i want to use variables / secrets in my connection string, sql query.
Value Proposition Statement
The Connector simplifies data exchange between Camunda 8 and both MySQL, MSSQL and PostgreSQL databases, allowing users to easily read and write data directly in a Camunda process.
This enables a wide range of process blueprints \/ use cases which can be executed on our platform without any additional installation \/ development
User Problem
As a user, I'm currently forced to rely on external, unsupported connectors (infosys) or invest time and resources into developing custom solutions to read and write data in our MySQL, MSSQL and PostgreSQL databases, leading to increased complexity, potential security risks, and higher maintenance costs.
Release Notes
Seamless Data Exchange with Camunda 8 and Databases
The new Database Connector for Camunda 8 simplifies data exchange with MySQL, MSSQL, MariaDB, and PostgreSQL databases, allowing you to easily read and write data directly within your Camunda processes. This integration enables a wide range of process blueprints and use cases to be executed on our platform without any additional installation or development. With the new Camunda Connector, you can now seamlessly integrate database operations into your workflows. This feature reduces complexity, enhances security, and lowers maintenance costs by providing a robust and efficient method for data exchange directly within the Camunda platform.
User Stories
Must have:
Query: As a user, I want to query data from MSSQL, MySQL and PostgreSQL databases directly within Camunda workflows to integrate current information into our processes seamlessly.
Add: As a user, I want to write new entries into MSSQL, MySQL and PostgreSQL databases from Camunda workflows to automate processes like customer registrations or order entries efficiently.
Update: As a user, I want to update existing entries in MSSQL, MySQL and PostgreSQL databases through Camunda workflows to ensure our databases always contain up-to-date information.
Delete: As a user, I want to delete entries in MSSQL, MySQL and PostgreSQL databases controlled by Camunda workflows to simplify data maintenance and ensure data quality.
Variable support: As a user, i want to use variables / secrets in my connection string, sql query.
**Authentication** As a user, i want to authenticate via username + password or with via a connectionstring (https://learn.microsoft.com/en-us/sql/connect/jdbc/building-the-connection-url?view=sql-server-ver16)
Nice to have:
CRUD operations for tables, columns and rows.
Implementation Notes
:robot: This issue is automatically synced from: source