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

Process Mining 用户指南

上次更新日期 2026年4月23日

为采购到付款配置 CData 同步

简介

Next to the Upload data option to load data for a Purchase-to-Pay process app, you can also use CData Sync to load data from files. This page describes how to use CData Sync to set up a source connection to load data from files into a Process Mining Purchase-to-Pay process app.

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

由于将文件中的数据加载到Purchase-to-Pay时需要进行特定设置,因此请注意以下部分中描述的步骤。

Purchase-to-Pay specific steps when configuring CData Sync

设置源连接

从列表中选择“CSV”作为要与其创建连接的源系统,并确保按照“使用 CData Sync 加载数据 - 创建源连接”中的说明定义设置。

表格复制

正确设置作业后,创建一个自定义查询,粘贴以下查询(每个查询末尾需要保留分号)。请务必保存所有更改。请查看使用 CData Sync 加载数据 - 创建作业

For Purchase-to-Pay use the following query:

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]
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]
  • 简介
  • Purchase-to-Pay specific steps when configuring CData Sync
  • 设置源连接
  • 表格复制

此页面有帮助吗?

连接

需要帮助? 支持

想要了解详细内容? UiPath Academy

有问题? UiPath 论坛

保持更新