I have setup the database which holds info about customers orders and those orders are saved in form of PDFs and/or TIFFs in the database per client.
As part of monthly business procedures, it is required that all invoices for one customer need to be joined in one file and stored as a monthly file in PDF/a format in the database for the archiving purposes.
So, the issue here is that i need to create/implement some kind of automation where this merging will be done by running some SQL procedure.
How can i achieve this? Or is this even possible?