Supported data sources
QuickSight supports broadly three types of data sources: relational, file, and SaaS. For relational sources it supports Athena, RDS, Redshift, MySQL, and SQL Server sources. For file sources, it supports Excel, CSV, and common log formats in S3. For SaaS it supports Salesforce.
Before we explore data sources, I would like the readers to get familiar with QuickSight concept of data source and dataset. A data source identifies sources like relational database, S3 filesystem, and SaaS system like SAP. A dataset identifies specific data in a data source, for example, a table is a dataset in a RDBMS data source. A dataset is imported into SPICE for fast access.
Now let's explore the list of supported data sources using the following steps:
From the QuickSight home page click on Manage data, which will show a list of existing datasets and a summary of your current SPICE utilization, as shown in the following screenshot:
Figure 2.2: Adding a new dataset
Next from this page ...
