- 发行说明
- 在开始之前
- 管理访问权限
- 入门指南
- 集成
- 使用流程应用程序
- 创建应用程序
- 正在加载数据
- Transforming data
- 自定义流程应用程序
- 发布流程应用程序
- 应用程序模板
- 通知
- 其他资源

Process Mining
在为“购买到付款”流程应用程序加载数据的“上传数据”选项旁边,您还可以使用 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时需要进行特定设置,因此请注意以下部分中描述的步骤。
设置源连接
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]