The CData Tableau Connector for Xero models five Xero APIs as easy-to-use SQL databases: Accounting, Australian Payroll, Files, Fixed Assets, and Projects. Set the Schema property and use the information in each section to select the proper API based on your project needs.

Using the Accounting API

The 会計データモデル contains the company's financial information, such as contacts, invoices and reporting. It also contains history tables which records changes to most kinds of entities.

INSERTs to specific tables which model line items in the Accounting API have batch support enabled. The recommended BatchSize setting for maximum performance is 50.

Using the Australian Payroll API

The オーストラリア給与データモデル contains information on the company's employees, such as timesheets, leave and tax declarations.

INSERTs to specific tables which model line items in the Australian Payroll API have batch support enabled. The recommended BatchSize setting for maximum performance is 50.

Using the Files API

The ファイルデータモデル contains information on the files and attachments managed by Xero. It can be used to upload and download files, and attach them to accounting entities.

Using the Fixed Assets API

The 固定資産データモデル contains information on the company's fixed assets, such as registration, depreciation and resale.

Using the Projects API

The プロジェクトデータモデル contains information on the company's projects, such as billing and time tracking.