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.
Hi Jon, I'm not familiar with the mentioned data, but you can use the Compass query platform (through API or JDBC) to execute complex queries that can join tables or include conditions such as WHERE clause to pull specific records from an object in the Data Lake.
If you would like to perform Compass SQL incremental extraction each week, you can utilize the infor.lastModified column that is a reference to when the record was stored in Data Lake.
