Custom Tables in Alfresco

[rharoonkhan]

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 

[openpj · Accepted 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.