Typically, IT personnel and data engineers analyze data based on data sources. Quick BI supports cloud data sources and user-created data sources. This topic describes these data sources.

Supported data sources

  • Cloud data sources: databases that are deployed in Alibaba Cloud
    • MaxCompute
    • ApsaraDB RDS for MySQL
    • ApsaraDB RDS for SQL Server
    • AnalyticDB for MySQL 2.0
    • HybridDB for MySQL
    • AnalyticDB for PostgreSQL
    • ApsaraDB RDS for PostgreSQL
    • ApsaraDB RDS for PPAS
    • Data Lake Analytics (supported in Quick BI Enterprise Standard and Quick BI Pro)
    • Hive (supported in Quick BI Enterprise Standard and Quick BI Pro)
    • Object Storage Service (OSS) (supported in Quick BI Enterprise Standard and Quick BI Pro)
    • Distributed Relational Database Service (DRDS) (supported in Quick BI Enterprise Standard and Quick BI Pro)
    • Presto (supported in Quick BI Enterprise Standard and Quick BI Pro)
    • AnalyticDB for MySQL 3.0
    • PolarDB for PostgreSQL
    • PolarDB for MySQL (supported in Quick BI Enterprise Standard and Quick BI Pro)
    • Time Series Database (TSDB) (supported in Quick BI Enterprise Standard and Quick BI Pro)
    • ApsaraDB for HBase (supported in Quick BI Enterprise Standard and Quick BI Pro)
    • ClickHouse (supported in Quick BI Enterprise Standard and Quick BI Pro)
  • User-created data sources: databases that are created by users
    • MySQL database hosted on an ECS instance
    • SQL Server database hosted on an ECS instance
    • PostgreSQL database hosted on an ECS instance
    • Oracle
    • Hive (supported in Quick BI Enterprise Standard and Quick BI Pro)
    • Vertica (supported in Quick BI Enterprise Standard and Quick BI Pro)
    • IBM DB2 LUW (supported in Quick BI Enterprise Standard and Quick BI Pro)
    • SAP IQ (Sybase IQ) (supported in Quick BI Enterprise Standard and Quick BI Pro)
    • SAP HANA (supported in Quick BI Enterprise Standard and Quick BI Pro)
    • Presto (supported in Quick BI Enterprise Standard and Quick BI Pro)
    • GBase (supported in Quick BI Enterprise Standard)

Network requirements

When you add a data source, take note of the following network requirements:
  1. ApsaraDB RDS instances in a VPC can access Quick BI by using a public domain name. However, only ApsaraDB RDS instances that run the MySQL or SQL Server engine in a VPC can access Quick BI by using an internal domain name.
  2. ApsaraDB RDS instances in the classic network can access Quick BI by using either a public domain name or an internal domain name. Before you connect an ApsaraDB RDS instance to Quick BI by using a public domain name, you must configure an IP address whitelist for the ApsaraDB RDS instance. For more information, see Configure a whitelist.
  3. Quick BI is accessible from the Internet.
  4. User-created MySQL or SQL Server databases hosted on an ECS instance in a VPC can access Quick BI by using an internal domain name.

More operations