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.
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

Context menu used to create an import
Right-click the predecessor Source object, such as dbo.Categories, and select Add -> 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

| 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.

| 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

| 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

| 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

| 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

| ID | Command | Description |
|---|---|---|
| 1 | Lock object | Locks the selected import object. |
D) 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

| 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. |