How to fetch more than 1000 rows from DB

Question

He everyone!
So, I've created a ER to fetch data from database, using a stored procedure. However, it seems being limited by 1000 record by search.
Is it possible to change this config. If so, anyone can tell how should I procced ?
One option it to dismember the search and do it little by little, until fetch all data requested, but I rather to try something more easy and smart.

stewart.burchell · Accepted Answer

If you're exporting the data from a DB via Appian only to push it into another DB you'd be better off by-passing Appian and using an ETL tool (these are dedicated tools designed to Extract/Transform/Load data in this way)

stefanhelzle0001 · Answer

Why do you need to load that much data into Appian?And that limitation is well documented here:; https://docs.appian.com/suite/help/22.4/fnc_system_a_executestoredprocedureforquery.html#limitations

Sign up

Login with SSO

Login to the community

Login with SSO