I’ve started a new job recently where I deal with high volume of disparate and non interlinked databases.
The issue here is mainly that I have several tools, database frontends and Excel-sourced information which need to be pulled together manually.
I’m curious if DA could help me here - a question that comes up for instance: Can I use DA to create this workflow:
Download newest .zip from a filer via a given URL.
unpack that zip file (xls) and check for defined contents (textfields) in excel?
(at least having the data unpacked and imported into DT automatically would help too)
Other question - can DA help me to work with Database frontends? I assume not as the db query will be given to a script rather than in a url. Not sure if that makes sense - any hints are welcome.