为订单到收款配置 CData Sync

简介

在为“订单到收款”流程应用程序加载数据的“上传数据”选项旁边，您还可以使用 CData Sync 从文件加载数据。本页介绍如何使用 CData Sync 设置源连接，以将文件中的数据加载到 Process Mining 订单到收款流程应用程序中。

通常，如要使用 CData Sync 通过文件加载数据，则应按照使用 CData Sync 加载数据中所述的步骤使用 CData Sync 设置加载数据。

由于将文件中的数据加载到 Order-to-Cash 时需要进行特定设置，因此请注意以下步骤。

Order-to-Cash specific steps when configuring CData Sync

设置源连接

Select CSV as the source system to which you want to create a connection from the list, and make sure to define the settings as described in Create a source connection.

表格复制

Once the job is correctly setup, create a Custom Query paste the following queries (each query needs to maintain the semicolon at the end). Make sure you save all changes. See Create a job.

对于 订单到现金 ，请使用以下查询：

REPLICATE [Accounting_documents_base_raw] SELECT * FROM [Accounting_documents_base];
REPLICATE [Deliveries_base_raw] SELECT * FROM [Deliveries_base];
REPLICATE [Delivery_items_base_raw] SELECT * FROM [Delivery_items_base];
REPLICATE [Events_base_raw] SELECT * FROM [Events_base];
REPLICATE [Invoice_cancellations_base_raw] SELECT * FROM [Invoice_cancellations_base]; 
REPLICATE [Invoice_items_base_raw] SELECT * FROM [Invoice_items_base];
REPLICATE [Invoices_base_raw] SELECT * FROM [Invoices_base];
REPLICATE [Payments_base_raw] SELECT * FROM [Payments_base];
REPLICATE [Sales_order_items_base_raw] SELECT * FROM [Sales_order_items_base];
REPLICATE [Sales_orders_base_raw] SELECT * FROM [Sales_orders_base]