Overview
In this narrative, we will illustrate the use of the Export Pricefx Table to CSV via FTP Integration Template for FTP within the Pricefx IntegrationManager to load the transactions into a data source in extract master table data from our partition. The use of PM Marketplace export templates provides a quick and easy method for loading extracting master tables, price parameter tables, data sources, and data marts.
Additional templates provide the ability to load a variety of Accelerator packages (data and corresponding logic or data visualizations) directly into our partition.
Requirements
In order to be able to complete this process successfully, you will need to have the following prepared:
PlatformManager login credentials
Access to a Pricefx partition with update privileges
Access privileges for creating or accessing an IntegrationManager instance
SFTP Server access credentials
An extract of transaction data
JSON file of transaction data source layoutAssociated master tables (Product, Customer, etc)
Software Needed
The following software will need to be accessible or installed and configured:
PlatformManager
IntegrationManager
FTP Client (WinSCP)
Reference
See following URL for Cron Camel scheduler information: https://camel.apache.org/components/3.20.x/cron-component.html