为采购到付款配置 CData 同步

简介

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

In general, when you want to use CData Sync to load data from files, you should follow the steps as described in Loading data using CData Sync to set up data loading using CData Sync.

由于将文件中的数据加载到“购买到付款”时需要进行特定设置，因此请注意以下步骤。

Purchase-to-Pay 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 [Events_base_raw] SELECT * FROM [Events_base];
REPLICATE [Goods_receipt_base_raw] SELECT * FROM [Goods_receipt_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 [Purchase_order_items_base_raw] SELECT * FROM [Purchase_order_items_base];
REPLICATE [Purchase_orders_base_raw] SELECT * FROM [Purchase_orders_base];
REPLICATE [Purchase_requisitions_base_raw] SELECT * FROM [Purchase_requisitions_base]