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.
Discussion posts and replies are publicly visible
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
We must to export data to another system.
Any suggestion to replace this approach ?
There is no way to load ALL data into Appian. But depending on what "export data" means, you will have to find a way to do it in batches.
Thx for ur reply.
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)
It sounds good for me. Where could I find more information about ?
It's a BIG topic. Here's a useful article:
www.altexsoft.com/.../