cancel
Showing results for 
Search instead for 
Did you mean: 

can i integrate mysql ,jbpm and alfresco

tejashpatel
Champ in-the-making
Champ in-the-making
hi everyone

    i want to integrate mysql and jbpm workflow in alfresco.

    if anyone have any example then please give me some hint for that

    regards,
   Tejash
6 REPLIES 6

davidc
Star Contributor
Star Contributor
From v1.4, Alfresco integrated jBPM for advanced workflow features.  You can also configure Alfresco (inc. jBPM) to execute against MySQL .

So, the kit you list is already integrated.

tejashpatel
Champ in-the-making
Champ in-the-making
From v1.4, Alfresco integrated jBPM for advanced workflow features.  You can also configure Alfresco (inc. jBPM) to execute against MySQL .

So, the kit you list is already integrated.


hi ,
thank you for your reply

i have stuck like this .

suppose i have one table leavebalance in mysql database.
there are few columns in this table
now i want to show it's data in my workflow dialog box.

could u send me any source code for this stuck in alfresco.

regards,
Tejash




regards,
Tejash Patel

davidc
Star Contributor
Star Contributor
Huh?

tejashpatel
Champ in-the-making
Champ in-the-making
Huh?


have stuck like this .

suppose i have one table leavebalance in mysql database.
there are few columns in this table
now i want to show it's data in my workflow dialog box.

could u send me any source code for this stuck in alfresco.

regards,
Tejash

davidc
Star Contributor
Star Contributor
I'm confused, you're confused.  Modifying existing forum entries just adds to the confusion!

Why do you have a leavebalance table?  Are you integrating a 3rd party system? If not, use Alfresco native capabilities.  That is, define a content model for your data requirements and store the data in Alfresco, not in mysql tables.  That way, you can use Alfresco's native workflow support for displaying custom data in workflow dialogs.

http://wiki.alfresco.com/wiki/Workflow

If you are integrating a 3rd party system, then you have two options.

a) Define an Alfresco content model for the pieces of data you wish to integrate - then during the workflow, populate those pieces of data from your 3rd party system, and use Alfresco's native capabilities for displaying that data - of course, you are duplicating this information, but that may not be a bad thing, as you may want a snapshot anyway for the lifetime of the workflow.

b) Customise (i.e. do some manual code modification of) Alfresco so that it integrates with your 3rd party system - this is possibly more difficult - don't ask me how - as I only know half the answer, as I only know Alfresco, not your 3rd party system.

http://docs.jboss.com/jbpm/v3/userguide/

renatko
Champ in-the-making
Champ in-the-making
Tejash, perhaps you could try data integration tool to get it done, I work for Apatar, an open source data integration project, - 

http://www.apatar.com

we have MySQL connector, as well as MS SQL, Oracle, PosgreSQL, Salesforce.com, DB2, FTP, POP3, CSV, XML, WebDav, and even Flickr.

Check it out and let me know if it worked for you.

Renat