Custom Tables in Alfresco

cancel
Showing results for 
Search instead for 
Did you mean: 
rharoonkhan
Member II

Custom Tables in Alfresco

Jump to solution

Hi , In our use case we have requirements to store the some extra data in the custom tables . Actually another application which are outside the APS can access these tables and display these information.

Which approach is best for this use case.

Might be Approach 1 : Create a external DB and through web scripts access this database. (In that scenario authentication using the alfresco ticket.)  and 2nd application directly access these tables or they access through alfresco web scripts.

Or create the Custom data models and and search on these models and write web scripts to access the database.

Any one guide which is best approach and other best way accomplish this ?

Thanks 

1 Solution

Accepted Solutions
openpj
Moderator
Moderator

Re: Custom Tables in Alfresco

Jump to solution

It strongly depends on the ownership of data that you need to store.

You could follow both the ways described in your message but please consider that if you need to use external database tables in APS, you should use MyBatis mappers to have a solution officially supported by Alfresco:

https://www.activiti.org/userguide/#advanced.custom.sql.queries

Hope this helps.

View solution in original post

1 Reply
openpj
Moderator
Moderator

Re: Custom Tables in Alfresco

Jump to solution

It strongly depends on the ownership of data that you need to store.

You could follow both the ways described in your message but please consider that if you need to use external database tables in APS, you should use MyBatis mappers to have a solution officially supported by Alfresco:

https://www.activiti.org/userguide/#advanced.custom.sql.queries

Hope this helps.