If your source data is in a single ODBC table or view, which is the case for most SQL/ODBC databases, then add a Simple ODBC source to your integrations.
The Add Source window opens.
The available Simple ODBC sources appear in the Sources pane.
If you select an existing Simple ODBC source, the source is added to your integration. You don’t need to set up the source properties.
If you are creating a new Simple ODBC source, the Properties window opens, allowing you to set the different properties of the Simple ODBC query. See the topic Setting up general properties for ODBC sources.
If you try to add an existing simple ODBC source to an integration that already contains ODBC/text queries, you are asked to create a relationship between the new and existing queries.