topic Re: Access a database from Alfresco in Alfresco Archive

Access a database from Alfresco

maephisto — Mon, 23 Jul 2007 13:35:31 GMT

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 m

Re: Access a database from Alfresco

derek — Wed, 25 Jul 2007 02:11:03 GMT

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

Re: Access a database from Alfresco

maephisto — Wed, 25 Jul 2007 06:43:23 GMT

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.

Re: Access a database from Alfresco

davidpisaac — Tue, 18 Sep 2007 01:25:57 GMT

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?

Re: Access a database from Alfresco

jagruti — Tue, 18 Dec 2007 12:46:42 GMT

hi maephisto,

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

Re: Access a database from Alfresco

cjimenez2581 — Tue, 15 Nov 2011 20:33:22 GMT

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? :?

Re: Access a database from Alfresco

mikeh — Tue, 15 Nov 2011 21:43:33 GMT

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

Re: Access a database from Alfresco

cjimenez2581 — Tue, 15 Nov 2011 21:47:22 GMT

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