I work for a very large healthcare organization and we have numerous systems around including ERP. Our BI / DW team uses SQL lots of time to pull data into QlikView but less experienced teams use various reporting tools that come with software and extract data into files and then load to QV.
Either way it is your choice but if you are after automation / efficiency, I would get access to your database and do some SQL
Qlikview can be used for Data Extraction(even complex). Data can be extracted with the SQL or Qlikview Script. It can connect to ODBC Compliant Datasources,
RDBMS(MySQL, Oracle, SQL Server etc...), Excel, XML etc. Custom Connectors are available to Connect to SAP, Sales Force or Custom connectors can be built to connect different. In total
Qlikview can connect to anykind of Datasources.
QVD's can be created after extraction and can start Analysing instantaneously through AQL. So, if you already have Qlikview resources the best bet would be Qlikview