Imports
The Imports feature in AnalyticsCreator manages the staging and data extraction configuration for source tables. It defines which tables are imported, their package association, and runtime behaviors like statistics updates or logging. This interface is central for managing ETL import definitions.
Function
Imports define how and when data is extracted from source systems. Each import entry specifies the source table, target package, and optional settings like logging or statistics update. This ensures clean and consistent data movement into the data warehouse.
Access
Imports can be accessed via the DWH > Imports section. The List screen displays all import definitions and allows filtering, editing, or creating new import entries.
List Imports
The image below shows the List Imports interface with columns labeled for easy identification.
List Screen Properties
| ID | Property | Description |
|---|---|---|
| 1 | Table | The name of the source table to be imported |
| 2 | Source | The actual source name from the system |
| 3 | Package | Associated import package the table belongs to |
| 4 | Description | Optional notes about the table’s purpose or contents |
| 5 | UpdateStatistics | Specifies if SQL Server statistics should be updated after import |
| 6 | UseLogging | Enables logging for the import process of this table |
| 7 | Delete | Removes the selected import entry |
| 8 | New | Creates a new import table configuration |
Behavior
- Each table must be assigned to a package for ETL processing
- Statistics updates help with query optimization in SQL Server
- Logging allows tracking and error handling during import
- Import entries can be edited or extended with additional metadata
Notes
- Tables without packages will not be imported during ETL execution
- Descriptive naming and documentation improve maintenance
- Future features may allow scheduling and conditional execution
