Canner Enterprise
Self-service data from warehouses, lakes, databases and NoSQL
Governed, self-service data access for your whole organization. Canner Enterprise is fully supported for our enterprise customers.
Solution architecture
One governed layer between every data source and every data consumer.
Consumers
Analytical applications
BI tools, SQL IDEs, ETL, ODBC / JDBC
PostgreSQL wire protocol
Operational applications
Dashboards, reports, internal tools
RESTful API
Intelligent services
Python, Spark, notebooks, ML pipelines
JDBC, Python and Scala SDK
Dedicated connectors
Tableau, Power BI
Push data
Context layer
Canner Enterprise
Data consumption
- Postgres protocol
- Dedicated BI connectors
- API endpoints
Data productization
- Data catalog
- Data discovery
- Virtual workspaces
Data virtualization
- Heterogeneous sources
- Metadata manager
- Schema history
Data authorization
- Layered data access control
- Data API access token
- Column-based access control
Sources
Files
CSV, JSON, Excel, FTP
Data lake
S3, Azure Blob, GCS, Hive, Parquet, ORC
Data warehouse
BigQuery, Teradata
Databases
PostgreSQL, MySQL, Oracle, SQL Server, DB2
NoSQL
MongoDB, Elasticsearch, Cassandra
What Canner Enterprise does
Data Virtualization
Virtualize and normalize metadata from sources.
Heterogeneous sources
Aggregate data across multiple data models with a virtualization layer over data lakes, data warehouses and siloed SQL sources.
Metadata Manager
Scan and map schemas and types in one place so definitions stay consistent across tools and storages.
Schema change history
Track upstream schema changes to prevent unpredictable downtime in downstream services.
Data Product Management
Enable self-service for business teams and users.
Data catalog
Add descriptions and labels to databases, tables and columns so data is discoverable.
Data discovery
A built-in search engine with per-group visibility controls for datasets.
Virtual workspaces
Compose analytic metrics with operational datasets owned by data domain owners.
Data caches
Configure ad-hoc, batch or incremental caching per business scenario.
Data Security
Unified authorization and policy across sources and applications.
Data access control
Govern collaborative datasets for authorized users and revoke rights as they propagate.
Data masking
Global and local masking rules based on the consumer's profile.
API access tokens
Personal access tokens replace password authentication for external API access.
Activity logs
Logins, operations and queries are logged so data use follows company policy.
Data Serving
Standardize metric definitions and business logic.
Output formats
RESTful API, Python, JDBC/ODBC, CSV and Excel for every kind of consumer.
Canner Protocol
PostgreSQL wire-protocol compatible, so any tool with a PostgreSQL connector works natively.
Dedicated BI connectors
First-class connectors for popular BI tools such as Tableau, with built-in refresh automation.
Improve data efficiency and reduce cost
Eliminate data copying
Reduce duplicate datasets and data engineering load.
Create data products
Achieve self-service analytics and higher analyst productivity.
Up-to-date reports
Agile, accurate reporting for executive decision-making.
Already a Canner Enterprise customer?
The documentation covers installation, configuration and every connector. For anything else, our support team is one email away.