In single-tenant data warehouses, you can load the tables from each data source into one of the following data warehouse SQL schemas:
The default schema (typically the dbo schema).
Or into their dedicated data warehouse (dw) schema. Loading them into their own schema can facilitate user security, and segmentation of data warehouse tables by data source. Set up this option by selecting a data source, clicking the Properties icon, checking the “Dw Schema” checkbox (see example below), editing the source Alias if needed(which also defines the schema name), and clicking Save or Connect. Now this source’s tables will load into the dw schema = source’s Alias.
For more about specific sources see
For even more technical information about each source type see
About ODBC data sources A [ODBC] data source is a source of data combined with the connection information that is required to access that data. Examples of data sources are SQL Server, Oracle RDBMS, a spreadsheet, and a text file. Examples of connection information include server location, database name, logon ID, password, and various ODBC driver options that describe how to connect to the data source. This information can be obtained from the administrator of the database to which you want to connect.