Data sources are the basis of data analysis in various fields such as information technology (IT) and data research and development (R&D). This topic describes four types of data sources that Quick BI supports: cloud data sources, user-created data sources, file data sources, and application 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 (for Quick BI Enterprise Standard and Quick BI Pro)
    • Hive (for Quick BI Enterprise Standard and Quick BI Pro)
    • OSS (for Quick BI Enterprise Standard and Quick BI Pro)
    • DRDS (for Quick BI Enterprise Standard and Quick BI Pro)
    • Presto (for Quick BI Enterprise Standard and Quick BI Pro)
    • AnalyticDB for MySQL 3.0
    • PolarDB for MySQL (for Quick BI Enterprise Standard and Quick BI Pro)
    • TSDB (for Quick BI Enterprise Standard and Quick BI Pro)
    • ApsaraDB for HBase (for Quick BI Enterprise Standard and Quick BI Pro)
  • User-created data sources: databases that are locally 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 (for Quick BI Enterprise Standard and Quick BI Pro)
    • Vertica (for Quick BI Enterprise Standard and Quick BI Pro)
    • IBM DB2 LUW (for Quick BI Enterprise Standard and Quick BI Pro)
    • SAP IQ (Sybase IQ) (for Quick BI Enterprise Standard and Quick BI Pro)
    • SAP HANA (for Quick BI Enterprise Standard and Quick BI Pro)
    • Presto (for Quick BI Enterprise Standard and Quick BI Pro)

Network requirements

When you add a data source, take note of the following network requirements:
  1. ApsaraDB for RDS instances in a VPC can access Quick BI by using a public domain name. However, only ApsaraDB for 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 for RDS instances in a classic network can access Quick BI by using either a public domain name or an internal domain name. Before you connect an ApsaraDB for RDS instance to Quick BI by using a public domain name, you must configure an IP address whitelist for the ApsaraDB for RDS instance. For more information, see Configure a whitelist.
  3. Quick BI is accessible from public networks.
  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

For more operations on data sources, see the following topics: