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).