The Denodo Platform is the only data virtualization platform in the industry that includes an active data catalog for semantic search and enterprise-wide data governance, industry-leading smart query acceleration powered by AI, automated cloud infrastructure management for multi-cloud and hybrid scenarios, and embedded data preparation capabilities for multi-cloud and hybrid scenarios.
This tutorial covers a wide range of Denodo Platform features. We'll start with an overview of fundamental definitions like what is Denodo and why the Denodo platform is used and then will explore the topics of Data Virtualization, Data Services, integrating big data system to Denodo platform, implementing agile BI for Data Virtualization, what are 3C principles of Denodo, and how to create and deploy the web services.
Let’s go through the Denodo concepts in detail.
Denodo Express is Denodo Technologies, Inc.'s newest product, a free data virtualization utility with a graphical user interface-based studio. Denodo Express connects to and integrates structured, unstructured, and big data sources on-premises and in the cloud. End-users have access to these sources, as well as enterprise apps, dashboards, portals, Intranet, search, and other tools.
Take your career to next level in Denodo with HKR. Enroll now to get Denodo Certification Course Training!
The Denodo Platform offers breakthrough performance in big data, logical data warehouses, and operational scenarios; it accelerates adoption via cloud data virtualization. It streamlines business users’ data through self-service data discovery and searches.
3.1 Why data virtualization?
Data virtualization produces a single virtual layer that connects different data and allows consuming apps to have uniform access to it. These apps will take advantage of the virtual layer's semantic components and reuse them as necessary. Your applications would be independent of the physical sources where the data is kept in this manner.
[Related Blog: Denodo Data Virtualization]
The Denodo Platform offers the following features:
3.2 Installation & Bootstrapping
This section explains the prerequisites for utilizing Denodo, and also how to configure your Denodo setup and get started with Data Virtualization.
3.3 Initial Steps
The following are the first steps in using the Denodo Platform, which cover the most fundamental functionality:
3.4 Advanced Operations
You'll combine the unified customer view you've created with this billing information in this section to create a report that shows the total amount due for each of your clients.
3.5 Using your application to connect
The Denodo Platform is built on a client-server model, in which clients send requests to the server. One of the following interfaces could be used to send these requests:
Several methods for accessing Denodo from outside apps are discussed in this section:Using a JDBC Client via a Third Party.
3.6 Performance of an Agile
Data through users. ItAfterata Virtualization software accesses and pulls data from target sources at runtime, then blends it in real-time to provide the desired outcome. Denodo is too vital, although not exclusive, part of any data management architecture. When assessing performance, it's critical to determine which elements constitute bottlenecks.
The Data Services layer is an abstraction layer that can supply data to various users on an enterprise-wide scale. Using the views in the virtual layer, Data Virtualization software can quickly develop new Data Services. A uniform, consistent, and scalable data services infrastructure is required in many projects.
What are the most prevalent problems that these services encounter?
Advantages of a Data Services layer
An interface is a form of view in Denodo that consists solely of the description of fields and their data types. The most typical application is in a top-down design, where you create the fields first and then associate the interface implementation(data).
SOAP Web services
Web services are software solutions that enable interoperable machine-to-machine communication via the internet. SOAP Web services would be covered in this section. To exchange messages, these Web services employ the SOAP (Simple Object Access Protocol) protocol. The messages are as follows, according to the specifications:
REST Web services
As you may know, Web services are software solutions that enable interoperable machine-to-machine communication over a network. In this section, we'll discuss REST Web services, which are different kinds of Web services. This type of service communicates through HTTP and uses the REST (REpresentational State Transfer) architectural style as the messaging protocol.
Publish Web services
The Web Container Status Window in the Denodo Administration Tool is used to manage REST and SOAP services. To bring up this window in the workspace, go to Tools > Web services container in the menu bar. A table will appear in the Administration Tool, listing the Web services generated in a certain Denodo Database.
Invocation of services
REST services work in the same way as RESTful services, however, you only have access to the views built with this REST service in this case. A SOAP client is used to call SOAP Web services.
Change Web service Implementation
It's to make a derived view and use it to implement the i_client_info interface. You'll set up the i_client_info interface to utilize client_info_impl as its implementation view in this section.
The marketing department compiles a list of possible new clients on a regular basis. An Apache Hadoop distribution is in place to process the input data and produce the needed outputs in order to construct this list of prospects. You'll learn how to integrate a Big Data system into the Denodo Platform in this section.
Using Hive for creating JDBC Data Source
Apache Hive is a piece of software that makes querying and handling massive datasets in distributed storage easier. HiveQL is a SQL-like language that allows you to project structure onto this data and query it.
Connecting to Other Big Data systems
This explains using Denodo Platform 8.0 to access various Big Data platforms. Because Denodo Platform connects to so many different data sources, the following list is the best options that are used for connecting to these systems from Denodo Platform:
Using the REST API for Accessing HCatalog
HCatalog is a Hadoop table and storage management layer that makes reading and writing data easier. Users can get a relational view of their data on HDFS with HCatalog, and they don't have to worry about where or how their data is stored.
Denodo Agile BI will go through the basics of leveraging Data Virtualization tools, as well as how the Denodo Platform analyzes enterprise data for operational insight. This article will demonstrate the key advantages of adopting Data Virtualization rather than connecting BI tools directly to data sources.
Agile BI we'll go through the following stages:
Traditional methods to business intelligence sometimes result in the same logic being built over and over again across many BI and Reporting systems in order to generate similar results. The business logic required to build all of the reports will be centralized by the Data Virtualization layer, allowing it to be simply maintained and modified, as well as easily shared with a range of external BI tools without having to duplicate code across them.
Connecting to Data Sources
All data is organized into a unified perspective of marketing promotion performance. This is how the procedure will go:
Combining the data
We can begin combining all of the data now that we have the data sources and base views in place. The first step is to create a denormalized, standardized view of each data source so that we can create a set of foundation business entities from which we may build more complex reports later.
Publishing the data for clients
This BI tool connects to Denodo through ODBC and sends regular SQL queries. Denodo automatically delivers all views (base and derived) over JDBC and ODBC by default; we just need to perform manual publishing procedures when establishing web services.
Using a BI tool
A client tool is used to access the views we developed in the Denodo Platform. We'll use Tableau, however, Denodo may be accessed using the JDBC, ODBC, or Web Services interfaces by any standard tool.
Data virtualization is a layer that allows organizations to integrate real-time data from multiple sources and make it available to them without exposing any technical details (e.g., data center, database, data source, data structure, etc.). Denodo's approach is based on the "Three Cs principle."
Let's have a look at Denodo's 3 Cs implementation in practice after finishing the installation of Denodo installation.
1) After installation, open the Denodo Admin Tool.
2) Connect to the Denodo Admin Tool by logging in, providing login credentials, and clicking "connect." On the admin tool, you should be able to see the landing view (as shown below).
Note: Denodo's default databases are Admin and itpilot. You should keep them instead of deleting them.
3) The best method to get started on a new project is to build a new database. Go to Menu -> Administration -> Database management -> New to create a new database.
4) Denodo's nomenclature is split into layers — Derived View, Web Service, Data Source, Base View. Create these folders with the specified nomenclature in the new database (Right-click on database name-> New-> Folder). This will make it easier to maintain the various elements based on their functions.
Let's take a look at Denodo's first C Principle, which is "Connect." To connect to the desired data source, we'll construct a data source here.
Steps for Creating a Data Source
Note: We've only dealt with relational data sources so far, but Denodo also supports files, NoSQL databases, APIs, and other data sources.
The second key C premise is this. In this section, we'll learn how to make a base view. The base view would connect to the data source created in “Connect” and give a variety of operations on Base Views that can be used to generate Derived Views.
Steps for Creating a Base View
Steps for Testing the Base View
Note: Derived Views could be built by querying one or multiple Base Views after the Base View has been created.
Derived Views are simple views produced by combining single/multiple Base Views with various operations like JOIN/UNION/MINUS, and so on.
Steps for Join Operation
Aside from the JOIN operation, Denodo offers a variety of other relational operations: SELECTION, AGGREGATION, UNION, PROJECTION, FLATTEN, MINUS/INTERSECTION
Using the same steps as before, new views can be generated by Right-click-New Operation.
This is Denordo's third important C principle. The adoption of this idea would provide real-time data to business users/enterprise applications.
Let's examine how Denodo plans to make the data available to users. Denodo is a company that focuses on client-server architecture. It offers an ODBC interface, JDBC drivers, RESTful Web Services (with HTML, XML, JSON outputs).
Now you will see how to use Denodo's RESTful Web services. Denodo's web services are built on REST (Representational State Transfer) architecture principles and use HTTP.
We hope this tutorial is very useful to you and with this, you have mastered the concepts of implementing the 3 C’s principles of Denodo to connect, combine and consume. Initially, we have covered the concepts like basics of Data Virtualization and its operations, the data services like REST and SOAP, and other Big data and Agile BI so as to make you understand it from scratch.
Batch starts on 20th Oct 2021, Weekday batch
Batch starts on 24th Oct 2021, Weekend batch
Batch starts on 28th Oct 2021, Weekday batch
5th April | 08:00 AM