Quick BI supports the following types of data sources.

Cloud data sources

  • MaxCompute
  • MySQL
  • SQL Server
  • AnalyticDB
  • HybridDB for MySQL
  • HybridDB for PostgreSQL
  • PostgreSQL
  • PPAS
  • Hive (Quick BI Enterprise Standard)
  • Data Lake Analytics (Quick BI Enterprise Standard and Pro)
  • OSS (Quick BI Enterprise Standard)
  • DRDS (Quick BI Enterprise Standard)

User-created data sources

  • MySQL
  • SQL Server
  • Oracle
  • PostgreSQL
  • Hive (Quick BI Enterprise Standard)
  • Vertica (Quick BI Enterprise Standard)
  • IBM DB2 LUW (Quick BI Enterprise Standard)
  • SAP IQ (Sybase IQ) (Quick BI Enterprise Standard)
  • SAP HANA (Quick BI Enterprise Standard)

User space

  • CSV files
  • Excel files
  • Data IDE

Local files are uploaded and stored in the user space. Only Quick BI provides user spaces. Currently, each user has a user space of 1 GB.

Network requirements for data sources

Quick BI has the following network requirements for data sources.
  1. Quick BI can connect to RDS instances in a VPC by using public IP addresses. MySQL and SQL Server instances can be connected by using private IP addresses.
  2. Quick BI can connect to instances in a classic network by using both public and private IP addresses. When Quick BI connects to RDS instances by using public IP addresses, set a whitelist of IP addresses that are allowed to access RDS instances in the RDS console. For more information, see Set a whitelist.
  3. Quick BI can be accessed on the public network.
  4. Quick BI can connect to user-created MySQL and SQL Server databases on ECS instances in a VPC by using private IP addresses.

More operations