Just curious, is the rowpointer the unique ID on pretty much every row of the datalake? I'm looking into using ION to maybe stream certain CSD documents (OEET/OEEL/POET/POEL, etc…) by sending the json documents for those to a local server to ingest in our local SQL DB. Would the ingestion be based on the rowpointer?
Someon know to add additional property in ETL Infor to retrieve multilanguage from queryall? By compass i can make a select with this additiona property --*includeInSelectAll=s/g/p/l and query return example all launguages set in LN, i need to do in etl but i dont find nay documentation to do it,
Hello Everyone, I am looking for how to send a data fabric/data lake table data to Database table? Retrieve from Data Lake Activity Utilize ION Scripting to transform the data from JSON format to XML. Establish a connection to the database and insert the transformed data into the target table via a stored procedure. Does…
In any sql modeler: How can I use infor.IncludeDeleted. I have not find a way yet. It returns everything except deleted.
Hi, I am looking for guidance how to build up "ETL" from Data Fabric / Atlas into Azure Databricks. Goal would be to use ION API's from a Python job (Databricks Workflows) to fetch the json data and work our way selecting the correct data to use for reporting from there. Is there (easy to use) documentation on how to…
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
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…
It looks like you're new here. Sign in or register to get started.