製品をチェック

無償トライアル:

無償トライアルへ

製品の情報と無償トライアルへ:

Xero WorkflowMax ODBC Driver

Xero WorkflowMax ODBC Driver を使って、ODBC 接続をサポートするあらゆるアプリケーション・ツールからXero WorkflowMax にデータ連携。

Xero WorkflowMax データにデータベースと同感覚でアクセスして、Xero WorkflowMax のClients、Jobs、Leads、Quote データに使い慣れたODBC インターフェースで双方向連携。

データ連携でお困りですか？

お問い合わせ

記事の内容

関連記事

Connect to Xero WorkflowMax Data from PowerBuilder


This article demonstrates how to use the CData ODBC Driver for XeroWorkflowMax to connect to Xero WorkflowMax data and execute queries in PowerBuilder.

The CData ODBC Driver for XeroWorkflowMax can be used from any platform or development technology that supports ODBC, including Sybase PowerBuilder. This article shows how to connect to Xero WorkflowMax data and execute queries from the Database Painter and controls such as the DataWindow.

Create a Profile for the ODBC Driver for XeroWorkflowMax

Follow the steps below to use the Database Painter tool to create a database profile based on an ODBC DSN (data source name) for XeroWorkflowMax. In the Database Painter, you can use wizards and the UI to work with Xero WorkflowMax data.

  1. If you have not already done so, create an ODBC DSN for XeroWorkflowMax. The DSN contains the connection properties required to connect to Xero WorkflowMax data. You can use the Microsoft ODBC Data Source Administrator to create and configure DSNs. This is the last step of installing the driver. Required connection properties are the following:
    • APIKey
    • AccountKey

    WorkflowMax API に接続するには、Xero からAPIKey とAccountKey を取得します。取得については、 Xero のサポートにお問い合わせ頂く必要があります。(https://www.workflowmax.com/contact-us).

    API キーとAccount キーを取得したら、APIKey とAccountKey 接続プロパティの値を設定してください。 これらが設定されれば、接続の準備は完了です。

    See the help documentation for a guide to creating a Xero WorkflowMax DSN.
  2. In PowerBuilder, click Tools -> Database Painter.
  3. In the Objects window in the Database Painter, right-click the ODBC node and click New Profile.
  4. On the Connection tab, enter a name for the profile and select the Xero WorkflowMax DSN in the Data Source menu. The ODBC DSN, required to create the Database Profile. (Salesforce is shown.)
  5. To view and modify a table, right-click a table and then click Edit Data -> Grid.
Live data accessible from an editable grid. (Salesforce is shown.)

Using Xero WorkflowMax Data with PowerBuilder Controls

You can use standard PowerBuilder objects to connect to ODBC data sources and execute queries. The following example shows how to retrieve Xero WorkflowMax data into a DataWindow. You can add the following code to the open method:

SQLCA.DBMS = "ODBC" SQLCA.DBParm = "ConnectString='DSN=CData Xero WorkflowMax Source'" CONNECT USING SQLCA; dw_clients.SetTransObject(SQLCA); dw_clients.Retrieve();