StreamSets is not a data federation tool. Yet it solves many of the same problems that data federation software does, without the drawbacks. Like data federation tools, StreamSets can help users create temporary tables from disparate data sources.
But unlike data federation, StreamSets helps you ingest, integrate, and manage structured, semi-structured, and unstructured data from relational and non-relational databases. Those users who employ federated queries to avoid the technical requirements of data integration tools can use StreamSets’s no-code interface to build robust data pipelines.
That way, without being required to write code, business users can leverage the reusability, recoverability, shareability, and performance that integrated data provides and federated data can’t.