Connector

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

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?

Regards,

[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}'
union
select 0,'','','',0,0,0,0,0,null,null
from customer
limit 1

groovy conectors, problem accesing bdm data

Greetings, Im having troubles with the bonita MicrosoftSQL server2008 conector. I need to make a query that depends on the data stored on the bdm. The exact problem is I can't access the bdm data from the groovy script witch is creating th query

thanks a lot for the help

Mauro

No graphic mode for Oracle connector

I am trying to connect to an Oracle 11G database using the wizard.

When I get to the mode step the graphic mode is greyed out:
phxFXmI.png

How I can use the output of a custom connector to set the initial value of a variable that can be displayed in the UI?

I have tried to assign the output to a process variable (a text I get from a external syste) but I am not able to show this value into a widget.

Is there a way I can do this using the community edition?

Thanks and regards,
Ronay.

Set web service to use with the connector

Hi,

I have created a web service in .asmx format and now need to use it in BonitaSoft, I'm using version 7.

How do I configure the SOAP connector to access the web service.

I tried a configuration but i got the following error message:

Variable in DB Connector

Hello I'm trying to pass a whole sql string into the connector.

For example i have the var SQLSTRING

then in the connector i only write ${SQLSTRING}

when i try to test the connector the following message appears

"Type of expression not admitted for test:
-Entry parameter ´script' is using an expression that contains an unreachable reference"

why is this happening?

Thanks

How can I query 2 different tables and get the result in 2 different result sets using 1 connector

Hi,

I want to know if it is possible to use only one connector in order to execute 2 or more different select querys and store the returned values in differents resultsets.

And also if it is possible how to do it

Thanks.

7.1 - Access connectors dynamically on multi-page forms

I am working with Bonita BPM 7.1, starting to build multi-page forms. It looks like the database connector functionality provides what I need in terms of querying an external database. However, I need to access the connector dynamically within the page. For example, first page-> Select person last Name, second page -> display list of matching people with selection. So between these steps I need to execute a parameterized query to the database. I can build a connector-in, but it always runs before the form.

Notifications