Reading/writing files with MT-cloud

Since reading and writing from/to local files in Application Engine is not possible with MT-cloud, how can I read and write external files?

Find more posts tagged with

Infor EPM Discussions

Comments

Nick Gladkov

Peter, I suggest you have a quick call with Ruben - just much easier to be in the same time zone

In general, few options:

Use Repository+AppEngine approach. You can create AppStudio screen for uploading files, that will check structure, load data into staging table or cube, and remove attachment after that (if needed). This what we discussed with Ruben.
Infor OS can work with SFTP, so you can have share folder which a scheduled process which will be sent files to FTP, taken with Infor OS process and pushed into Data Lake, then read by d/EPM and put into staging tables which is pushed to cubes/dimensions
Use import process from staging tables which are connected with dimensions/cubes via mappings

For export, similar process can be done, but with opposite direction.

Nick Gladkov | Senior Product Manager, Infor d/EPM | Infor

Peter Mayall

I have used option 1 for importing files and this works reasonably well however this technique can't be used for export as there is no Application Engine function to create files in the repository.

In particular I am looking to export a budget file so it can be quite large and some techniques I was thinking of won't work with this scenario.

georges-vidal

Hi Peter

The use application engine to format a string then write it into repository is the solution I use to use.

Please find a sample of process I created for pocs.

Georges

Regards

CP_ExportCube_To_Repository_1.bs

CP_DELETE_ATTACHMENT_1.bs

Peter Mayall

Thanks George, I must of missed seeing the RepositoryCreateFile function.

Copyright © 2025 Infor. All rights reserved.