Source types
Source types define how data is read into AnalyticsCreator and how the source object behaves during import and processing.
Use this section to understand the available source types and choose the appropriate one for your source system and loading pattern.
Available source types
Query
Use a query source when the input should be defined by a custom SQL statement instead of a direct table reference.
- Custom query-based source definition
- Useful for filtered or pre-shaped input
- More flexible than direct table access
SAP DeltaQ
Use SAP DeltaQ when loading SAP extractor-based data with delta handling.
- SAP-specific source type
- Supports extractor-oriented loading scenarios
- Relevant for delta-based SAP integration
SAP_DELTAQ
SAP_DELTAQ is source type 3. It is used for SAP delta queue sources on SAP connectors.
Table
Use a table source when data should be read directly from a physical source table.
- Direct table-based import
- Typical default source type
- Suitable for standard relational loading
View
Use a view source when data should be read from a database view instead of a physical table.
- View-based source access
- Useful for predefined source abstraction
- Suitable when logic is already encapsulated in the source
How to choose a source type
- Use Table for standard relational source loading
- Use View when the source system already exposes the required structure through a database view
- Use Query when the source needs custom filtering or shaping before import
- Use SAP DeltaQ for SAP extractor scenarios with delta-oriented loading behavior
Key takeaway
Source types define how source data is accessed and should be selected based on the technical structure and loading behavior of the source system.
