topic Re: can i integrate mysql ,jbpm and alfresco in Alfresco Archive

can i integrate mysql ,jbpm and alfresco

tejashpatel — Mon, 19 Mar 2007 06:53:12 GMT

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

Re: can i integrate mysql ,jbpm and alfresco

davidc — Mon, 19 Mar 2007 09:55:45 GMT

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.

Re: can i integrate mysql ,jbpm and alfresco

tejashpatel — Wed, 21 Mar 2007 12:41:23 GMT

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

Re: can i integrate mysql ,jbpm and alfresco

davidc — Wed, 21 Mar 2007 12:44:34 GMT

Huh?

Re: can i integrate mysql ,jbpm and alfresco

tejashpatel — Thu, 22 Mar 2007 04:27:31 GMT

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

Re: can i integrate mysql ,jbpm and alfresco

davidc — Thu, 22 Mar 2007 11:12:47 GMT

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/

Re: can i integrate mysql ,jbpm and alfresco

renatko — Sun, 15 Apr 2007 12:10:54 GMT

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