Mummm… I am thinking another approach.
Create a MYSQL database on Cpanel and create a schedule to do one way sync from MSSQL to MYSQL.
Use wpDataTables to generate reports.
I did a test ODBC link from my location to MYSQL at the host. The connection is not stable.
SO pulling database from local is better idea.
