Access a database from Alfresco

[maephisto]

Hi,
I'm new to Alfresco. I know that Alfresco is more a ECM than another kind of tool. I wanted to know if there's the possibility to access a database (e.g. Oracle, MySQL, etc…) from Alfresco: imagine a particular user who fills a form and the result of the submission is stored on a database. From my webapplication I'll be then able to get all these records from the database.

Thx in advance.

[derek]

Hi,
Naturally, the first thing we do is to store the actual submission if it is a document of some sort.  You can then extract any information from it as desired using a MetadataExtracter.  You can then access the metadata and the original document at will.  It's not necessary to have a document; the information can be stored however you'd like.  But unless there is some other compelling reason why you need the ECM side of things, it might be a case of square peg and round hole.
Regards

[maephisto]

Yes,
but the thing is I'm forced to use Alfresco. So I should exploit every single feature of it.

The idea is that a website administrator creates static html pages through alfresco and freemarker: all these pages are stored in a Apache server, that "serves" them on different requests. But they want also to let an administrator use Alfresco UI to add some records in a database (Oracle): so I have to create a submission form and a "function" that takes all the values in the form and that makes an INSERT or an UPDATE query to add the new values in my tables. Maybe the Customizing and Extending Alfresco section in the Wiki could help me? It's too difficult? Or maybe there is another way than to create a kind of plugin for Alfresco?

Thx for the support.

[davidpisaac]

I'm also interested in this subject.  I need to manage case files with documents, but I also need to manage large lists within a case that would be better stored in a database (for concurrent access).  Being able to do this within the context of the Alfresco Web Client would greatly extend the reach of Alfresco for custom applications.  Any suggestions?

[jagruti]

hi maephisto,

did u succeded. if yes please make it available on the forum, i am in need of it.
thanks
Jagruti

[cjimenez2581]

Hi,
I'm new to Alfresco. I know that Alfresco is more a ECM than another kind of tool. I wanted to know if there's the possibility to access a database (e.g. Oracle, MySQL, etc…) from Alfresco: imagine a particular user who fills a form and the result of the submission is stored on a database. From my webapplication I'll be then able to get all these records from the database.

Thx in advance.

any success? :?

[mikeh]

I'm not sure a thread from four years ago is likely to still be relevant!

[cjimenez2581]

I'm not sure a thread from four years ago is likely to still be relevant!

I know it is an old topic but I cant find any documentation about this topic