IBM Automatic Data Lineage Configuration

The configuration of Automatic Data Lineage in the Admin UI consists of two tabs, namely Connections and Configuration. You can see what each tab is for below.

Tab uses:

Configuration Types

There are two configuration types that can be found in the Manta Admin UI: properties configuration and tabular configuration.

Properties Configuration

Properties configuration represents a configurable element as a list of properties. The name and general description of the configurable element may be found at the top of the viewer. The required properties, which may not be empty, have a red asterisk before the property name. The configuration may be in one of two modes: read or edit.

No alt text provided

Basic/Advanced

You can choose between the two view modes: Basic and Advanced. The basic mode shows only basic configuration properties while the advanced mode shows basic configuration properties, hidden configuration properties, and advanced configuration properties (parent configuration properties, which may be overridden and present only if the configurable element has a parent configuration).

No alt text provided

The behavior of the advanced mode also depends on the configuration mode: read or edit. In read mode, only overridden properties will be shown.

No alt text provided

In edit mode, all properties, overridden and default, will be shown. To make advanced configuration properties editable and override values from the parent configuration, use the switch at the beginning of the Advanced Configuration section. The revert symbol next to the property value in the Advanced Configuration part serves two purposes. It is an indicator of an overridden property and a button for reverting the

default value of the property.

No alt text provided

Property Description

Each defined property in Manta has a description that can be revealed by hovering over the info icon next to the property.

No alt text provided

Some radio button and checkbox property values also have descriptions that are displayed by hovering over the property value.

No alt text provided

Edit

To enter edit mode to change the connection configuration, click the blue Edit button in the upper-right corner. Once you enter edit mode, you will be able to edit all editable properties. Read-only properties will remain uneditable.

No alt text provided

The following types of properties can be found in the property configuration:

No alt text provided

No alt text provided

No alt text provided

No alt text provided

No alt text provided

If the password or path to a keystore is changed, the configuration should be saved before the keystore setting is opened; otherwise, the old property values will be used when editing the keystore.

No alt text provided

After clicking on the Edit button, all private keys and/or certificates in the store are listed. It’s possible to delete and add new certificates to the store in this window.

No alt text provided

Each certificate has additional information, which can be displayed after clicking on the arrow.

No alt text provided

The keystore can be recreated with a new password and path. If the keystore is recreated, all certificates will be lost and the old keystore will be deleted.

After recreating each truststore (in case there are multiple on the same page), the page must be saved both before and after adding any certificates.

No alt text provided

It’s possible to add new entries to the keystore by either adding entries from another keystore or downloading a certificate. A certificate can be downloaded from a website or from supported technologies directly by providing URL.

Technology Example
MS SQL jdbc:sqlserver://mssql.com:1433/db
PostgreSQL jdbc:postgresql://postgressql.com:5455
Redshift jdbc:redshift://redshift.com:5455
Teradata jdbc:teradata://teradata.com:1025
Netezza jdbc:netezza://netezza.com:5480/system
Oracle jdbc:oracle://oracle.com:2484/db
Hive jdbc:hive://hive.com:10000
SAP HANA jdbc:sap://sap-hana.com:443
DB2 jdbc:db2://db2.com:50000/db

No alt text provided

When entries are extracted from the keystore or a website, then we can choose which entries to add and change their default alias to a custom alias.

Note that Manta has no means of validating the origin of the certificate. It is the responsibility of the user importing the certificate to make sure that the certificate being imported is the one desired and that Manta should trust it.

No alt text provided

Each entry is checked to determine if it can be added to the keystore. If the configuration screen contains a truststore component, only public certificates can be uploaded. If the configuration screen contains a keystore component, only private keys can be uploaded. In some specific cases (e.g., Qlik Sense connection definition), the components can be mixed — accepting both public certificates and private keys. If the entry cannot be added, then a red triangle will be displayed on the row with the entry and it won’t be possible to select it for import.

No alt text provided

Save

When you click the Save button on the top panel, the property and configuration validation will be initialized, and if it’s successful, then the configuration will be saved. You cannot undo the configuration save.

Validation

There are two types of validations which are provided:

Property Validation

Most of the properties have validation rules. In case of non-compliance with the rules, a message about failed validation is shown under the validated property. Property validation is initialized when a user interacts with a property or saves a configuration. A configuration cannot be saved until all the property validation rules are fulfilled.

No alt text providedNo alt text provided

Configuration Validation

Most configurations are automatically validated before saving or upon explicit request by the user by clicking on Validate button. If the validation is successful, you will be notified; otherwise, a dialog window with information about the failed validation opens.

No alt text provided

If Manta is able to automatically extract metadata from a particular technology for flow analysis, it is possible to validate a connection to the source system by clicking on the Validate button.

No alt text provided

Some validations may take up to a few minutes to complete, and it’s possible to abort a running validation. The validation steps that have not been run yet will be skipped. The aborted validation is shown as failed, and it's necessary to confirm that the configuration is in the desired state to save it. It is not good practice to skip validations, as it may cause problems during extraction, so this feature should only be used in rare situations.

No alt text providedNo alt text provided

Custom Properties

All custom properties that aren’t provided by Manta are displayed in the Custom Settings property group. Such properties can be edited, but you cannot add new ones (which should not be needed anyway). These are typically leftovers from older versions of Manta where the property was used, but it is not used anymore. These properties can be removed by editing the underlying property file directly in the file system. Such properties should not cause issues as they should not be used anymore.

No alt text provided

Tabular Configuration

Tabular configuration is represented by a table. It’s possible to add, delete, and edit lines. There are two different types of tables that are used to represent different types of configurations, which are the simple table and the manual override table.

If there are many lines in a table, the lines will be paged so you can choose how many lines you want to see on each page. Each column has a description, which will be shown when you hover over the info icon next to a column name.

No alt text provided

Delete Lines

A line from the table may be deleted in two ways.

No alt text provided

No alt text provided

Edit Existing Lines

To edit an existing line, click on the pencil at the end of the line. (If the line is not editable, there will not be a pencil.)

No alt text provided

After clicking the edit button, the line configuration is represented by the properties configuration.

No alt text provided

You can search all columns in the table using the search box in the upper-right corner.

No alt text provided

Simple Tables

A simple table is a typical table without any modifications.

Add New Lines

New lines can be added to the simple table using the Add Line button in the header.

No alt text provided

After clicking on the button, a form that can be used to add a new line is shown.

No alt text provided

Copy Lines

Another way to add new lines is to copy an existing line using the copy line button at the end of the line that you want to copy.

No alt text provided

After clicking the button, a form that can be used to add a new line is displayed. The form will be prefilled with the values from the line that you chose to copy.

No alt text provided

Manual Override Table

The manual override table differs in how new lines are added to it. A new line is added by copying an existing line and overriding the values from it.

Add New Lines

New lines can be added to the manual override table using the Manual Override button at the end of the line you want to copy and override. New lines can only be added to the manual override table by overriding existing lines.

No alt text provided

After clicking the button, a form that can be used to add a new line is displayed. By default, only the basic properties to be overridden are shown. So, if you want to override any other properties, click on the Full Override button.

No alt text provided

Connections Tab

The Connections tab contains existing connections to source systems that have already been created. The tab allows you to create new connections and configure existing ones.

No alt text provided

Connections Menu

The connections menu contains connections to source systems. Each item in the menu represents a separate connection. If a connection item is crossed out and has a red crossed-out circle next to it, then it’s disabled and won’t be analyzed; otherwise, it’s enabled and will be analyzed during Manta Flow analysis. Connections are divided into different groups by technology type and technology. When a connection is selected, it is highlighted in light red. The path to the selected item is lined with a red technology group and technology names so it’s easy to find the location of the element that is currently selected, even if all groups are collapsed. Each group can be collapsed as well as the whole menu.

No alt text provided

Connection Viewer and Editor

After selecting a connection from the connection menu, the connection configuration viewer appears in read-only mode, displaying the configuration without the option to change it. The connection configuration is represented by the properties configuration.

Enable/Disable Connections

A connection can be in two states.

The connection state can be changed using the switch next to the connection name, which also serves as a connection state indicator.

No alt text providedNo alt text provided

The second indicator is the connection item in the connection menu. When a connection item in the menu is crossed out and has a red crossed-out circle next to it, it’s disabled; otherwise, it’s enabled.

No alt text providedNo alt text provided

Delete Connections

When you click the Delete button, the Delete Connection? dialog box appears. You can still cancel the deletion at this time, but once you click the Delete button in the dialog box, the deletion cannot be undone.

No alt text provided

Create New Connections

To create a new connection, you can use the + Add Connection button in the connections menu or in the center of the Connections page under the greeting.

No alt text provided

New Connection Dialog Box

After clicking on the + Add Connection button, the Configure New Connection dialog box will appear and you can choose which technology you want to create a new connection for. The technologies are divided into technology groups. Each item in these groups contains a technology icon and short and full technology names. At the top of the dialog box, there is a search field that can be used to search for the necessary technology.

No alt text provided

The new connection configuration is represented by the properties configuration.

No alt text provided

Configuration Tab

The Configuration tab allows us to configure the general behavior of Manta, the authentication and authorization of the Manta Flow Server, and the graphical and programming APIs as well as set a new license for Manta and see the license statistics.

No alt text provided

Configuration Menu

The configuration menu contains the common Manta elements that can be configured.

No alt text provided

Responsibilities of the menu elements:

Configuration Viewer and Editor

In the Configuration tab, two types of configurations are used: properties configuration and tabular configuration.

License

On the License Management page, you can see the Current License Information and License Statistics and you can set a new license.

No alt text provided

Apply a New License

To apply a new license, you should press the Upload New License button, which will open a dialog box where you can drop a license file, or use the Upload License button to choose a file from your file system.

No alt text provided

After uploading a license to Manta, you will see information about the license and if the license is valid. If it is, then you can press the Apply License button to apply the license.

No alt text provided

If there are any problems with the license, you will see why the validation failed. Contact IBM Support if this happens.

No alt text provided

Maintenance

The Maintenance page contains a directory of links to individual Manta components/functions that are useful for Manta administration.

No alt text provided