Documents Product Categories Denodo 9 Enterprise Plus

Denodo 9 Enterprise Plus

Oct 31, 2024
Datasheet The Denodo Platform Enabling Intelligent Data Delivery Gaining timely, effective insights from data is crucial in today’s fast-paced business environment. It’s all about innovation, making smart decisions, and keeping up with market changes. Imagine if everyone in your company could instantly access and integrate data from across the organization. Unfortunately, data landscapes are constantly evolving, with increasing cloud workloads and data spread across more environments than ever. The rising demand for data, driven by technologies like generative AI, also challenges data teams to keep pace. Traditional data management approaches involve moving and merging data into a central repository, such as a data warehouse or lake. This process can be expensive, time-consuming, and requires further preparation for various use cases, ultimately slowing business innovation and responsiveness. A new approach is needed—one that complements traditional methods by adding a centralized data access layer atop all data repositories. This layer simplifies complexity, presents data in business-friendly formats, and accelerates delivery while adhering to predefined semantics and governance rules. Data Self-Service Data Foundation for Improved Customer Experience Landsbankinn streamlined its data processes and enhanced accessibility, LeasePlan improved customer satisfaction empowering over 80% of targeted users, by creating new programs like predictive including those with limited data skills, to vehicle maintenance, incorporating both make informed decisions. internal and external data sources. © 2024 Denodo Technologies 1The Logical Approach to Data Management The logical approach is based on a unified data delivery platform that simplifies how everyone in your business accesses the various data systems. It’s about stripping away the complexity and serving up the data in formats that make sense to the user, while accelerating delivery and adhering to data governance rules. The Denodo Platform is the leading logical data management solution, enabling intelligent data delivery from distributed sources and presenting information in user-friendly formats for real-time, organization-wide access. It ensures the secure, timely delivery of high-quality data, empowering business users with seamless connectivity to a unified data source. Additionally, it enables security and compliance teams to monitor and manage all data access across all data sources, from a single point of control. Benefits include: • Unified Data Access: Breaking down data silos and offering a centralized virtual data abstraction layer for easy access to data, regardless of location or format • Data Tailored for Business Users: Translating complex data into user-friendly formats, simplifying access, querying, and analysis without requiring technical skills or IT help • Simplified Data Discovery: Enhancing visibility and accessibility with rich metadata, detailed lineage information, and AI-powered, intuitive search capabilities, to revolutionize data discovery and usage • Real-Time Insights: Delivering real-time data, ensuring timely access for faster decision-making and a competitive edge • Enhanced Data Security and Compliance: Ensuring integrity, security, and reliability using advanced features and third-party-tool integration © 2024 Denodo Technologies 2IT Infrastructure Enhance Centralized Governance, Modernization Operational Efficiency, Risk, and Compliance Agility and Resilience Sunbelt Rentals Seacoast Bank improved accelerated access to City Furniture enhanced security and compliance diverse data sources, operations and efforts by using data boosting productivity by profitability by developing for business process 200% by retrieving data a single source of truth automation and making from diverse systems, across sales, supply information readily including over 500 ERP- chain, merchandising, and available to key managers, system tables in under operations, resulting in including risk managers. three minutes, without improved market timing, engineering support. expanded market share, and increased profits. Denodo Platform Differentiators • Integrated Data Catalog: Streamlines data access with automatic recommendations, enhanced collaboration, profiling, and natural language search powered by AI. • Universal Connectivity: Simplifies connectivity to the widest range of data sources, with over 200 connectors to 3rd-party systems. • Embedded MPP Data Lake Engine: Provides data consumers with a highly scalable and performant SQL engine, based on Presto, with which to access data lake data, while simplifying data access through an intuitive GUI interface. • A Unified Semantic Layer: Facilitates data discovery and search and classification, and security and governance. • Global Security Policies: Globally manage access control (masking, encryption, data restrictions, etc.) using security classifications, glossary terms, and tags. • Smart Query Acceleration: Optimizes multi-source query execution through intelligent caching, cost-based optimization, and an AI-powered recommendations engine. • Financial Operations (FinOps): Provides visibility into operating costs, for more effective management of cloud infrastructure costs. • Broad Delivery Options: Provides more than JDBC or ODBC support for SQL queries by business users – developers can deliver data via a variety of options, including REST and GraphQL APIs, Kafka, and JMS message queues. • Data Preparation Wizard: Empowers users of all technical backgrounds to easily customize datasets within the data catalog, enabling quick adaptation of data products for various use cases. © 2024 Denodo Technologies 3COMPARING THE VARIOUS SUBSCRIPTION TIERS There are several flexible subscription options to choose from, designed to suit the needs of various projects, from small departmental projects to enterprise-wide digital transformation. Small, single-use-case projects Multiple use cases within individual Enterprise-wide deployment for Comprehensive automation, within individual departments departments multiple use cases and groups and collaboration, and advanced large data volumes security for enterprise-wide deployments Number of Data Sources Supported 5 Unlimited Unlimited Unlimited FinOps Logging and Integrated Dashboard Integration with Version Control Systems (VCS) Smart Query Acceleration using summaries VQL procedures Advanced Diagnostic & Monitoring Tool Data Catalog Data Catalog: Dataset collaboration through endorsements, warnings, and deprecation notes Integration with external Massive Parallel Processing (MPP) engines like Impala, Spark, and others Integration with 3rd party data modeling tools (ER/ Studio, Erwin, etc.) Embedded Presto-based MPP engine Automatic recommendation of summaries Global security policies Import data governance tags from external catalogs Data Catalog: Natural language queries and AI- based recommendations © 2024 Denodo Technologies 4Capabilities DATA SOURCES • MongoDB Atlas • Snowflake (JDBC) Relational Databases • Generic (JDBC) Big Data • IBM DB2 (JDBC): 8, 9, 10, 11, 12 for LUW, 9,10 for z/OS, • Apache Hive (JDBC): 0.12, 1.1.0, 1.1.0 for Cloudera, 1.2.1 AS400 for Hortonworks, 2.0.0 • Multi Layered Denodo deployments (JDBC): 5.5, 6.0, • Impala (JDBC): 2.3 7.0, 8.0 • Spark SQL (JDBC): 1.5, 1.6, 2.x, 3.x • Apache Derby (JDBC): 10 • PrestoDB (JDBC) • Informix (JDBC): 7, 12 • PrestoSQL / Trino (JDBC) • MS SQL*Server (JDBC, ODBC): 2000, 2005, 2008, • Databricks Delta 2.x 2008R2, 2012, 2014, 2016, 2017 • MySQL (JDBC): 4, 5, 8 NoSQL • Oracle (JDBC): 8i, 9i, 10g, 11g, 12c, 18c, 19c • MongoDB • Oracle E-Business Suite (JDBC): 12 • Cassandra • PostgreSQL (JDBC): 8, 9, 10, 11, 12 • HBase • Sybase Adaptive Server Enterprise (JDBC): 12, 15 • MS Access (ODBC) Multi-Dimensional Sources • SAP BW (BAPI/XMLA): 3.x In-Memory Databases • SAP BI 7.x (BAPI): 7.x • SAP HANA (JDBC): 1,2 • Mondrian (XMLA): 3.x • Oracle TimesTen (JDBC): 11g • IBM Cognos TM1 • Oracle 12c In-Memory • MS SQL Server Analysis Services 200x • Essbase (XMLA): 9, 111 Parallel Databases and Appliances • Exasol (JDBC) Data Lake Storage • GreenPlum (JDBC): 4.2 • S3 • HP Vertica (JDBC): 7, 9 • Azure Data Lake Storage • Netezza (JDBC): 4.6, 5.0, 6.0, 7.0 • Azure Data Lake Storage Gen 2 • Oracle Exadata (JDBC): X5-2 • Azure Blob Storage • ParAccel 8.0.2 (by using ParAccel 2.5.0.0 JDBC3g with • Google Cloud Storage SSL driver) • Parquet • SybaseIQ (JDBC) 12.x, 15.x • Avro • Teradata (JDBC): 12, 13, 14, 15, 16, 17 • Yellowbrick Web Services • SOAP Cloud Data Warehouse / RDBMS • REST (XML, RSS, ATOM, JSON) • Alibaba ApsaraDB for OceanBase MySQL (JDBC) • OData • Alibaba ApsaraDB for OceanBase Oracle (JDBC) • Alibaba ApsaraDB RDS for MySQL (JDBC) Flat and Binary Files • Alibaba ApsaraDB RDS for PostgreSQL (JDBC) • CSV, pipe-delimited, regular expression-parsed • Alibaba ApsaraDB RDS for Microsoft SQL Server • MS Excel xls 97-2003 (JDBC) • MS Excel xlsx 2007 or later • Alibaba ApsaraDB PolarDB for MySQL (JDBC) • MS Access • Alibaba ApsaraDB PolarDB for PostgreSQL (JDBC) • XML • Alibaba ApsaraDB AnalyticDB for MySQL (JDBC) • JSON • Alibaba ApsaraDB AnalyticDB for PostgreSQL (JDBC) • SAS Files (SAS7BDAT) • Amazon Redshift (JDBC) • All files can be local or in remote filesystems, through • Amazon Athena (JDBC) FTP/ SFTP/FTPS, and in clear, zipped and/or encrypted • Amazon Aurora (JDBC) format. • Amazon DynamoDB • Azure Cosmos DB Indexes and unstructured content • Azure SQL Database • CMS, file systems, text • Azure Synapse Analytics • ElasticSearch 6.4, 6.7 • Delta Lake Cloud, SaaS, Web Sources with Simplified OAuth • Google AlloyDB (JDBC) Security • Google Big Query (JDBC) • Adobe Analytics • Google Cloud SQL (JDBC) • Amazon • Google Spanner DatBoost (JDBC) • Google © 2024 Denodo Technologies 5Indicates the feature(s) is available in Enterprise. Indicates the feature(s) is available in Enterprise Plus • Google Sheets • Facebook DATA CATALOG • LinkedIn • MS Azure Data Lake Cataloging • MS Sharepoint (via OData) • Web-UI for seamless data discovery and exploration • MS Dynamics 365 Business Central / Customer for business users Engagement • Descriptions, documentation, and custom properties • Marketo • Business categories and tags Intelligent search with • ServiceNow smart ranking of results • Salesforce (SOQL) • Twitter Governance • Workday • Graphical data lineage • many more through configurable JSON and XML • Integrated request management (access, changes, adapters data quality issues, etc.) • Endorsement of datasets, comments, warnings, etc. Active Directory as Source or Leveraging Security • Usage statistics: who uses what data, when and how • LDAP v3 • Data profiling information • Microsoft Active Directory 2003, 2008 Self-Service Message Queues • Last-mile data preparation wizards for customizing • MQSeries datasets by non-technical users • SonicMQ • Full-featured SQL shell facilitates the execution of • ActiveMQ complex queries • Tibco EMS • Export to CSV, Excel, and Tableau Data Extracts • Other JMS compatible services • Save personal queries for easy access • Query sharing features Semantic Repositories • Semantic repositories in Triple Stores / RDF accessed PERFORMANCE OPTIMIZATIONS through SPARQL endpoints. • Smart Query Acceleration for Analytics Packaged Applications • Aggregate Aware Summaries • SAP ERP/ECC (BAPIS and tables) • Massive Parallel Processing (MPP) integration • Oracle E-Business Suite 12 for Query Acceleration and Caching • Siebel • Full and partial aggregation and join pushdown, even • SAS (SAS JDBC Driver): 7 and higher in federated views • Support for alternative data sources Mainframe • On-the-fly data movement for optimization • IMS • Cost Based Optimization (data statistics, data source • IBM IMS native drivers: 8, 9 indexes, data source execution model and parameters, • IMS Universal Drivers: 11 network transfer rates) • Pushdown of selections/projections/joins/groupby Hierarchical Databases operations also on federated views • Adabas (SOA Gateway and Denodo’s SOAP • Multiple join strategies connector): 5, 6 • Simplifying partitioned unions (Partition pruning) • and many more Denodo SDK for Custom Connectors CACHE AND DATA MOVEMENT OPTIONS PUBLISHING OPTIONS • Multi-mode caching: full, partial, incremental, or total • SQL Based access via JDBC, ODBC and ADO.NET refresh, event-based or scheduled, configured at the • Web Services view level, incremental queries for SaaS sources • REST • Amazon Athena • OData • Azure SQL • Open API (a.k.a Swagger) • Azure SQL Data Warehouse • GraphQL • Azure Synapse Analytics • SOAP • Amazon Redshift • OAuth, OAuth 2.0 (JWT) • Databricks 2.x • SAML • Delta Lake • SSL • IBM DB2 ( 8, 9, 10, 11 for LUW, 9,10,11 for z/OS) • WS-Security • Hive 2.0.0 • JMS listeners for message queues • Impala • Denodo Scheduler for batch process and lite ETL • MS SQL Server (2000, 2005, 2008, 2008R2, 2012, © 2024 Denodo Technologies 62014, 2016, 2017) • MySQL (4 and 5) Encryption/Decryption • Netezza (6 and 7) • Support for custom decryption for files and web • Oracle (8i, 9i, 10g, 11g, 12c, 12c in-memory, 18c, 19c) services • Oracle TimesTen 11g • Transparent integration with RDBMs encryption • PostgreSQL (9 and 10) • Encrypted metadata import/export • Presto • SAP HANA User and Role Based including integration with AD/ • Snowflake LDAP • Spark (1.5,1.6 and 2.x) • Row and Column level authorization • Teradata (12, 13, 14, 15, and 16) • Advanced customizable masking • Vertica (7 and 9) • Custom policies for specific security constraints and • Yellowbrick integration with external policy servers • Configurable “generic” adapter for other databases with JDBC drivers Global Policies • Tag-based security policies DATA PIPELINES • Support for RBAC and ABAC • Column and row restrictions, multiple masking options, • Remote Tables (created through UI or stored deny execution procedure) • Denodo Scheduler Authentication • VQL stored procedures • Native and LDAP/Active Directory based Support for Kerberos and Windows SSO EMBEDDED MPP • Base64 • Kerberos • MPP engine based on Presto to accelerate access to • NTLM data lake • OAuth, OAuth 2.0 (JWT) • Graphical introspection of object storage (S3, ADFS, • SAML GFS, HDFS, etc.) • Two-factor authentication (through supported identity • Support for Parquet, Delta, and Iceberg providers: Okta, Duo, etc.) • New advanced optimization techniques to federate • SSL data lake content with any other data source • WS-Security • Pass-through session credentials to leverage existing THIRD-PARTY MPP OPTIONS source privileges • Impala ADVANCED SEMANTICS • Presto • Spark 1.5, 1.6, 2.x • Global security policies • Databricks 2.x • Tagging at column level • Support for the importing of external data governance DATA GOVERNANCE tags from Collibra and other external data catalogs • Data source refresh, change impact analysis, DATA MODELING dependency tree, full data lineage • Denodo Governance Bridge: integration with IBM • Design Studio: Web-based development studio for Information Governance Catalog data modeling • API to publish metadata and lineage information to • Desktop version also available data governance tools like Informatica EDC, Collibra, • Bottom-Up and Top-Down (through Interface Views) etc. • Integration with third-party modeling tool • ER/Studio Data Architect SECURITY • ERwin Data Modeler • IBM InfoSphere Data Architect Data in Motion – secure channels • SAP PowerDesigner • Using SSL/TLS • Client-to-Denodo and Denodo-to-source DATA QUALITY • Available for all protocols (JDBC, ODBC, ADO.NET and WS) • Library of transformation, filter and matching functions Data at Rest - secure storage and quality rules for validating, cleansing, enriching, • Cache: third party database. Can leverage its own standardizing, matching and merging data encryption mechanism • Extensible through Custom Functions • Swapping to disk: serialized temporarily stored in a • Integration with external DQ tools configurable folder that can be encrypted by the OS © 2024 Denodo Technologies 7MONITORING • Subversion • Microsoft TFS • Denodo Diagnostic and Monitoring Tool • Git (DMT) integrated in the Solution Manager • Resource Manager to limit and allocate resources • Extensible usage and metadata dashboards to each session, role or user in a way that optimizes integrated in Apache Superset resources utilization for each application • FinOps dashboard to monitor and understand key • Change resources priority metrics associated with cloud costs like egress, • Enforce limited timeouts or limits on number of rows query cost, etc. • Add daily quotas per minute/day/month: e.g. only 50 • Detailed monitoring information is available in logs queries per day for integration with log management tools like Splunk, ELK, Cloudwatch, etc. DEPLOYMENT PATTERNS • Monitoring is also available via SNMP and JMX standards. Therefore interoperate with most leading • On-premises, private cloud, public cloud Systems Management packages (e.g., HP OpenView, • On-premises, private cloud, public cloud Nagios, Zenoss, Osmius, IBM Tivoli and Microsoft • Basic single server configuration WinRM) • HA cluster with load balancing (Active-Passive and Active-Active) EMBEDDED AI • Shared or distributed local cache • Geographically distributed server environments Data Catalog • Multiple Denodo instances peer-to-peer or multi- • Natural language queries with genAI layered • Support for GPT, Azure OpenAI, AWS • Containerization support through Docker Bedrock and custom LLMs. • Public cloud • Personalized dataset recommendations • Denodo Platform for AWS • Smart SQL-fragment autocomplete based on previous • Denodo Platform for Azure activity • Denodo Platform for GCP • Denodo Platform for Alibaba Cloud Design Studio • Auto-scaling support both in AWS and Azure • Performance recommendations for Smart Query Acceleration using usage history OPERATING SYSTEMS OPERATIONS • Microsoft Windows (32-bit and 64-bit platforms): Windows Server 2019, Windows Server 2016, Windows • Solutions Manager to automate operations and Server 2012, Windows Server 2008, Windows 10, promotions tasks Windows 8.1, and Windows 7 • Centralized management and distribution of updates • Linux (32-bit and 64-bit platforms): Red Hat Enterprise to clients Linux (RHEL) 6 and 7, Oracle Linux 6 and 7, Ubuntu • Centralized management of license keys 12.04 LTS and 14.04 LTS, CentOS 6 and 7 • Define promotion revisions and their dependencies • Any Java 11 or greater compatible OS and deploy them to a production cluster with zero downtime MINIMUM HARDWARE REQUIREMENTS • Centralized management of data source properties and logs • REST API for automation of tasks from DevOps tools • Processor: Intel Xeon quad-core or similar. High-load (e.g. jenkins) scenarios or cases with complex calculations may • Integrated Infrastructure Management for Cloud (AWS) require 8 cores or more. • Creation and management of clusters: define type • Physical memory (RAM): 16 gigabytes of memory so the of EC2 instances, number of EC2 instances, etc. Denodo server can allocate a runtime heap space up • Creation of load balancers and Auto Scaling groups. to 8 gigabytes. • Installation and launch of the Denodo servers. • Disk space: Minimum: 5 gigabytes, Recommended: • Update of Denodo version 100 gigabytes. Denodo only needs around 1 GB of • Enable SSL in the Denodo servers. disk space. If the cache is installed on the same server, • Multi-User Development with Version Control more disk space will be required.. integration Visit www.denodo.com | Email info@denodo.com | Discover community.denodo.com
To view the full page, please visit: Denodo 9 Enterprise Plus Product Userguide

Denodo 9 Enterprise Plus

Denodo is the logical data management platform that integrates and delivers your data in real time without replication to get above the data silos.
Buy now