is cloud-based accounting software for small businesses. It performs bookkeeping functions such as invoicing and payroll and allows you to connect to a live bank feed. For more information, see https://www.xero.com/ .

Limitations and Requirements

Create Connection

via 

When you create the connection, please review the following properties and specify them accordingly:

Connection PropertyDescription
Xero API

The following is the default value.

ACCOUNTING

The possible values are: ACCOUNTING, ASSETS, PAYROLLAUS, FILES, PROJECTS

OrganisationYou can enter your preferred organisation name. This field is optional. You can leave it blank.
Connect String Options

The following default value sets the connection timeout in seconds:

Timeout=0;

Setting this value to 0 disables timeouts.

OAuth 2.0

The OAuth client is created and selected for you.

NOTE: When you create the connection in this window, you must click Authenticate, which authenticates to the app. This step is required.

Default Column Data Type InferenceLeave this value as Enabled.

For more information, see the driver documentation https://cdn.cdata.com/help/DXG/jdbc/default.htm.

Data Type Conversions

For more information, see the driver documentation https://cdn.cdata.com/help/DXG/jdbc/default.htm.