Shulou(Shulou.com)05/31 Report--

This article focuses on "what are the data sources supported by Quick BI". Interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn "what are the data sources supported by Quick BI"?

Quick BI painstakingly built the core technology base (OLAP analysis engine), realized SQL parsing, SQL scheduling, SQL optimization, query acceleration and other basic capabilities, supporting Quick BI data analysis and query acceleration. OLAP analysis engine includes five core capabilities: data source connection, data model, intelligent query routing, general query and accelerated query. Today, the editor will give you a detailed introduction on the data source connection ability of Quick BI!

Which data sources are supported: supporting 24 kinds of data sources is the management function of Quick BI to connect to the business database, and it is the basic preparation of data analysis. Quick BI data source, only do data source connection, SQL task analysis and scheduling, all the data are stored in the original data all the database, Quick BI does not do any data replication. Quick BI supports 24 data sources, including 14 Ali cloud databases and 10 local databases, while the API data source interfacing capability is still under construction. 1) the supported Ali cloud database Quick BI, as a BI product on Ali Cloud, is seamlessly compatible with the database on Ali Cloud. We support 14 databases such as MaxCompute, MySQL, SQL Server, AnalyticDB for MySQL 2.0, HybridDB for MySQL, AnalyticDB for PostgreSQL, PostgreSQL, PPAS, Data Lake Analytics, Hive, DRDS, Presto, AnalyticDB for MySQL 3.0, PolarDB for MySQL, etc. 2) the supported local databases support 10 kinds of databases, such as MySQL, SQL Server, PostgreSQL, Oracle, Hive, Vertica, DB2, SAP IQ (Sybase IQ), SAP HANA and Presto. 3) Hadoop database supports connections to data sources based on Hive 2.0 or above. Currently, data connection methods such as Spark and Spark Sql are not supported. 4) support MPP database to support the connection of data sources based on PostgreSQL and Greenplum. PostgreSQL supports version 8.2 or later. The compatibility of Greenplum needs to be based on PostgreSQL version 8.2 or above.

Data source connection configuration: adapts to local, cloud, cross-VPC and other data sources

How to configure Ali Cloud Database connection if you purchased the Quick BI version on Ali Cloud, you can connect to the cloud database directly. No matter which Region database, it can be accessed directly through the private network without other network traffic charges. Take MySQL as an example to give you an introduction.

1) enter the data source configuration management interface and select MySQL data source

2) configure the data source connection information, fill in the database address, port, database name, user name and password, test the connection and save it. Before configuring a database connection, configure the database whitelist policy first to avoid failing the database connection test.

3) if the VPC environment database connection is HybridDB for MySQL and is a VPC environment, then you need to configure the VPC environment information. As follows:

How to configure the local database connection the local database connection can be configured as long as the network connectivity is ensured. Take Oracle as an example, configure the corresponding database address, port, database, Schema, and user-level password.

How to realize cross-cloud database connection

Quick BI implements the way of connecting data sources based on SSH Tunnel, and SSH port forwarding is a mechanism of SSH, which is used to tunnel application ports from client to server. Sometimes we cannot access a database directly because there is no authorization or ip restrictions, but we can access it by logging in to other machines. If the server has SSH installed, we can access the database by proxy through the port mapping of the service. If we buy the database on Amazon cloud and Microsoft cloud, and do not want to access the database through the public network, then we can consider this way to implement. Take MySQL as an example to introduce the connection method of SSH Tunnel. In addition to entering the connection information of the database, you need to enter the account, password, port and other information of the server corresponding to SSH.

At this point, I believe you have a deeper understanding of "what are the data sources supported by Quick BI?" you might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.