topic Extract Greenplum to SAS in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Extract-Greenplum-to-SAS/m-p/190730#M48065 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I understand that when it comes to writing to Greenplum, the gpfdist utility can be used for bulk loading which speeds up the writeback from SAS to Greenplum.</P><P></P><P>How about the other way around? Is there any way I can speed up extracting data from Greenplum to my SAS workspace?</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 23 Jul 2014 07:20:49 GMT milts 2014-07-23T07:20:49Z Extract Greenplum to SAS https://communities.sas.com/t5/SAS-Procedures/Extract-Greenplum-to-SAS/m-p/190730#M48065 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I understand that when it comes to writing to Greenplum, the gpfdist utility can be used for bulk loading which speeds up the writeback from SAS to Greenplum.</P><P></P><P>How about the other way around? Is there any way I can speed up extracting data from Greenplum to my SAS workspace?</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 23 Jul 2014 07:20:49 GMT https://communities.sas.com/t5/SAS-Procedures/Extract-Greenplum-to-SAS/m-p/190730#M48065 milts 2014-07-23T07:20:49Z Re: Extract Greenplum to SAS https://communities.sas.com/t5/SAS-Procedures/Extract-Greenplum-to-SAS/m-p/190731#M48066 <HTML><HEAD></HEAD><BODY><P>The best thing to do is minimize datatransfer to your SAS workspace, Try to do as much processing as possible at the DBMS</P><P>hat is why <A href="http://support.sas.com/documentation/cdl/en/acreldb/66787/HTML/default/viewer.htm#n0nsx8cu0o5aimn19pdhz5s6ynts.htm" title="http://support.sas.com/documentation/cdl/en/acreldb/66787/HTML/default/viewer.htm#n0nsx8cu0o5aimn19pdhz5s6ynts.htm">SAS/ACCESS(R) 9.4 for Relational Databases: Reference, Third Edition</A> (Passing Joins to Greenplum) and executing SAS functions (in database processing) is getting promoted that much. Sometimes interfaces and SQL conversions are not stable enough in those cases moving to explicit pass through should bypass those issues.</P><P></P><P>Speedig up for the next part is faster IO (network buffering) and having a good performance on your SAS workspace. Some tuning options may help.</P></BODY></HTML> Wed, 23 Jul 2014 07:46:16 GMT https://communities.sas.com/t5/SAS-Procedures/Extract-Greenplum-to-SAS/m-p/190731#M48066 jakarman 2014-07-23T07:46:16Z