-
Inital Data Load Required after company copy.
When we perform a company copy in M3 (for example, PRD 100 → TRN 100), do we need to perform an initial data load for all tables? Sometimes we notice inconsistencies between M3 and the data in our replicated database. We are using M3 Data Streaming along with Data Fabric pipelines to replicate the data, so I wanted to…
-
Data fabric Learning - Training
I see Campus Courses are Fully booked all the way out into 3/26? Any word on future classes? This help documentation has been helpful. Infor Documentation Library Also, I'm very happy that I found this Forum. Thx, Joe
-
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.
-
Data Lake - View Issue
Hi Team, Please, I have create a new view using some tables join and an aggregation query. The view is successfully created, but when I tried to use it in a SELECT FROM query, I have the message below: SQL Error [624]: INTERNAL ERROR Message 624 An internal error occurred. Contact Infor Support. Query ID…
-
How to do a complete initial load of data in an enterprise space
Hi, I have created an enterprise space in Birst available through our CloudSuite License. In this space, I'm using the Infor data Lake connection and have created scripted sources from the LN table data objects in the default schema. After doing an initial load in LN , from Tools→Integration Tools→ Data Publishing…
-
Data refreshes for projects with referenced objects
Does anyone know how data is refreshed for Optiva / PLM projects that have existing references? I have users that are updating descriptions for formulas and items after the references are added to the project. They are telling me sometimes they update automatically and sometimes they don't. Does any one know what the…
-
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…
-
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…