I was hoping someone could offer some assistance and guidance (preferably step by step) on how to connect Qlik Sense (On Windows - November 2020) to Sage 50 v27.
Current situation is this:
Qlik Sense on Windows is on Server 1 (S1)
Sage 50 (v27) is installed on Server 2 (S2). Account data is stored in \\S2\Accounts\Sage Data\Sage 50
The data, as seems to be the case with Sage 50, are flat files with the format .dta.
I have encountered this problem many moons ago and I think the connection would be a Sage Driver and a hook up via ODBC, but that's as much as I have figured out so far. I was hoping someone out there has done it recently and can offer some guidance.