We are new to the Infor landscape and are looking to understand how companies design their data flow from Infor CloudSuites to their storage layer. We’re seeking benchmark data on trends in deploying cloud, on-premise, or hybrid solutions for ETL and data warehousing, along with the factors influencing these architectural…
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…
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…
Good Morning, Hoping I have asked this in the right forum. After landing the data from the Data Lake into SQL Server using the ETL Tool (or whatever DB you use as a landing), what has others used to pull the data out of those landing tables into other applications? Do you repeat the same type of max(date), do you use a…
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…
Hi, could anyone advise me how to load or import excel data into Infor Data Lake.
Hello everyone, I need assistance with pulling data from the data lake using Effective Date and AsOfDate in Data Lake Compass. Specifically, I am working with the HRT system, querying the CRHH_HCM_Employee and CRHH_HCM_EmployeeBenefit business classes. Here’s the scenario: I have a list of 5 employees: Employee -…
I see this often where the DataLake will have XX number of records for a table, but IONETL provides XX - 1. I'll re-run the translation and no new records are downloaded. I'll truncate the local table and re-run the translation and the count is still the same, smaller than the record count in the DataLake. The only way I…
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…
Hello. Anyone know if you can format numeric output in a compass sql query? For example, if a value is stored as 123456, we would like to show it as 123,456. We couldn't find anything in the compass sql reference. Thanks!
It looks like you're new here. Sign in or register to get started.