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…
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 *…
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!
Hello, I have created a web application that uses compass API calls. When querying the datalake directly the queries do indeed take about 10-12 seconds each, which has caused some latency issues in getting pages to load on my web app. I am using python and flask. I was wondering if anyone knows of a way to speed up the API…
Hello, I have added many tables to the data lake before, but this one i am getting an error. What steps did i miss or which of the steps should i repeat? Could not complete request No subscriber is registered or activated for OBTTRA.
Hi ALL We have problem with initiate one database MHPICH to Data Lake in M3 Cloud All time we have the same message "Error. Could not complete request. No subscriber is registered or activate for MHPICH" We tried add, delete and agian add or other variants - this does'n working Maybe who knows what is the problem? Best…
It looks like you're new here. Sign in or register to get started.