For more technical pages about specific data sources see Source Systems and IT

See also ETL+ Data Sources | Data-Source-Drivers below


Configuring an Existing Data Source

Reconfigure the settings of an existing data source in the ETL Source panel.

Changing an Existing Data Source Type

Use case: You open the Properties of a data source (see screenshot below) and it shows a MS SQL Server source. However, you want it to connect to an ODBC or Excel instead.

Then click the Change Data Source icon (wrench icon) and select your new data source type.

Adding Data Sources

Use the ETL Source panel on the ETL+ Extract, Transform and Load (ETL) Page to add and manage data sources.

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.

Data Source Drivers

Please contact us to learn more about ways we can efficiently extract data from your sources.

Links to knowledge base pages on connecting to a variety of data sources

Links to knowledge base pages on connecting to a variety of data sources

✅ v2022.08