Skip to content
SPECIFICTION
Get listed

PGSpider vs SAS Federation Server

PGSpider

github.com

SAS Federation Server

support.sas.com

Side by side

FigurePGSpiderSAS Federation Server
Price fromFree—
Free planYes—
Free trial——
Open source——
Web—Yes
Windows—Yes
LinuxYesYes
API—Yes
Self-hostedYesYes
Plans published11
Spec score · Data Federation Software7.6 (#12)7.2 (#19)
PurposePGSpider is a SQL cluster engine for distributed big data that accesses data sources through Foreign Data Wrappers.SAS Federation Server provides scalable, multi-user data access and integrates data from multiple data services.

Plans

PGSpider

  • PGSpiderFree

PGSpider pricing →

SAS Federation Server

  • SAS Federation ServerPriced on request

SAS Federation Server pricing →

In their own words

PGSpider

PGSpider has no write-up on Specifiction yet; its figures are above.

Visit github.com

SAS Federation Server

SAS Federation Server provides multi-user access to data across multiple services through a virtualized layer. It brings separate sources into a federated view, with listed relational database connections for DB2, Oracle, SAP, SQL Server, Teradata, and Greenplum. Federated views can apply data-quality functions such as standardization and parsing. Described performance features include database pushdown, connection pooling, privilege access caching, and in-memory data caching. Security capabilities include centralized role-based access, data masking, and encryption of personally identifiable information. Users can create and share SAS metadata with other SAS solutions, and a Data REST API reference is listed for version 4.6. The most recent releases identified are SAS Federation Server 4.6 and SAS Federation Server Manager 4.6. Server-tier requirements list Oracle Linux 8.10 and 9.1, Red Hat Enterprise Linux 8.10 and 9.1, and SUSE Linux Enterprise Server 15 SP3. SAS names IT administrators, technical users, and business users among its intended audience. Pricing is on request; support includes a knowledge base, user community, and technical support.

Visit support.sas.com