SAS Federation Server vs Teiid
SAS Federation Server
support.sas.comTeiid
teiid.ioSide by side
| Figure | SAS Federation Server | Teiid |
|---|---|---|
| Price from | — | Free |
| Free plan | — | Yes |
| Free trial | — | — |
| Open source | — | — |
| Web | Yes | — |
| Windows | Yes | — |
| Linux | Yes | Yes |
| API | Yes | Yes |
| Self-hosted | Yes | Yes |
| Plans published | 1 | 1 |
| Spec score · Data Federation Software | 7.2 (#19) | 8.0 (#8) |
| Spec score · Data Virtualization Software | 7.3 (#21) | 8.1 (#10) |
| Audience | SAS describes the intended audience as IT administrators, technical users and business users who need to address security, performance and data-access issues. | The FAQ identifies Java developers integrating multiple enterprise data sources as the main users and says big-data, LDAP-style, and primarily streaming workloads may not be a good fit. |
| Purpose | SAS Federation Server provides scalable, multi-user data access and integrates data from multiple data services. | Teiid is a Java data virtualization query engine that integrates data from multiple sources through a uniform API. |
| Security | The course describes centralized role-based access, data masking and encryption of personally identifiable information. | The site describes Teiid as providing secure data access and says Spring Boot projects can select security integration among their dependencies. |
| Support | The support page offers a knowledge base, SAS user community and technical support through its support track system. | The site directs users to community channels including Stack Overflow, a legacy forum, GitHub, and project issue trackers. |
Plans
In their own words
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.
Teiid
Teiid is a free, open-source data virtualization project that gives applications a uniform way to query multiple underlying sources. It works as a gateway rather than storing the data, and virtual databases can present separate sources together so applications can join or union their results. Access is available through JDBC, ODBC, OData, and REST. Built-in translators are listed for Oracle, DB2, SQL Server, MySQL, PostgreSQL, and files; custom translators can also be made. Its optimizer uses source capability information to send query work to underlying systems where possible. Documented runtimes include Spring Boot, WildFly, embedded Java, and OpenShift, with Spring Boot noted as less feature-complete than WildFly. Teiid is aimed especially at Java developers integrating enterprise data sources. Connecting to sources commonly requires third-party drivers that are not included. The FAQ cautions that big-data, LDAP-style, and primarily streaming workloads may not be a good fit. Teiid Designer is deprecated, with no further releases expected.