Quick BI supports the following types of data sources:

Cloud data sources:

  • MaxCompute
  • MySQL
  • SQL Server
  • Analytic DB
  • HybridDB for MySQL
  • HybridDB for PostgreSQL released
  • PostgreSQL
  • PPAS
  • Hive (Quick BI Pro)

External database data sources

  • MySQL
  • SQL Server
  • Oracle
  • PostgreSQL
  • Hive (Quick BI Pro)
  • Vertica(Quick BI Pro)
  • IBM DB2 LUW(Quick BI Pro)

Exploration space

  • CSV file
  • Local Excel files
  • Data IDE

Uploaded local files are stored in the exploration space. The exploration space is a dedicated storage area of Quick BI, providing 1G space for each user currently.

When creating data sources, the Quick BI has the following requirements for the network type of data sources.
  1. The VPC RDS instance can access Quick BI by using an extranet domain name. MySQL and SQL Server instances can access Quick BI by using an intranet domain name, other VPC RDS instances can't access Quick BI by using an intranet domain name.
  2. The instances in the classic network can access Quick BI by using an extranet domain name and an intranet domain name. When you access Quick BI by using an extranet domain name, you should set the IP address whitelist on the RDS. For more information, see Set whitelist.
  3. Quick BI can be accessed by using the public network.
  4. MySQL and SQL Server built on a VPC ECs instance can access quick Bi via the internal network domain name.