-
Is Datalake data persistent?
Hello Everyone, is the data in the data lake persistent or does it get purged automatically based on a specific interval or period ? i know that we can manually purge the data from datalake, but im asking if there is any default setting for automatic purging. thank you,
-
How to get know if EVS002MI Initiate process has already finished?
Hi All, I am wondering if there is a way to identify that the initial load job is completed. The process is triggered by EVS002MI Initiate. I know that there is a JBNO parameter, but checking of Job status returns code 30 (done) as soon as job started. Thanks, Ruslan
-
Please endorse: ERS119504- Atlas API for Objects having Data Objects in Data Lake missing currently
Please endorse: ERS119504- Atlas API for Objects having Data Objects in Data Lake is currently missing. In the Data Lake > Atlas menu option all Objects having Data Objects in Data Lake are shown. For this the <https://idf-06ionce.idf.eu1.inforcloudsuite.com/datafabricui/api/datalake/atlas/listdocuments> is called in the…
-
How to Create Data Lake Views
Hi all, looking for some advice on how to actually setup a datalake view. Infor help docs lead to circles :) Any quick tips would be appreciated
-
Can't access data from API response within Do while Loop in API flow
Hi I'm hoping someone can give me some assistance with this. I'm new to API flows. I have an API flow which calls 3 datalake APIs . The submit box calls the DATAFABRIC/compass/v2/jobs/ API The JobStatus box calls the DATAFABRIC/compass/v2/jobs/{queryId}/status/ API The Result box calls the…
-
Connect local SQL Database to DataLake using MS SQL Linked Server function
In my project, I need to connect to DataLake using Microsoft SQL Server. Im using the Linked Server functionality. How can I achieve this? I’ve already tried using JDBC-to-ODBC bridge drivers, but this solution appears to be very slow and unstable.
-
Compass query date = today
I want to query Dala Lake. I want to retreive all invoices entered today. How can I do that ? enterdt = ?
-
Loading Excel File into Data Lake
Hi All, 1. I am trying to Load Excel file into Data Lake. As Mike Kalinowski suggested, I have registered my "EXCEL" as "ANY" document type in Data Catalog, but there is no schema properties available for "EXCEL". How to achieve this. Can anyone suggest on this. Thanks in Advance. Regards, Rajini
-
Looking at the DataLake ETL Tool to update a local database. Wha are your experience with the ETL t
We are looking at purchasing the ETL tool and using it to update a local database from the Datalake. We're just looking for feedback on your experience with the tool. Is it a reliable tool for updating a local database? The demonstrations we've see make it look like it is relatively easy to use. Your thoughts and…
-
ION ETL - DLDocDate vs RepSet_Variation_ID
I'm just starting with the ION ETL tool, so far I have all the GHR tables being transferred to my local SQL database (TEST), I'll work on FSM next. All went well with the initial download, except for running the jvm out of heap space. Hopefully I've fixed that. I missed implementing logging when I set it up so now I'm…
-
Export multiple data objects from Datalake via EC as csv
Hello everyone, we have following situation, we are currently dumping data from an EPM Application into the Datalake. We then take the data and export it via Enterprise Connector to a specific folder as CSV. With dimensions it is not a problem but the problem arises with exports of cube data. Cube exports are larger then…
-
Compass Query - Return more that 100 rows
Hi, The Compass tool within Infor has always been limited to 100 rows in the Result Set. We heard that a change was going to be made to increase that to 1000's of rows. We already know that we can use a tool like DBeaver to connect through JDBC and get more rows returned. But we were wondering if a change was made to the…
-
How to load EXCEL data into Infor Data Lake
Hi, could anyone advise me how to load or import excel data into Infor Data Lake.
-
ION Data Flow to transfer Data Conversion files from a local workstation filesystem to the /reports
We are looking to build an ION Data Flow to transfer Data Conversion files from a local workstation filesystem to the /reports folder on CSD. I’ve built a POC using the following ION components: ION Data Flow: * Inbound Connection Point watches and pulls *.txt files using Enterprise Connector (IEC) from local workstation *…
-
Integrate LN to Microsoft Fabric with Infor OS
Hello, I’m working on a project where we need to integrate LN to Microsoft Fabric with Infor OS, and I’m looking for some guidance or best practices. Has anyone in the community successfully set up this integration? Specifically, I’m trying to achieve the following: * Data flow and synchronization between Infor OS and…