Question 4 Replies 672 Views × Close popover Geetha Reddy (REDDYG02) Cognizant Technology Solutions Cognizant Technology Solutions US View Profile Send Message REDDYG02 Member since 2008 1 post Cognizant Technology Solutions Posted: August 13, 2018 Last activity: August 31, 2018 Posted: 13 Aug 2018 3:17 EDT Last activity: 31 Aug 2018 10:00 EDT Closed Solved Anyone successfully implemented solutions for 100k or more results for export to excel? Have similar requirement in 7.3. Tried Shell script invoke, but pega creating threads due to longtime and it takes 1 hr to generate file finally. Any successfully implemented solutions for 100k or more results for export to excel? Our requirement can go upto 400k. Reporting Share × Close popover Facebook Twitter Linkedin Email Copy Link Copied! Moderation Team has archived post, learn more × Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question. Posted: 2 years ago Posted: 13 Aug 2018 4:57 EDT × Close popover Gayatri Nistala (Gayatri) incessant incessant IN View Profile Send Message Gayatri incessant replied to REDDYG02 HI, Below link is similar to your query. https://community1.pega.com/community/pega-support/question/export-large-number-records-100000-excel-ootb-report-browser Posted: 2 years ago Posted: 13 Aug 2018 9:39 EDT × Close popover Rett Hean (Rett_Hean_GCS) PEGA Principal Software Solutions Engineer Pegasystems Inc. US View Profile Send Message Rett_Hean_GCS PEGA replied to REDDYG02 The Pega reporting feature was not designed to achieve this sort of data mining exercise. For that use case have a different product BIX. Posted: 2 years ago Posted: 15 Aug 2018 19:15 EDT × Close popover Geetha Matta (GeethaREddy M) CTS CTS US View Profile Send Message GeethaREddy M CTS replied to Rett_Hean_GCS I was able to achieve this using java and SH combination. Java does the Shell script invocation by passing required params to the shell script. Shell script reads the param and invokes the pega database using the https://env-int-api-gw.companydomain.com/splitpea/decrypt service and extracts the content and put as csv file in a location. Folder has been exposed to business to view them. Accepted Solution Posted: 2 years ago Posted: 31 Aug 2018 9:59 EDT × Close popover Lochana Durgada Vijayakumar (Lochan_DV) MOD Lead Technical Documentation Specialist Pegasystems Inc. IN View Profile Send Message Lochan_DV MOD replied to REDDYG02 Hello! Updating this post for the resolution provided on the original post by @REDDYG02 We achieved by using Java methods to invoke a shell script and drop to a location and expose the location. Java snippet wil use RunTIme and Process Proc class methods to excute the shell script. Shell script we can design to pass params and extract the report just like Pega does on Database.