Ok so turns out this is either a ‘bug’ or ‘works as designed’.
You CANNNOT use API-Keys with Excel 2016 and above and the v2 driver.
You must go into your system configuration file and disable the API key requirement…
Except Epicor will NOT let you modify this file if the client is hosted by Epicor, which is the main reason I need to do this in the first place. If they were on prem, I could just connect to their SQL Server and we would be done.
This same Excel incompatibility is also affecting the cData driver I’m using to pull data into a data warehouse tool
One wonders if this was done just to force people onto Epicor’s own EDA solution which they allow an install of an agent that extracts your SQL Data and sends it to the EDA data center.
