I need to send Power BI’s data requests to an ODBC driver which will then forward the requests to a legacy Visual FoxPro application.
Unfortunately, such an ODBC driver is not available. Instead, we would like to use Postgres’s ODBC driver as an intermediary.
In other words, we want to send Power BI’s data requests to a copy of Postgress’s ODBC driver, and then forward the output of that copy to the legacy app, which will parse it and return the resulting data back up all the way to PowerBI.
How would the copy of the SQL Driver need to be configured in order to redirect its output in the way described?
Thank you very much