When connecting Alchemex and Xero, you are continuously prompted to reconnect to Xero and provide authentication. Normally you will get a prompt when trying to run a report.

Store the connection properties by updating the ODBC Driver Properties

E.g. Add OAuthSettingsLocation=C:\SIMetadata\XeroDriver\Connections.txt in the OTHER Property of the connection.