I'm looking to extract OIS320 Sales Price data based on a Customer/Item combination. and populate an external SQL database. What's the best approach given 250+ customers and 70,000 SKUs? It only needs to be updated once a week.
Hello, we are working on a transitional plan to have only one landing zone for Infor ETL data; however at this time we have 3. I am working on an ETL, per table, that reads once and writes to the 4 targets with the same input data. We are testing to ensure that the Main Driving table dl document data and all data is in…
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…
Using the ETL tool, I must extract data published to the Data Lake from Infor IPS. I have done this before with some other Infor LN clients, and it works great. However, I'm getting a date format error for this IPS client. If I look at the IPS data in Atlas it is in hours offset format. If I look at the lake for another…
Hello, We are in the process of moving from on-prem to the cloud and are working on getting ION ETL configured. We have an issue where Data Fabric won't load when we try to access it (Chrome or Edge) from our work PCs but it loads fine from our home PCs. When we try to open Data Fabric from our work PCs we get this error:…
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…
It looks like you're new here. Sign in or register to get started.