Custom connector
Camunda

Custom connector
Camunda

Download Script_connector.bpmn file script-connector-main.zip file ⤳ case study requires Spring Boot Java

Download SQL_example.bpmn file

Script connector

• Script connector ☛ is a custom connector that aims at executing code based on third-party programming languages like Groovy or JavaScript
• Camunda Modeler must be configured by adding Script connector template (script-connector.json) ☛
• Custom connector for Camunda 8 Run requires manual configuration ☛
• java -jar script-connector-runtime.jar launches Script connector as a “common” job worker whose type is script

Script connector ⤳ template

Configuration of script connector runtime

File script-connector-main/runtime/src/main/resources/application.yaml

Script connector ⤳ BPMN

Script connector ⤳ execution

SQL Database Connector ⤳ template

Database

MariaDB database named gargantua must be created with user Belzebuth, password Belzebuth, and the following script

USE `gargantua`;
CREATE TABLE Curriculum_vitae(
    curriculum_vitae_identity MEDIUMINT UNSIGNED    NOT NULL AUTO_INCREMENT,
    instant                   VARCHAR(20)  NOT NULL,
    fingerprint               VARCHAR(100) NOT NULL,
    audio_or_video            VARCHAR(5)   NOT NULL,
    audio_file_path           VARCHAR(100),
    image_file_path           VARCHAR(100),
    text_file_path            VARCHAR(100) NOT NULL,
    video_file_path           VARCHAR(100),
    CONSTRAINT Curriculum_vitae_PK PRIMARY KEY (curriculum_vitae_identity)) CHARACTER SET 'utf8' COLLATE 'utf8_icelandic_ci';
INSERT INTO Curriculum_vitae (instant,fingerprint,audio_or_video,audio_file_path,image_file_path,text_file_path,video_file_path)
VALUES ('03/06/2025 16:07:00','B--DiB--DiB--DiB--DiB--DiB--Di32','video','./video/Geriatrie.mp3','./video/Geriatrie.jpg','./video/Geriatrie.txt','./video/Geriatrie.mp4');

SQL Database Connector ⤳ input process variable

SQL Database Connector ⤳ database setup

SQL Database Connector ⤳ query

SQL Database Connector ⤳ output process variable

SQL Database Connector ⤳ execution