博客
关于我
QuickBI助你成为分析师——搞定数据源
阅读量:186 次
发布时间:2019-02-27

本文共 2245 字,大约阅读时间需要 7 分钟。

Quick BI supports a variety of data source connections, and adding a data source is the first step in data analysis and visualization. The following is a detailed introduction to the product's data source support.

Quick BI is a cloud-based lightweight self-service BI tool platform that provides real-time analysis of large data, drag-and-drop operations, and rich visualization effects. It not only serves as a tool for business users to view data but also acts as an assistant for data-driven operations, solving the "last mile" problem for big data applications and enabling everyone to become a data analyst.

The core workflow of the product is illustrated in the following figure.

Quick BI seamlessly integrates with cloud databases, supporting multiple data sources including but not limited to MaxCompute, RDS (MySQL, PostgreSQL, SQL Server), Analytic DB, HybridDB (MySQL, PostgreSQL), ECS self-managed libraries, and local database connections. Below is a detailed overview of each data source.


Cloud Data Sources

Quick BI supports various cloud-based databases, including:

MaxCompute

  • The database address remains unchanged by default.
  • Ensure that the AccessId and AccessKey are configured with project-level admin or owner permissions for necessary privileges (e.g., select, list, create instance).

Cloud Databases

  • The product supports multiple RDS instances such as MySQL, PostgreSQL, and SQL Server.
  • Additionally, it supports Analytic DB and HybridDB (MySQL, PostgreSQL).

ECS Self-Managed Libraries

  • The product supports ECS self-managed database connections.
  • Note: ECS self-managed database cross-network connections are currently in development.

Local Databases

  • Local database connections require external IP addresses.
  • Ensure that the database is accessible via the external IP address.

Other Data Sources

  • Local Files: Supports Excel, CSV, and other file formats.
  • DataIDE Data: Supports data from DataIDE.

Note

  • Local file uploads are not supported in group spaces.

Quick BI is a powerful tool designed to help users easily visualize and analyze data. By supporting a wide range of data sources, it simplifies data integration and visualization, making it an excellent choice for businesses looking to leverage cloud-based analytics.

转载地址:http://mnrb.baihongyu.com/

你可能感兴趣的文章
python中函数接受参数为*args, **kwargs怎么办
查看>>
Python中切片的高效迭代
查看>>
python中列表乘法、eval、lambda、hasattr、assert、*(星)等的用法
查看>>
Python中制作词云的WordCloud参数详解
查看>>
Python中可用和使用的系统内存?
查看>>
python中存根文件(.pyi)的用途是什么?
查看>>
Python中实现ASCII码与字符相互转换
查看>>
Python中实现获取所有微信好友的头像并拼接成一张图片
查看>>
Python中对象的布尔值
查看>>
python中对集合的操作
查看>>
python中将列表转换为元组的时间复杂度,反之亦然
查看>>
Python中布尔表达式的求值
查看>>
python中很常用的10个内置函数整理(初学必备)
查看>>
python中打印二维列表数据
查看>>
python中打散数组shuffle
查看>>
Python中执行外部命令
查看>>
Python中拼接numpy数组-ChatGPT4o作答
查看>>
Python中提示:no module named 'PIL'
查看>>
Python中提示:UnicodeDecodeError: 'ascii' codec can't decode byte 0xe5 in position
查看>>
python中数据类型存储_浅谈Python中的数据类型
查看>>