Packages

Overview

The Packages navigation tree branch opens package definitions and package-type branches.

Function

Use the branch or ETL toolbar command to open the package list.

The list shows package name, package type, manual creation, external launch, and description with actions for creating or deleting packages.

Access

Open the Packages branch from the navigation tree or use the ETL toolbar tab.

How to access

Navigation tree

Packages -> List packages; Packages -> [package type] -> List packages.

Toolbar

ETL -> Packages.

Diagram

Not opened directly from the diagram.

Visual element

Packages navigation branch and list

Screen overview

Context menus access - Packages - Where I can find it

The context menu examples below use the captured Data warehouse > Packages navigation tree branch and its package-type, package, and package-item nodes.

A.1) Packages

ID	Command	Description
1	List packages	Opens the packages list for the selected branch.
2	Generate packages	Starts package generation from the Packages branch.

B.1) Packages > Import

ID	Command	Description
1	Refresh	Reloads the selected branch.
2	List packages	Opens the packages list for the Import package type.
3	Add import package	Creates an import package in the selected context.

B.2) Packages > Import > IMP_Northwind1

Paste image here: Data warehouse > Packages > Import > IMP_Northwind1

ID	Command	Description
1	Refresh	Reloads the selected package.
2	Edit package	Opens the selected package for editing.
3	Delete package	Deletes the selected package.
4	Add import	Adds an import item to the selected package.
5	List scripts	Lists scripts available for the selected package.
6	Add script	Adds a script to the selected package.
7	Run script	Runs a script for the selected package.

B.3) Packages > Import > IMP_Northwind1 > dbo.Categories->IMP.Categories

ID	Command	Description
1	Edit import	Opens the selected import item for editing.
2	Delete import	Deletes the selected import item.

C.1) Packages > Historization

ID	Command	Description
1	Refresh	Reloads the selected branch.
2	List packages	Opens the packages list for the Historization package type.
3	Add historization package	Creates a historization package in the selected context.

C.2) Packages > Historization > HIST_Northwind1

ID	Command	Description
1	Refresh	Reloads the selected package.
2	Edit package	Opens the selected package for editing.
3	Delete package	Deletes the selected package.
4	Add historization	Adds a historization item to the selected package.
5	List scripts	Lists scripts available for the selected package.
6	Add script	Adds a script to the selected package.
7	Run script	Runs a script for the selected package.

C.3) Packages > Historization > HIST_Northwind1 > IMP.Categories->STG.Categories

ID	Command	Description
1	Edit historization	Opens the selected historization item for editing.
2	Delete historization	Deletes the selected historization item.

D.1) Packages > Export

ID	Command	Description
1	Refresh	Reloads the selected branch.
2	List packages	Opens the packages list for the Export package type.
3	Add export package	Creates an export package in the selected context.
4	List scripts	Lists scripts available for the selected context.
5	Add script	Adds a script to the selected context.
6	Run script	Runs a script for the selected context.

D.2) Packages > Export > Orders_Export

ID	Command	Description
1	Refresh	Reloads the selected package.
2	Edit package	Opens the selected package for editing.
3	Delete package	Deletes the selected package.
4	Add import	Adds an import item to the selected package.
5	List scripts	Lists scripts available for the selected package.
6	Add script	Adds a script to the selected package.
7	Run script	Runs a script for the selected package.

D.3) Packages > Export > Orders_Export > STAR.DIM_Orders->dbo.Orders_Export

ID	Command	Description
1	Edit export	Opens the selected export item for editing.
2	Delete export	Deletes the selected export item.

E.1) Packages > External

ID	Command	Description
1	Refresh	Reloads the selected branch.
2	List packages	Opens the packages list for the External package type.
3	Add external package	Creates an external package in the selected context.

F.1) Packages > Persisting

ID	Command	Description
1	Refresh	Reloads the selected branch.
2	List packages	Opens the packages list for the Persisting package type.
3	Add persisting package	Creates a persisting package in the selected context.

F.2) Packages > Persisting > DIM_Invoices_P

ID	Command	Description
1	Refresh	Reloads the selected package.
2	Edit package	Opens the selected package for editing.
3	Delete package	Deletes the selected package.
4	List scripts	Lists scripts available for the selected package.
5	Add script	Adds a script to the selected package.
6	Run script	Runs a script for the selected package.

F.3) Packages > Persisting > DIM_Invoices_P > DWH.DIM_Invoices->DWH.DIM_Invoices_T

ID	Command	Description
1	Edit persisting	Opens the selected persisting item for editing.
2	Delete persisting	Deletes the selected persisting item.
3	List scripts	Lists scripts available for the selected item.
4	Add script	Adds a script to the selected item.
5	Run script	Runs a script for the selected item.

G.1) Packages > Script

ID	Command	Description
1	Refresh	Reloads the selected branch.
2	List packages	Opens the packages list for the Script package type.
3	Add script package	Creates a script package in the selected context.

H.1) Packages > Workflow

ID	Command	Description
1	Refresh	Reloads the selected branch.
2	List packages	Opens the packages list for the Workflow package type.
3	Add workflow package	Creates a workflow package in the selected context.

H.2) Packages > Workflow > Workflow package

ID	Command	Description
1	Refresh	Reloads the selected package.
2	Edit package	Opens the selected package for editing.
3	Delete package	Deletes the selected package.
4	List scripts	Lists scripts available for the selected package.
5	Add script	Adds a script to the selected package.
6	Run script	Runs a script for the selected package.