topic Re: Custom Tables in Alfresco in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/custom-tables-in-alfresco/m-p/39878#M16708 <HTML><HEAD></HEAD><BODY><P>It strongly depends on the ownership of data that you need to store.</P><P></P><P>You&nbsp;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:</P><P></P><P><A href="https://www.activiti.org/userguide/#advanced.custom.sql.queries" rel="nofollow noopener noreferrer">https://www.activiti.org/userguide/#advanced.custom.sql.queries</A></P><P></P><P>Hope this helps.</P></BODY></HTML> Wed, 03 Jul 2019 12:09:52 GMT openpj 2019-07-03T12:09:52Z Custom Tables in Alfresco https://connect.hyland.com/t5/alfresco-forum/custom-tables-in-alfresco/m-p/39877#M16707 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&nbsp;and through w Sat, 22 Jun 2019 12:03:40 GMT https://connect.hyland.com/t5/alfresco-forum/custom-tables-in-alfresco/m-p/39877#M16707 rharoonkhan 2019-06-22T12:03:40Z Re: Custom Tables in Alfresco https://connect.hyland.com/t5/alfresco-forum/custom-tables-in-alfresco/m-p/39878#M16708 <HTML><HEAD></HEAD><BODY><P>It strongly depends on the ownership of data that you need to store.</P><P></P><P>You&nbsp;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:</P><P></P><P><A href="https://www.activiti.org/userguide/#advanced.custom.sql.queries" rel="nofollow noopener noreferrer">https://www.activiti.org/userguide/#advanced.custom.sql.queries</A></P><P></P><P>Hope this helps.</P></BODY></HTML> Wed, 03 Jul 2019 12:09:52 GMT https://connect.hyland.com/t5/alfresco-forum/custom-tables-in-alfresco/m-p/39878#M16708 openpj 2019-07-03T12:09:52Z