When developing a report or application in an on-premises world, you would go directly to your database, but now with the shift to Infor M3 multi-tenant there is a new way to store and extract your information. Infor has built a Data Lake that converges a repository of data generated by enterprise systems, 3rd party systems, users, IoT devices, and APIs. The Data Lake core functions are object storage, a data catalog, content indexing, management API’s, multi-platform SQL and analytics. Infor Data Lake is included with Infor M3 multi-tenant CloudSuites and enables you to store data regardless if the data is structured, semi-structured, or unstructured.
See the screenshot below for a view of the Data Lake within Infor M3 multi-tenant.
Flooding the Lake with M3 Data
To flood the Data Lake with M3 data, you would use Event Hub and ION. Infor M3 Business Engine uses Event Hub to send the JSON files (IMS) to the Data Lake. The benefit of replicating this information is that you will now have your entire repository of suite information in one location. Below you will see two diagrams, the first screenshot shows the high level flow of the Data Lake flood, while the second depicts the configuration of how ION is used during this process.
Diagram: Flood Flow
Diagram: ION Configuration
Accessing Data from DataLake:
Data from the Data Lake can be accessed through the following ways:
1.) Data Lake API’s:
Data Lake APIs can be found under ION API-> Available API->Infor ION-> InforDataLakeAPI. These API’s can be used to perform various actions from Data Lake.
2.) Infor ION Data Lake Flows:
Need near real-time information to make a workflow decision? Data Lake Flows can be used to retrieve data from the Data Lake to any end point using the retrieve option.
3.) Using Compass or the JDBC Driver:
You can query through the data lake tables using two different ways:
a.) Live SQL interface:
Compass Editor can be accessed from ION Desk-> Data Lake-> Compass
b.) Compass JDBC Driver:
The data from the data lake can be accessed from local SQL tools using the Compass JDBC Driver.
How we can help
Flooding Data Lakes is now considered as an industry best practice but may be a new concept for many users in the Infor M3 multi-tenant world. Doppio has the know how and the track record to successfully configure your data flows. Whether your organization is wanting to setup your own Data Lake or maximizing the usage of your stored information, we are here to help!
Please reach out to Maxwell Gaetz to explore a project with the Doppio Team at firstname.lastname@example.org.