It is possible to develop connectors to any information system or webservice. E.g: Database, API, ERP, CRM, ...

Connector to update variable

I'm having a hard time understanding how to create connectors. I want to create one that receives a value (a date) stored in the bdm and updates the value of a process or task variable with that received value.
Any hints?
Thanks in advance!

Using a Variable in a Query

Hello all,

I have been attempting to insert a variable into a query and have found many different posts around the internet telling me to do it many different ways. For example... if I had the query

select veg_cat_code from geo_feat where geo_feat_id = '5';

I want to have it be

select veg_cat_code from geo_feat where geo_feat_id = 'variableToBeQueriedWith';

I can't seem to find out how to do this. I've read that

select veg_cat_code from geo_feat where geo_feat_id = '${variableToBeQueriedWith}';

Problemas al mostrar un Widget personalizado con una tabla, no muestra valores

Hola a todos,
Soy nuevo en Bonita 7.2, y estoy topando con problemas para mostrar los valores obtenidos en un Widget de tabla personalizada desde base de datos MySql, cualquier ayuda será agradecida.

I can't populate or display data from My Sql DB in a Custom Widget Table(JSON)

Hi all

I am a newbie at Bonita 7.2, struggling with displaying values, retrieved from a My SQL DB, in a custom table Widget. I need a little help, please.

CMIS Connector for upload list of documents is missing


I watched with great interest the webinar Managing documents and workflow by coupling BPM + ECM and was very enthused by the CMIS connector that uploads multiple documents at once.

For some reason, this CMIS connector does not appear in my list.

GroovyConnector not found on server

Good morning,
I'm working on a new process and I came to the following issue trying to run it on my Bonita Engine server.
From the portal within the studio, there's no errors at all and the process runs perfectly well.

The error is : org.bonitasoft.connectors.scripting.GroovyScriptConnector can not be found.

I checked in the Bar file and there's the file scripting-groovy-script-impl-1.0.2.impl in the connector folder.

Any ideas ?


[exception] groovy connector : script is null


I'm using Bonita BPM Community Edition v.7.2.1

Development > Manage groovy scripts
I created groovy script named 'GetId'.
and the contents are as follows.

public def static hello()
    return 'hello'; 

And I made a service task and it has a connector. I used Groovy 2.4 connector.
and its scripts are just only GetId.hello();

More help with Postgres/Connector/Conversion

I have a Postgres table, from which I want to get one row. This is necessary for my 'registration' procedure, that I need to get up quickly, and as a prototype for the rest of my project.

It has taken forever, as those of you who have read my rants and requests, know, to get this far.

My table:

Show SQL Server connector Resultset in a table

Hi everyone Im using a SQL Server connector and saving the result in a multiple variable, but the value doesn´t seem to be in json format, so how can I show the result in a table widget in the UI Designer?


[RESOLVED] Serious Question

Using CE Studio 7.2.2...

If I use anything but the simplest query, I cannot retain the ability to use graphical output options for my connector.

I have two issues I'd like help with related to the following.

Using postgres, can I contemplate writing a query like:

select customerid, customer, pass1, pass2, var1, var2, var3, var4, var5, date1, date2
from customer
where customer='${variable}'
select 0,'','','',0,0,0,0,0,null,null
from customer
limit 1