Hi, We are migrating an Infor V11 OP to a V12 Cloud and have to migrate a process which is to send a .txt file created from OLAP Cubes to a sFtp server (Infor Treasury – Kyriba platform)
Nowadays this process is running successfully in V11 OP developed in Import Master and SQL
We get not experience in V12 about this matter, things we have done are:
We have created a DSV, type txt in ION, which is a JSON file, which could later be read and written from APPLICATION ENGINE.
- Created a connection point, named 'FCP_FTP_KYRIBA', where the file to be sent will be located,
- DataFlow to collect this file and process it (change name, auto-send, etc.)
We know that App Engine has functions to process JSON files, but we don't know how to do it.
We don't have any examples, nor have we seen anything in the community that could guide us with our needs.
There is someone who could help us on this or even to know any other way to do it.
In short, we need to have a .txt file in ION CLOUD, which can be written from App Engine with data from a cube and from there, be able to send it via SFTP to the customer's server.
Thanks in advance,
Kind Regards,