Question4Replies609Views×Close popoverGeetha Reddy (REDDYG02) Cognizant Technology Solutions Cognizant Technology Solutions US View Profile REDDYG02 Member since 2008 1 post Cognizant Technology Solutions Posted: August 13, 2018Last activity: August 31, 2018Posted: 13 Aug 2018 3:17 EDTLast 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 ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Moderation Team has archived post 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 agoPosted: 13 Aug 2018 4:57 EDT×Close popoverGayatri Nistala (Gayatri) incessant incessant IN View ProfileGayatri incessant replied to REDDYG02HI, 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 agoPosted: 13 Aug 2018 9:39 EDT×Close popoverRett Hean (Rett_Hean_GCS) PEGA Principal Software Solutions Engineer Pegasystems Inc. US View ProfileRett_Hean_GCS PEGA replied to REDDYG02The 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 agoPosted: 15 Aug 2018 19:15 EDT×Close popoverGeetha Matta (GeethaREddy M) CTS CTS US View ProfileGeethaREddy M CTS replied to Rett_Hean_GCSI 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 agoPosted: 31 Aug 2018 9:59 EDT×Close popoverLochana Durgada Vijayakumar (Lochan_DV) MOD Lead Technical Documentation Specialist Pegasystems Inc. IN View ProfileLochan_DV MOD replied to REDDYG02Hello! 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.