topic Custom Tables in Alfresco in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/custom-tables-in-alfresco/m-p/39877#M16707 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>Which approach is best for this use case.</P><P></P><P>Might be Approach 1 : Create a external DB&nbsp;and through web scripts access this database.&nbsp;(In that scenario authentication using the alfresco ticket.)&nbsp; and 2nd application directly access these tables or they access through alfresco web scripts.</P><P></P><P>Or create the Custom data models and and search on these models and write web scripts to access the database.</P><P></P><P>Any one guide which is best approach and other best way accomplish this ?</P><P></P><P>Thanks&nbsp;</P></BODY></HTML> Sat, 22 Jun 2019 12:03:40 GMT rharoonkhan 2019-06-22T12:03:40Z 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