Hi, When creating target tables for the Infor ETL tool, i have been using the SQL button on the upsert. it converts the varchar to nvarchar columns, while the M3 tables are varchar. Is it recommended to use the SQL button and use the defaults that it uses for data types? Vs, creating table using the M3 create table sql?
Hello Everyone, is the data in the data lake persistent or does it get purged automatically based on a specific interval or period ? i know that we can manually purge the data from datalake, but im asking if there is any default setting for automatic purging. thank you,
Please endorse: ERS119504- Atlas API for Objects having Data Objects in Data Lake is currently missing. In the Data Lake > Atlas menu option all Objects having Data Objects in Data Lake are shown. For this the <https://idf-06ionce.idf.eu1.inforcloudsuite.com/datafabricui/api/datalake/atlas/listdocuments> is called in the…
I want to query Dala Lake. I want to retreive all invoices entered today. How can I do that ? enterdt = ?
I need to convert a datetimestamp to the equivilent EPOCH value. We were going to do a datediff and then tack on the Milliseconds at the end, but i am not sure how to extrapolate the Milliseconds. Is anyone aware of how to convert datetimestamp back to the epock value or get milliseconds from a datetimestamp?
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…
It looks like you're new here. Sign in or register to get started.