Source
Overview
A Source represents an external object that can provide data to AnalyticsCreator through a connector.
A source can describe a table, view, query, file, SAP delta queue, or another connector-specific object.
Function
Use source entities to maintain source structure, columns, constraints, references, grouping, and connector-specific query or path information.
Sources can be refreshed from the external system and then used as inputs for imports or transformations.
Types
The source type determines how AnalyticsCreator reads metadata and previews or processes source data.
| Type | Use |
|---|---|
| Table source | Represents a physical table exposed by the connector. |
| View source | Represents a source-system view. |
| Query source | Uses a stored query or connector-specific statement as the source. |
| SAP delta queue | Represents a supported SAP delta queue source. |
| File or external source | Represents a connector-specific file, sheet, endpoint, or external object. |
Attributes
Attributes define the configuration, behavior, and relationships of the source entity.
| Attribute | Applies to | Description |
|---|---|---|
| Name | All source types | Technical source name displayed under its connector. |
| Source schema or group | Applicable sources | Organizes the source within the external system or navigation tree. |
| Source type | All source types | Identifies whether the source is a table, view, query, delta queue, file, or another connector-specific object. |
| Query or path | Query and file sources | Defines the statement, path, or endpoint used to read the source. |
| Columns | All structured sources | Column metadata read from or defined for the source. |
| Constraints | Applicable structured sources | Source constraints discovered or maintained for the source. |
| References | Applicable structured sources | Relationships between the source and other source entities. |
How it is used in AnalyticsCreator
| Use case | Description |
|---|---|
| Read source metadata | Define a source manually or read its structure from the connected system. |
| Refresh structure | Detect and apply changes to source columns and metadata. |
| Preview source data | Inspect supported source data before building processing logic. |
| Create imports | Use the source as the input side of an import definition. |
| Build transformations | Use the source as an input object in transformation logic. |
Relationships
| Related entity | Relationship |
|---|---|
| Connector | A source belongs to one connector. |
| Source column | A source contains source columns. |
| Source constraint | A source can contain discovered constraints. |
| Source reference | A source can participate in source-to-source references. |
| Table | An import can map a source to a warehouse table. |
| Transformation | A source can be used as a transformation input. |
Where to configure
Configure or review this entity from the matching AnalyticsCreator user-interface area.
