# Denodo Research

使用者模式

**1. Hardware Requirements**

Processor - 8 cores or more.

Memory- 16g of so the Virtual DataPort can allocate a runtime heap space of up to 8 gigabytes.

Disk space Recommended: 10 gigabytes free

**2. Software Requirements**

- Supported Operating Systems
- Windows: Windows Server 2019, Windows Server 2016, Windows Server 2012, Windows Server 2008, Windows 10.
- Linux: Amazon Linux & Amazon Linux 2, Ubuntu 12.04 LTS or later, CentOS 8.x, 7.x and 6.x, Red Hat Enterprise Linux (RHEL) 8.x, 7.x and 6.x, Oracle Linux 8.x, 7.x and 6.x, SUSE Linux Enterprise 12.x

- Supported Browsers
- Chrome 62.x, Microsoft Edge 41.x and Mozilla Firefox 57.x.

- Software Requirements for ITPilot
- Browser pool: Microsoft Internet Explorer 10.x or 11.x to use the component Browser Pool.
- Adobe Acrobat Professional 9 or 10 to extract data from PDF files using the Adobe PDF engine.
- Apache OpenOffice 4.0.x or 4.1.x to extract data from Microsoft Word files.

Unattended Installation of the Denodo Platform-
https://community.denodo.com/docs/html/browse/8.0/platform/installation/unattended_installation_of_the_denodo_platform/unattended_installation_of_the_denodo_platform

**3. New Features of the Solution Manager 8.0**

Solution Manager now can automate the deployment of the Denodo Platform on Amazon AWS

- Automated Deployments
- Creation and management of clusters: choose the type of EC2 instance, number of EC2 instances in the cluster, etc.
- Creation of load balancers and Auto Scaling groups.
- Installation and launch of the Denodo servers.
- Installation of Denodo updates on clusters with several servers, without downtime.
- In Denodo 8.0 GA, enable SSL in the Denodo servers.
- Solution Manager automates on Amazon AWS but **Azure is not**

- Single Point of Access
- Solution Manager now can work as the single point of access to these applications of Denodo:Data Catalog, The new Design Studio, Scheduler, Diagnostic & Monitoring Tool

---
## Authentication and Authorization

- New Authentication Protocols and Single Sign-On
- Solution Manager can be integrated with many identity providers with the new support for these authentication protocols:SAML 2.0, OAuth 2.0, OpenID, Kerberos

- Privileges System Extended
- provides more fine grained privileges that allow the administrators to control what tasks users can do over each environment.

- Unified User Interface to Manage Roles and Privileges
- manage the authentication and authorization of users from the Solution Manager Administration Tool. That is, from this tool, you can create users and roles, assign and revoke roles to users, enable Kerberos authentication, change LDAP settings, etc.

---
# Data Virtualization Basics

## Creating Data Sources and Base Views

JDBC databases
ODBC sources
SOAP web services
Multidimensional databases
XML files
JSON files
Delimited files like CSV files
Excel files
Denodo ITPilot wrappers that extract data from web sites
LDAP servers
SAP BAPIs
Salesforce.com
Custom sources developed using the Denodo API

## 前置作業

瀏覽器建議使用Chrome，因為沒辦法確定Server上的IE權限是否有受到影響
完成任何步驟後，都須關閉程式重開，否則資料不會更新

## 需求測試
SQL Server, JDBC, ODBC(OK)
csv等文字檔(中文標頭讀取問題)

# 資料載入


# 資料聚合

other relational operations:
UNION
EXTENDED UNION ALL
PROJECTION
SELECTION
AGGREGATION
MINUS/INTERSECTION
FLATTEN

## Tree View

# Data Services

## Defining contracts/interfaces

*這裡存檔時會彈出警告，可以忽略不理

## SOAP (Simple Object Access Protocol)

- Formatted using XML.
- Typically conveyed using HTTP (but FTP, SMTP or JMS can be used too).
- Described using WSDL files (Web Services Description Language: an XML-based language used to describe the functionality offered by the Web service).

開啟Virtual Data Port
將剛剛的內容拖曳到目錄底下

## REST (REpresentational State Transfer)

- The primary purpose of REST is to manipulate representations of Web resources using a uniform set of stateless operations.
- It does not require XML-based protocols (like SOAP and WSDL) to support its light-weight interfaces.
- It defines a set of operations using predefined HTTP verbs (GET, PUT, POST, or DELETE).
- The format of the information returned (representation) is typically HTML, XML or JSON, although it may be an image, plain text, or other format.

# Agile BI
Publishing the data for clients

# Workload Management
Resource Manager

## Add higher priority to admin queries
## Limit the number of rows returned
## Change the concurrent requests limit