topic Re: Storing data in Alfresco DB in Alfresco Forum

Storing data in Alfresco DB

mboquillon — Thu, 01 Aug 2019 14:42:42 GMT

Hi,Is that possible to store any data in Alfresco ADF ?After some research, I can't find doc about creating new table in Alfreco db, or to connect Alfresco to another database.I find some stuff about MyBatis but no doc on how to use it with Alfresco.Any idea ?Thanks

Re: Storing data in Alfresco DB

eugenio_romano — Fri, 02 Aug 2019 09:39:59 GMT

Not sure what you are trying to archive but ADF is an Angular component library to use the Alfresco API. If you are trying to use an Alfresco API this is the right place otherwise you need to create your custom Angular component

Re: Storing data in Alfresco DB

mboquillon — Fri, 02 Aug 2019 12:36:27 GMT

I understand what is ADF and yes I'm using Alfresco API. But I need to store other data in my project and I would like to know if it's possible or not to create a custom table in Alfresco DB or to create another DB and add a link to get data.

Thanks

Re: Storing data in Alfresco DB

eugenio_romano — Fri, 02 Aug 2019 13:47:48 GMT

This really depends on what you need to store. Can you please provide an example?

Re: Storing data in Alfresco DB

mboquillon — Tue, 06 Aug 2019 12:10:37 GMT

For exemple : I need to store error log from another application we use, so that the user can find all informations in once.

Re: Storing data in Alfresco DB

eugenio_romano — Sat, 10 Aug 2019 11:24:15 GMT

I will create a different microservice, is not an Alfresco's technical concern this.

Re: Storing data in Alfresco DB

d_m — Fri, 16 Aug 2019 07:13:56 GMT

Hi Meryl,

Techniques that we use to store custom data in Alfresco:

add custom metadata in existing objects/documents
empty content objects/datalists with custom metadata
json data files

There are several places on the Alfresco system, outside sites and inside sites where you can store data objects that are not directly visible for the end users.

It is possible to create custom models made for specific types of content & apply automation on it.

Best regards,

David.

Re: Storing data in Alfresco DB

mboquillon — Tue, 20 Aug 2019 12:32:42 GMT

Hi David,

Thanks for the advices !