Hello, In the features of the April release, I had noted this one: Data Warehouse & Data Orchestrator I wanted to know more about it but couldn't find any information on the usual resources. If you have any information to share on this subject I'd be delighted to read it. In particular, I'd like to be able to position this…
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…
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.
It looks like you're new here. Sign in or register to get started.