Help using Base SAS procedures

Extract Greenplum to SAS

Reply
Super Contributor
Posts: 316

Extract Greenplum to SAS

Hi,

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.

How about the other way around? Is there any way I can speed up extracting data from Greenplum to my SAS workspace?

Thanks!

Valued Guide
Posts: 3,208

Re: Extract Greenplum to SAS

The best thing to do is minimize datatransfer to your SAS workspace, Try to do as much processing as possible at the DBMS

hat is why SAS/ACCESS(R) 9.4 for Relational Databases: Reference, Third Edition (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.

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.

---->-- ja karman --<-----
Ask a Question
Discussion stats
  • 1 reply
  • 167 views
  • 0 likes
  • 2 in conversation