From the course: Learning Amazon Web Services (AWS) QuickSight

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Connecting to corporate data sources

Connecting to corporate data sources - AWS QuickSight Tutorial

From the course: Learning Amazon Web Services (AWS) QuickSight

Start my 1-month free trial

Connecting to corporate data sources

“

- [Instructor] Let's take a look at an organization that leverages its own data sources on premises, like SQL server or Oracle databases. AWS refers to these connections as corporate data sources. In order to run a query or refresh data from SQL Server, you do need to have access to the database source outside of AWS. You can run SQL queries on these database connections. You can also connect to the relational table separately. Then later use QuickSight joining capabilities to join them together, or to join them to data tables from other data sources. It's best to create the query and SQL editor tool to test out that it works before bringing it into QuickSight. To set up a SQL Server connection, let's start at our dataset page where we see our existing data connections. To add another data source, we select new dataset at the top left. Next we scroll down in the data source options, and select the SQL Server tile. This…

Contents