Connecting to Simply Accounting back end

Hi, everyone.
A customer of mine is wanting to pull information from his Simply Accounting software, which uses a SQL back end (Google says it uses a MySQL type database??).

Does anyone have any experience or advice on how I can connect Ignition to the SQL back end of that software?

Thanks,
Cas

You’ll want to contact that company to confirm if they allow JDBC connections to their MySQL database, although it seems they don’t - they require proprietary software to be installed on the machine hosting the DB, and their software has to be running to access the database. I’m sure the reasoning behind this is for security purposes, I’m sure there’s some sensitive data in there, although I’m not exactly keen to the schema they use.