I was using the one of the CData Xero drivers, and followed the instructions to set up the connection using the credentials embedded in the driver, however, when I tried to verify the connection the following error occured:
How should I change the connection to fix this?
Best answer by Zachary G
View originalCurrently, the credentials embedded and used by default in the Xero drivers have hit a limit imposed by Xero. The CData team is working with Xero to increase this limit, but as that is a slow process, setting up your own OAuth credentials is an easy way to bypass the issue altogether.
To set up these credentials, use the below tutorial to set up your own OAuth Desktop Application or Custom Connection Application.
https://cdn.cdata.com/help/DXH/odbc/pg_connectingtoxerocustomappcreate.htm
After setting up a custom OAuth application, the below tutorial goes over setting the needed driver properties to use the new connection.
https://cdn.cdata.com/help/DXH/odbc/pg_connectingtoxerocustomapp.htm
Combining these tutorials will bypass the connection limit error, and allow use of the driver to its full extent.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Data Connectors
ETL/ ELT Solutions
Cloud & API Connectivity
OEM & Custom Drivers
