SSIS Components for QuickBooks Online

Build 20.0.7587

新規テーブルの定義

The 本製品 allows you to easily define new tables without the need for custom SQL.

Defining Custom Tables

While the 本製品 supports the explicit creation of custom tables via stored procedures executed in custom SQL queries (such as CreateProfitAndLossDetailReport), the 本製品 also supports a more graphical, streamlined approach.

This is done using the 本製品's Define New Table functionality. You can define a custom table as follows:

  1. Navigate to any CData QuickBooks Online Source or Lookup component, then double-click it to open the configuration menu.
  2. On the Connection tab, set the 'Data access mode' to Table Or View.
  3. In the 'Table Or View' dropdown, select Define New Table. You may need to scroll up slightly from the top to see this option.
  4. A 'Define New Table' window will appear. Use the Table Schema Type dropdown to select the table type you want to generate.
  5. Configure the parameters to customize your table, then click the Create button to generate the table.
  6. You can then find your new table in the 'Table or View' dropdown.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587