What is Timbr?

Timbr provides a sophisticated semantic layer built upon SQL ontology principles. It enables organizations to integrate their data by assigning business context, defining relationships, and establishing consistent metrics. This approach significantly simplifies the complexity often associated with data analytics, allowing teams to work more efficiently and deliver insights faster. By modeling data using familiar business terms and defining semantic relationships that replace complex SQL JOINs, Timbr makes data more accessible and understandable across the enterprise.

The platform supports seamless integration with a wide array of data sources, including clouds, data lakes, data warehouses, and databases, utilizing data virtualization and an intelligent caching engine for optimized performance. Users can consume the semantically modeled data through various methods such as standard SQL, a powerful REST API for application development, direct connections to popular Business Intelligence (BI) and Data Science tools via JDBC/ODBC, or visual graph exploration. Timbr offers flexible deployment options, including a fully managed SaaS solution or self-hosted deployments for enterprise needs.

Features

Ontology Modeler: Model data using business terms, hierarchies, and classifications.
Semantic Relationships: Define relationships to simplify complex SQL JOIN operations.
Data Mapper: Automatically map data sources to the defined semantic model.
Data Virtualization: Query across multiple, diverse data sources using a distributed SQL engine.
Intelligent Cache Manager: Improve query performance and reduce costs with smart caching and materialized views.
SQL Lab: Interact with and query the modeled data using standard SQL.
REST API: Access semantic data for web applications with features like field selection and data nesting.
Graph Exploration: Visually navigate and understand data relationships as a connected graph.
BI & Data Science Integration: Connect seamlessly with popular analytics and ML tools via JDBC/ODBC.

Use Cases

Building a unified Semantic Layer for consistent analytics.
Implementing Data Virtualization across disparate data silos.
Creating a centralized and reliable Metric Store.
Establishing a Data Fabric or Data Mesh architecture.
Deploying a Semantic Model layer over Databricks.
Exploring and analyzing complex data connections via Graph Exploration.
Optimizing Supply Chain analytics with semantic context.
Developing comprehensive Customer 360 views.
Analyzing Human Resources data through a semantic lens.
Modeling and managing Telecom Network data structures.

FAQs

What data sources can I connect in the SaaS plans?

All plans connect to sources like Amazon Athena, Amazon Redshift, Databricks, Google BigQuery, Snowflake, SQL Server, etc. Business plans additionally support connections to Microsoft Azure Data Lake, Google Cloud Storage, Amazon S3, and MongoDB.
What BI apps and Data Science tools can I connect to Timbr?

You can connect BI tools such as Power BI, Tableau, and Google Data Studio via ODBC/JDBC connectors. For Data Science, Timbr integrates with Python libraries (JPype, JayDeBeAPI, SQL-Alchemy), Apache Spark, R, Scala, Java, and tools like Jupyter, Apache Zeppelin, and Pandas.
How is Timbr deployed? Can it be deployed on-premise?

Standard SaaS plans are fully managed and hosted by Timbr in the cloud. The Enterprise plan offers the flexibility of being self-hosted in your own cloud environment or deployed on-premises via Kubernetes within your VPC/VPN.
Does Timbr store my data?

No, Timbr operates as a semantic layer and does not store your actual data. Your data remains securely within your original databases or data sources.
Does Timbr include user management and access rights controls?

Yes, user management and Role-Based Access Control (RBAC) are included in the Teams, Business, and Enterprise subscription plans. Single Sign-On (SSO) capabilities are available for Business and Enterprise plans.