Hello Greetings!. We are in the progress of setting up the connection configuration to call the ION API's, and third party provides Http Client, Rest Client. Can anyone please suggest what is the best practices. Thanks
I noticed a record count difference between a table I downloaded via ION ETL and the record count in Compass. By changing my compass query to included deleted records I was able to get the record count to match. I.E. SELECT COUNT(RepSet_Variation_ID) FROM infor.IncludeDeleted('FHDL_FSM_Actor') I tried to add a query string…
Consulta, estamos consumiendo datos mediante ION ETL, todo normal hasta ahí. Resulta que la zona horaria del Data Lake es UTC+0, pero yo me encuentro en UTC-5, por lo cual necesito establecer una configuración general para que los campos tipo fecha bajen con UTC-5 y no con UTC+0 como actualmente están bajando. O si conocen…
Hello, My team and I have been looking for ways to make sure the data coming through in the Data Lake accurately reflects what data there is on the front-facing side of the Infor application. We can do things like comparing Employee counts or sum of Hours, but we were wondering if there is another tool or method that can…
The following describes the new release highlights for users of Infor OS Data Fabric: * Compass Mode Configuration: Compass SQL architecture is enhanced to support a new query engine mode, called Analytical mode. The Compass Query Editor now includes a Mode Configuration panel. Compass Mode Configuration, enables users to…
Hi, I have two questions 1) With the recent releases to the Infor ETL tool, since we have the tool installed locally (I believe), how do we get the most recent upgrades to the tool. 2) I want to only select records from MITTRA with a type of 31 to minimize the number of records we are pulling out of the data lake. Do i do…
Hi, Is there an additional index on our staging (landing) tables that we should be implementing when we create the ETL target tables? I thought there was with the initial release of the tool, but maybe the tool is using the one that is created automatically. Tina
Where is the User and the Security Roles stored in the Data Lake? Audit and Monitoring Setting have Publish Auditing and Monitoring data to Data Lake checked.
Hi all, I'm looking at using Infor ETL to automate data export from the data lake to a SQL Server. Most other methods of getting data out of the data lake (APIs, JDBC, data flows, etc) have record caps, so for substantial data sets that might be an issue. I've scoured the documentation and Concierge without finding an…
Hi team, I have an issue in a M3 CE customer. They have created a lot of roles and assignments to users in M3 (MNS410) and they need to recreate them in IFS (user administration) I know there is a tool to import an XML file into IFS, but this implies to extract the data from CMNRUS and edit this file somehow… Have you…
It looks like you're new here. Sign in or register to get started.