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

你可能感兴趣的文章
Postman如何生成接口文档
查看>>
Postman学习之常用断言
查看>>
postman居然是用electron开发的,我们来认识下这个框架吧
查看>>
postman常用公共函数
查看>>
Postman被低估的功能 — 自动化接口测试
查看>>
Postman轻松签名,让SHA256withRSA保驾护航
查看>>
Postman还能做Mock?又学了一招!
查看>>
Postman还能做Mock?又学了一招!
查看>>
Postman高阶技能:Collection集合批量运行!
查看>>
postMessage跨标签页共享数据
查看>>
Post表单提交TextArea的值出现转译乱码问题 - Spring MVC处理表单提交
查看>>
Power BI 中的 Python 可视化需要什么设置?任何特定的 matplotlib 包版本或系统设置?
查看>>
Power BI:如何在 Power Query 编辑器中将 Python 与多个表一起使用?
查看>>
power english (3) main text -emotion mastery - focus
查看>>
POWER ENGLISH (6) - MODEL
查看>>
power english (1) —— passion
查看>>
Power English (1) 原文
查看>>
power English (3)原文
查看>>
POWER ENGLISH(7)- repetition
查看>>
PowerDesigner使用教程:设置注释、默认值属性
查看>>