Infor OS - Datafabric Migration UI Utility
Summary
Infor OS - Datafabric Migration UI Utility
Utility for Datalake uploads and retrieval
Features
Authentication
Authentication is primarily used for authorizing the user to use the Utility. When a user first installs the tool, they will notice that few of the tabs are in a disabled state. To know more click on More features below.
Click on the upload button and select the .ionapi file which is a Backend service app created in the ION API Gateway. To initiate the authentication process, the user needs to upload an authorised app of backend service type. This app serves as a means of verifying the user's credentials and permissions
Once the correct .ionapi file is selected, all the tabs are visible and available for usage.
Single File Upload
This feature enables users to upload a single data file to a Datalake in a few simple steps/characteristics. To know more click on More features below.
Check the logs for success or failure of the uploads.
Finally, Click on upload to upload the data from selected file.
After selecting the file, users are presented with a dropdown menu containing available schemas for their tenant. They can also type a schema name directly into a field if it's not in the dropdown.
Users click the "Select" button to initiate the upload process, which opens a file dialog. They can then choose a .CSV or .JSON (with NdJSON data) file.
Multi File Upload
This feature is designed to facilitate the process of uploading multiple files to a specified schema. It streamlines the process into a few simple steps. To know more click on More features below.
Users click the "Select" button to initiate the upload process, which opens a file dialog. They can then choose a .CSV or .JSON (with NdJSON data) files (upto 20 files).
After selecting the file, users are presented with a dropdown menu containing available schemas for their tenant. They can also type a schema name directly into a field if it's not in the dropdown.
Finally, Click on upload to upload the data from selected file.
Check the logs for success or failure of the uploads.
Batch File Uploads
This advanced feature streamlines the process of uploading multiple files to multiple schemas in a highly organised and efficient manner. To know more click on More features below.
Users begin by creating a "workspace." The workspace is essentially a designated folder or directory where users can organize the files they want to upload
Within the workspace, users arrange files in a schema-file based manner. Each folder within the workspace represents a specific schema name, and the files contained within each folder are intended for upload to that schema.
Users ensure that the name of each subfolder within the workspace corresponds to the name of a schema within the application. This establishes a clear association between the files and their intended schemas
Within the application, users navigate to the upload feature and select the entire workspace folder, rather than individual files
Upon selecting the workspace, click on the “start the process” button. Upon that action, the application initiates a bulk processing operation.
After successful processing, the user receives a confirmation message indicating that the files have been uploaded to the specified schema.
Get Data
This feature empowers users to extract/retrieve the data from a Datalake by running queries. It provides a flexible and user-friendly interface for querying and retrieving data. To know more click on More features below.
Users can check the logs as required.
Users can click on the run button to execute the query and retrieve the data from Datalake in a pop up window which can be saved in local machine.
Users can provide the limit and offset as required
User can either write a simple query or copy an complex query into the Query editor.
