process-mining
latest
false
重要 :
请注意,此内容已使用机器翻译进行了部分本地化。 新发布内容的本地化可能需要 1-2 周的时间才能完成。
UiPath logo, featuring letters U and I in white

Process Mining

上次更新日期 2025年9月18日

为采购到付款配置 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时需要进行特定设置,因此请注意以下部分中描述的步骤。

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 Loading Data Using CData Sync - 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. Check out Loading Data Using CData Sync- Create a Job.

对于“购买到付款”,请使用以下查询:

REPLICATE [Accounting_documents] SELECT * FROM [Accounting_documents];
REPLICATE [Events] SELECT * FROM [Events];
REPLICATE [Goods_receipt] SELECT * FROM [Goods_receipt]; 
REPLICATE [Invoice_items] SELECT * FROM [Invoice_items];
REPLICATE [Invoices] SELECT * FROM [Invoices];
REPLICATE [Payments] SELECT * FROM [Payments];
REPLICATE [Purchase_order_items] SELECT * FROM [Purchase_order_items];
REPLICATE [Purchase_orders] SELECT * FROM [Purchase_orders];
REPLICATE [Purchase_requisitions] SELECT * FROM [Purchase_requisitions]REPLICATE [Accounting_documents] SELECT * FROM [Accounting_documents];
REPLICATE [Events] SELECT * FROM [Events];
REPLICATE [Goods_receipt] SELECT * FROM [Goods_receipt]; 
REPLICATE [Invoice_items] SELECT * FROM [Invoice_items];
REPLICATE [Invoices] SELECT * FROM [Invoices];
REPLICATE [Payments] SELECT * FROM [Payments];
REPLICATE [Purchase_order_items] SELECT * FROM [Purchase_order_items];
REPLICATE [Purchase_orders] SELECT * FROM [Purchase_orders];
REPLICATE [Purchase_requisitions] SELECT * FROM [Purchase_requisitions]
  • 简介
  • Purchase-to-Pay specific steps when configuring CData Sync
  • 设置源连接
  • 表格复制

此页面有帮助吗?

获取您需要的帮助
了解 RPA - 自动化课程
UiPath Community 论坛
Uipath Logo
信任与安全
© 2005-2025 UiPath。保留所有权利。