Dears,
I am just wondering if there is a way to get all the records in Compass data lake instead of getting only the first 100 records.
Thanks,
Heba
I assume you are referencing the Data Fabric UI, where Compass queries can be run interactive. This UI is intended for data exploration in limited capacity around a browser environment. It is limited to 100 rows.
There are several other methods for data extraction https://docs.infor.com/inforos/2021.x/en-us/datafabrug/default.html?helpcontent=zkp1631199544812.html.
If you are looking to interactively explore larger data sets, the JDBC driver is likely where you want to look. There are steps in the documentation covering examples setups to a couple of tools. Other sources to review on the setting up the driver; webinars that can be replayed on Infor Campus, You tube videos on Infor YouTube, Infor Tech Blog site, and several Communities posting here.
