Extract Archer reports using SSIS
Objective - This solution enables automated data feed from Archer to Microsoft SQL for up to date reporting on 3rd party tools such as Tableau.SSIS has a option to use Web Service task which can make SOAP calls to Archer, retrieve the data, normalise it using XSLT and XSD and store it in SQL format. All you need is a report built out in Archer and the GUID to make a call.
Technical components - Microsoft SQL Server, Microsoft SSIS, SOAP web services for Archer, Availability of SOAP web services for Archer, Archer Account with Read All permissions (One account for each report), Run SSIS job as SSIS Proxy, Grant permissions to SSIS Proxy user to access C:\Windows\temp folder in DB Server)
High level flow