Alternative publishing option

Sending a JavaScript Object Notation (JSON) file from Infor EPM through IMS to Data Lake is an alternative method of publishing data.

This list describes high-level steps of how to send data in a JSON file from the OLAP database to Data Lake:

1. In Application Engine, perform these steps:
   1. Create a script that uses the OLAPConnection object to connect to the OLAP database and the OLAPDataArea object to define a data area in an OLAP cube.

      You can use filters to limit the data set.

   2. In the script, create a newline-delimited JSON string that contains the data from the OLAP cube.
   3. Create the NotifyDebug(returnvalue) line to show the JSON content.
   4. Run the script, copy the output into a notepad and save it as the JSON file.
2. In ION, perform these steps:
   1. Select Data Catalog > Object Schemas and create an object schema to which to download the JSON file.

      The object name must be the same as the JSON file name.

   2. Select Connect > Connection Points and add the file to the bice IMS connection point.

      The bice connection point is provisioned by Infor. If you cannot find this connection point in ION, contact the Infor CloudOps team.

   3. Select Connect > Data Flows, create a Data Lake flow and activate it.

      Only one Data Lake flow is needed to transfer JSON files to Data Lake.

3. In the Application Engine script, comment out the NotifyDebug(returnvalue) line, and add the IONPublishMessage(string documentType, returnvalue) line. Then publish and run the script.
4. In Data Fabric, select Data Lake > Compass and verify whether the data from the JSON file has been loaded into Data Lake.
5. Optionally, to verify the JSON file content and the details of the JSON file transfer, select OneView in ION. You can investigate deeper if there were errors during the data transfer.

For information on Data Lake, Compass, and OneView, see Data Fabric and Infor ION documentation.

For information on Application Engine and how to create Application Engine scripts and processes, see the Application Engine section.