Ranjithkumar
Engineer
Engineer
  • UID5737
  • Fans4
  • Follows3
  • Posts129
Reads:62589Replies:3

Quick BI

Created#
More Posted time:Aug 9, 2018 15:43 PM
Can we able to write custom SQL to pull the data from the data source?

GhulamQadir
Senior Engineer
Senior Engineer
  • UID5968
  • Fans4
  • Follows0
  • Posts98
1st Reply#
Posted time:Aug 10, 2018 0:12 AM
@Ranjithkumar


While Setting up Quick BI with ApsaraDB for RDS, You can connect Your Database (MySQL, SQL Server, Analytic DB, Hybrid DB for SQL, Hybrid DB for Postgre SQL, Postgre SQL, PPAS) and use your own queries.


Also there is an option to upload your local files in a format of (CSV, Excel Files and DATA IDE), Click Me to Download Uploading format.

Hope this will help you.

Ranjithkumar
Engineer
Engineer
  • UID5737
  • Fans4
  • Follows3
  • Posts129
2nd Reply#
Posted time:Aug 10, 2018 15:50 PM
GhulamQadir:@Ranjithkumar


While Setting up Quick BI with ApsaraDB for RDS, You can connect Your Database (MySQL, SQL Server, A...
回到原帖
@GhulamQadir, Thanks for sharing the information. Yes, you can write custom queries to pull data when we are using RDS. But I need a way to pull data using SQL from the data source without adding another service to my bucket.

Ranjithkumar
Engineer
Engineer
  • UID5737
  • Fans4
  • Follows3
  • Posts129
3rd Reply#
Posted time:Aug 10, 2018 15:52 PM
GhulamQadir:@Ranjithkumar


While Setting up Quick BI with ApsaraDB for RDS, You can connect Your Database (MySQL, SQL Server, A...
回到原帖
Yeah, they have an option for local files that too in personal space alone...I need to connect DB and have to pull data from multiple tables to form a single dataset which could be easily done on many BI tools
Guest