Syndetic combines ETL and data warehousing in one system to help you get data projects done faster and better.

The data virtualization platform built for collaboration.

Agile
Replace large, upfront data warehousing projects with fast iteration defined by business and IT working together in the same system. Bring best practices from software development to data.
Collaborative
Unlike most tools, Syndetic considers both internal and external recipients to be data consumers with different requirements. Use the right slice of information for each project.
Flexible
Join across databases, third party datasets, and spreadsheets. Analyze the results in Tableau or PowerBI. As the underlying datasets change, outputs are updated in real time.
Secure
Grant access to consumers at a single virtual layer with view, table, and row-level security. Queries are logged, versioned, and permissions are centrally managed inside Syndetic.
Scalable
Syndetic grows with you as you accumulate more datasets, add more data consumers, and grow your data analytics function. No need to constantly bring data into a data warehouse.
Quick to deploy
Get up and running in days instead of months. Syndetic sits on top of your current architecture, combines ETL pipelines and data warehousing, and is hosted in the cloud.

Features

  • Familiar, SQL-based (Postgres-compatible) editing environment
  • Built-in version control
  • Results can be cached or queried on-demand
  • Capture which datasets are being used by which consumers
  • Catch changes to spreadsheets with visual diffs
  • Automatic detection of multiple spreadsheet tabs
  • Grant different permissions for different groups inside your organization
  • Give BI tools access to specific views without exporting and importing spreadsheets
  • Schedule recurring reports easily over email or FTP
  • Connect to any dataset that speaks JDBC or ODBC

How it works

Syndetic produces project-specific virtual databases that you can access like any other (e.g., directly over JDBC, or by connecting a tool like Tableau). You don't need to change your data architecture, just connect your existing data systems to Syndetic. You define views of your data using SQL, which can join across your various underlying datasets as if they were just one database.

Queries run against Syndetic are dispatched to the underlying data systems on demand and combined without the need for up-front ETL and copying of data. Filters and aggregations are automatically pushed down to the underlying datastores, and results can be cached at the virtualization layer if desired.

Syndetic works with spreadsheets and most commonly used databases (e.g., Postgres, Mysql, Oracle, SQL server, or any ODBC/JDBC-compliant database).