Import

Overview

Import, shown by the IP marker, represents the flow from an external Source object into an IMP object in the Staging layer. The relationship shows where data enters AnalyticsCreator and which imported object receives it.

Function

An import flow connects a Source object, such as dbo.Categories, to an imported Staging object, such as IMP.Categories. The Source object provides the Add command used to create the import, while the IMP object provides the complete management menu for the imported object.

IP

The IP marker identifies the import relationship between the Source and IMP objects. Use the predecessor Source rectangle for Add -> Import. The marker may expose limited diagram actions in some application versions, but it is not the owner of the complete creation menu.

Access

Imports can be created from a Source object on the dataflow diagram and maintained through the resulting IMP object, package navigation entries, and import-related list views.

How to access

Navigation tree

Packages -> Import

Toolbar

ETL -> List -> Imports, or ETL -> List -> Packages

Create on diagram

Right-click a Source object and select Add -> Import.

Manage on diagram

Right-click the resulting IMP object to open its complete object context menu.

Screen overview

Import relationship screen overview

Context menu used to create an import

Right-click the predecessor Source object, such as dbo.Categories, and select Add -> Import.

Source object context menu used to create an import

ID Command Description
1 Locate in tree Locates the selected source object in the navigation tree.
2 Set filter Sets the selected source object as the current filter for the dataflow diagram.
3 Add to filter Adds the selected source object to the current diagram filter.
4 Refresh Refreshes the selected source object in the dataflow diagram.
5 Add Opens the submenu containing the available options for adding a related object.
6 Delete Deletes the selected source object.
7 References Opens the submenu containing reference-related options for the selected source object.
8 Locks Opens the submenu containing lock-related options for the selected source object.
9 Object groups Opens options for managing the object groups associated with the selected source object.
10 Preview data Opens a preview of the data returned by the selected source object.
11 Refresh source Refreshes the selected source definition from its connected data provider.
12 Customize colors Opens the submenu for customizing the display colors of the selected source object.

Source Add Submenu

Source Add submenu showing Import

ID Command Description
1 Data source Opens options for adding a data source.
2 Import Opens options for adding an import object.
3 Transformation Opens options for adding a transformation object.
4 Export Opens options for adding an export object.
5 Calendar dimension Opens options for adding a calendar dimension.
6 Time dimension Opens options for adding a time dimension.
7 Snapshot dimension Opens options for adding a snapshot dimension.

Import object context menu

Right-click the resulting IMP object to access its management commands and the options for creating downstream objects.

Import object context menu

ID Command Description
1 Locate in tree Locates the selected import object in the Data warehouse tree.
2 Set filter Sets the selected import object as the current filter for the dataflow diagram.
3 Add to filter Adds the selected import object to the current diagram filter.
4 Refresh Refreshes the selected import object in the dataflow diagram.
5 Add Opens the submenu containing the available options for adding an object.
6 Delete Deletes the selected import object.
7 References Opens the submenu containing reference-related options for the selected import object.
8 Locks Opens the submenu containing lock-related options for the selected import object.
9 Object groups Opens options for managing the object groups associated with the selected import object.
10 Import/Export object definition Opens the submenu for exporting the selected import object definition.
11 Customize colors Opens the submenu for customizing the display colors of the selected import object.

Sub menus

Import object submenu groups

ID Submenu group Description
A Add Contains the available options for adding an object related to the selected import object.
B References Contains options for viewing or managing references associated with the selected import object.
C Locks Contains lock-related options for the selected import object.
D Import/Export object definition Contains options for exporting the selected import object definition.
E Customize colors Contains options for customizing the colors used to display the selected import object.

A) Add Submenu

Import object Add submenu

ID Command Description
1 Data source Opens options for adding a data source.
2 Historization Opens options for adding a historization object.
3 Transformation Opens options for adding a transformation object.
4 Export Opens options for adding an export object.
5 Data vault hash fields Opens options for adding Data vault hash fields.
6 Data vault hub Opens options for adding a Data vault hub.
7 Data vault satellite Opens options for adding a Data vault satellite.
8 Data vault link Opens options for adding a Data vault link.
9 Calendar dimension Opens options for adding a calendar dimension.
10 Time dimension Opens options for adding a time dimension.
11 Snapshot dimension Opens options for adding a snapshot dimension.

B) References Submenu

Import object References submenu

ID Command Description
1 Show reference diagram (active) Shows active reference diagrams associated with the selected import object.
2 Show reference diagram (inactive) Shows inactive reference diagrams associated with the selected import object.
3 Show reference diagram (all) Shows all reference diagrams associated with the selected import object.
4 List references Lists references associated with the selected import object.
5 Add reference Adds a reference to the selected import object.
6 Start reference Starts creating a reference from the selected import object.

C) Locks Submenu

Import object Locks submenu

ID Command Description
1 Lock object Locks the selected import object.

D) Import/Export object definition Submenu

Import object Import/Export object definition submenu

ID Command Description
1 Export to file Exports the selected import object definition to a file.
2 Export to cloud Exports the selected import object definition to the cloud.

E) Customize colors Submenu

Import object Customize colors submenu

ID Command Description
1 Background Color Changes the background color of the selected import object.
2 Foreground Color Changes the foreground color of the selected import object.

Related topics