What is a Data Source?

A Data Source is a SQL select statement applied to a single database that defines a complete set of data that can be used by the Portal. One or more Data Sources can be created and used in the Portal.

Data Source SQL statements are often written to include all data from a table. For example: SELECT * FROM table.

Data Sources may also be complex SQL statements that build a data set from multiple schemas or tables in the database.

Interacting with Data Sources

Blocks can leverage data served up by any of the Data Sources in the Portal.

Below is an example using a Data Table block.

The Data Table block is configured to use all of the columns (*) from the orders Data Source.

Here's the resulting block: