An unstructured port inherits the structure of a structured port, when a connection is added between them.
You can add attributes to a port structure.
After you add a component to the project, the color of the component ports indicates the status of the component:
Green – component is properly configured.
Yellow – the port structure is defined but one or more mandatory properties are not defined.
Red – no port structure is defined, but one or more mandatory properties are not defined.
To enhance support for users with color disabilities,
you can change the color of the yellow component port by selecting “Use
enhanced color accessibility” in the File | Preference
window. See “Customizing preferences”.
In the Design window, right-click the port and select Edit Structure.
In the Structure Viewer window, make the required changes, and click Save.
If a port structure cannot be modified, the Edit Structure
option is not available. You can only view the port structure using
the View Structure option.
In the Design window, right-click the port and select Edit Structure.
In the Structure Viewer window, select Actions | Add, or right-click the attribute and select Add.
Enter a name for the new attribute. The names for port attributes must start with an alphabet character and can contain only alphanumeric characters. Do not use a reserved JavaScript keyword. See “Variables”.
Select the Populate Attribute option to add the attribute to multiple port structures. The new attribute is added to all port structures participating in the selected connections and is automatically mapped. Click OK.
In the Design window, right-click the port, and select Edit Structure.
In the Structure Viewer window, select Actions | Remove, or right-click the attribute and select Remove.
In the Design window, right-click the port and select Edit Structure.
In the Structure Viewer window, change the attribute settings, and click Save.
Copying port structures from other ports
You can assign a port structure to a port based on any other available port in the current project:
In the Design window, select the port you want to assign a new structure to.
Right-click and select Assign Structure | Copy Structure.
You can copy the port structure from other ports of the same component. You can also copy any other port structure of the current project by selecting Copy Structure. If you select Copy Structure, a window displays an overview graph of the current project. You can select any of the available ports in the project.
Updating port structure
with database changes
To apply database changes to the port structure of the DB Source, DB Sink, and DB Staging components:.
Right-click the component and select Reconfigure.
The Reconfigure option updates the component configuration when there is a change in the database schema. It closes the current connection, opens a new connection to the database, reads the metadata of the query, and applies the updates to the port structure.
Selecting a port to serve as the source for your
new port structure
Click the port you want to use as a source. The attribute structure of the selected port appears in the lower area of the window.
Click Apply.
