ODBC Driver for Xero

The Xero ODBC Driver is a powerful tool that allows you to easily connect-to live Xero Accounting data through any ODBC capable application or tool! Access Xero data like you would a database - read, write, and update Xero Customers, Transactions, Invoices, Sales Receipts, etc. through a standard ODBC Driver interface.

The installationscript searches standard places like /usr and /usr/local. Before installing, you need to find out whether you have unixODBC already installed and where it is installed. If you are upgrading, you will need a new license from Easysoft to use the new driver. All warnings are written to a file called warnings in the directory you unpacked the distribution into. This is because on some platforms, files in use cannot be replaced. You should ensure that nothing on your system is using Easysoft software before starting an installation.

Throughout the installation, you’re prompted to answer some questions. Change into the directory created by unpacking the tar file to run the installation script. During the installation, you’re prompted for various pieces of information.

We recommend that you install all components as the root user.
Install the Easysoft ODBC-Xero driver on the computer where the application you want to connect to Xero is running.
The default answer when you type nothing and press Enter is n.
You don’t therefore need to recreate your Easysoft ODBC-Xero driver data sources if you reinstall or upgrade.
To obtain a refresh token on Linux or UNIX, change to the /easysoft/xero_oauth directory and then run xero_oauth2.
If you’re using the unixODBC included in the Easysoft ODBC-Xero driver distribution, the SYSTEM odbc.ini file is in /etc.

Easysoft ODBC-Xero driver User's Guide

Licenses are stored in installation_path/easysoft/license/licenses. The installation_path/easysoft/license/licshell program lets you obtain or list licenses. This means the default SYSTEM odbc.ini file where SYSTEM data sources are located is /etc/odbc.ini.

However, 64-bit applications must use 64-bit connectors, and 32-bit applications must https://buzzchronicle.net/hourly-paycheck-calculator-3/ use 32-bit connectors. On 64-bit Windows operating systems, you can execute both 32-bit and 64-bit applications. Accessing data from any remote source has the potential to create these problems.

Connect from BI, Reporting, & ETL Tools

These optional attributes may be set in odbc.ini.
In each case, the default choice displays in square brackets and you need only press Enter to accept the default.
The installation can be done by anyone with root access.
To use the Easysoft ODBC-Xero driver to work with your Xero data, you need to obtain a refresh token.
For the unixODBC Driver Manager, add the following attributes to the ODBC section (create one if none exists) in odbcinst.ini.

If sysconfdir was not specified when unixODBC was configured and built, it defaults to /usr/local/etc. This section explains how to remove the Easysoft ODBC-Xero driver from your system. If you chose either View Request or Email Request, apply your license by double-clicking the email attachment when you get xero odbc driver the license email from us. If possible, Restart Manager restores applications to the same state that they were in before it shut them down. These applications are displayed in the Files in Use dialog box.

Xero ODBC Driver

The end-user license agreement (EULA) is in the file license.txt. The distribution for UNIX and Linux platforms is a tar file. However, if you installed the Driver Manager in a non-standard place and you do not install the included unixODBC, you will need to know the location.

By default, the Easysoft ODBC-Xero driver installation creates a sample SYSTEM data source named XERO_SAMPLE. Add this to the end of the file installation_path/easysoft/license/licenses. All files are installed in a subdirectory of your specified path called easysoft. The installation primarily needs unixODBC’s odbcinst command to install drivers and data sources. When the Easysoft ODBC-Xero driver is installed into unixODBC, it places a Easysoft ODBC-Xero entry into the odbcinst.ini file. The Driver attribute identifies the ODBC driver in the odbcinst.ini file to use for a data source.

About Easysoft

At the start of the installation, you’re prompted for an installation path. The following section shows you how to install the Easysoft ODBC-Xero driver and configure the ODBC data source that stores the connection details for your Xero organisation. Driver manager trace files show all the ODBC calls an application makes, including their arguments and return values. Some applications allow you to make an ODBC connection without configuring https://julienleveau.com/top-500-past-due-balances-ftb-ca-gov/ a data source. The file name and path of the file you want the driver to write log information to. Enable this option if you want multiple data sources to Easysoft ODBC-Xero driver share the same Xero refresh token.

We recommend that you install all components as the root user. Install the Easysoft ODBC-Xero driver on the computer where the application you want to connect to Xero is running. You’re then ready to work with Xero data in your application. In Task Manager, choose the Processes tab.

The Windows installation can be done by anyone with local administrator privileges. If a reduced usage count message is displayed, repeat this command until odbcinst reports that the driver has been removed. You should then exit the License Client by choosing option and complete the installation.

Make sure that the file is in directory that your application users can read and write to. For example, your application may prompt you to choose this from a list of DSNs. These optional attributes may be set in odbc.ini. Sign into your Xero account and then grant the Easysoft ODBC-Xero driver the access permissions it needs when prompted. To use the Easysoft ODBC-Xero driver, you first need to create a Xero app in the Xero Developer Platform web site.

You can either edit the sample data source or create new data sources. One of the jobs that the ODBC Driver Manager does is to manage ODBC data sources. Applications that support ODBC interface with an ODBC Driver Manager, which is included with the operating system, and also https://impulseconsultants.com.np/2025/03/31/what-is-accumulated-depletion/ the Easysoft ODBC driver distribution on some platforms. Then choose Enter License and paste the license in the space provided. The Easysoft ODBC-Xero driver installer then uses Restart Manager to try to stop and restart each application or service in the list. To avoid a system restart, choose Automatically close applications and attempt to restart them after setup is complete.

It provides stored procedures to optimize performance when working with Xero data. The source code for this UI is licensed under the terms of the MPL-2.0 license. If you have an issue with the Easysoft ODBC-Xero driver, we may ask you to tell us what your product version is.

Be sure to understand the terms of the agreement before continuing, as you’re required to accept the license terms at the start of the installation. If the installer detects you’re upgrading a product, the installer will suggest you delete the product directory to avoid having problems with files in use. The files are only updated if the files being installed are newer or have a later version number. These shared objects are placed in installation_path/easysoft/lib. If you are not root or the path /usr/local/easysoft already exists and is not a symbolic link, the installation will be unable to create the symboliclink. For example, if you accept the default location /usr/local, the product will be installed in /usr/local/easysoft and below.

To do this, you supply a connection string that contains the ODBC driver name and other driver-specific attribute-value pairs. When turned on, the Easysoft ODBC-Xero driver increases its preferred batch size for queries, which alters the number of Xero API calls it makes. Whether to turn on Easysoft ODBC-Xero driver logging. The Easysoft ODBC-Xero driver supports the Basic and Digest proxy authentication schemes. This attribute is provided as a workaround when permissions prevent your application storing updated refresh tokens in the registry (Windows) or in /etc/odbc.ini (Linux and UNIX).

The installer can repair a broken Easysoft ODBC-Xero driver installation. If you choose option , the license request is written to the file license_request.txt. To obtain a license, select one of the options from onwards for the product you’re installing. If you’re not connected to the Internet or don’t allow outgoing connections on port 8884, the License Client can create a license request file that you can email to us.

You’re then asked to choose how you want to obtain the license. To obtain a license automatically, you need to be connected to the Internet and allow outgoing connections to license.easysoft.com on port 8884. If you answer y, the installation runs the licshell script. This installs unixODBC into /usr/local/easysoft/unixODBC. For example, if odbcinst is in /opt/unixODBC/bin/odbcinst, the required path is /opt/unixODBC. The installation starts by searching for unixODBC.