博客
关于我
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/

你可能感兴趣的文章
OpenCV与AI深度学习 | 基于深度学习的轮胎缺陷检测系统
查看>>
OpenCV与AI深度学习 | 实战 | OpenCV传统方法实现密集圆形分割与计数(详细步骤 + 代码)
查看>>
OpenCV与AI深度学习 | 实战 | OpenCV实现扫描文本矫正应用与实现详解(附源码)
查看>>
OpenCV与AI深度学习 | 实战 | 使用YOLOv8 Pose实现瑜伽姿势识别
查看>>
OpenCV与AI深度学习 | 实战 | 使用YoloV8实例分割识别猪的姿态(含数据集)
查看>>
OpenCV与AI深度学习 | 实战 | 基于YoloV5和Mask RCNN实现汽车表面划痕检测(步骤 + 代码)
查看>>
OpenCV与AI深度学习 | 实践教程|旋转目标检测模型-TensorRT 部署(C++)
查看>>
OpenCV与AI深度学习 | 干货 | 深度学习模型训练和部署的基本步骤
查看>>
OpenCV与AI深度学习 | 手把手教你用Python和OpenCV搭建一个半自动标注工具(详细步骤 + 源码)
查看>>
OpenCV与AI深度学习 | 深度学习检测小目标常用方法
查看>>
Opencv中KNN背景分割器
查看>>
OpenCV中基于已知相机方向的透视变形
查看>>
OpenCV中的监督学习
查看>>
opencv中读写视频
查看>>
opencv之cv2.findContours和drawContours(python)
查看>>
opencv之namedWindow,imshow出现两个窗口
查看>>
opencv之模糊处理
查看>>
Opencv介绍及opencv3.0在 vs2010上的配置
查看>>
OpenCV使用霍夫变换检测图像中的形状
查看>>
opencv保存图片路径包含中文乱码解决方案
查看>>