Getting Started

Walk-through of Pentaho Data Catalog ..

Introduction

Pentaho Data Catalog is a powerful tool that enables data engineers, data scientists, and business users to accelerate their data intelligence journey. It automatically discovers, classifies, and contextualizes structured and unstructured data. Here are some key features:

Powerful Business Glossary: Contextualize data with business vocabulary based on governance policies and business rules. This helps activate metadata and ensures alignment with business language.
Data Lineage and Trust: Track data lineage with Open Lineage, building trust as data flows through your organization. Enable data quality and remediation activities.
Observability and Monitoring: A robust observability stack captures popular assets, popular searches, and trends. This helps stewardship organizations focus their energy on the right data.
Integration and Scalability: API-powered integrations with various platforms (NetApp, SAP Hana, S3, SQL views) ensure interoperability. The modern architecture design scales seamlessly.
Enterprise Security: Features include role-based access control (RBAC), password vault support, minimum privileges, multifactor authentication, secure cloud deployments, and no data deduplication.

Discover, understand, and govern your data with Pentaho Data Catalog. It offers faster discovery, lower total cost of ownership (TCO), and improved data quality.

Accessing Your Catalog

To access your catalog, please follow these steps:

Open Google Chrome web browser.
Navigate to https://pdc.pdc.lab/
Enter the following email and password, then click Sign In.

Username

Password

Role

[email protected]

Welcome123!

All the Roles combined

[email protected]

Welcome123!

Community & User Administrator

[email protected]

Welcome123!

Manage Business Glossary

[email protected]

Welcome123!

View Business Glossary

[email protected]

Welcome123!

Add & Delete content

[email protected]

Welcome123!

Manage Business Rules & Domain Assets

[email protected]

Welcome123!

Manage most features except Glossary

For enhanced security, it is strongly recommended that users avoid saving their login details directly in web browsers. Browsers may inadvertently autofill these credentials in unrelated fields, posing a security risk.

Best Practice

• Disable Autofill: To mitigate potential risks, users should disable the autofill functionality for login credentials in their browser settings. This preventive measure ensures that sensitive information is not unintentionally exposed or misused.

User Interface

You can access your user profile via the top menu bar or navigate to various features using the left menu bar.

The Home page serves as a central hub for accessing business tools relevant to your role, including data canvas, business glossary, management tools, and worker resources.

Access the top user menu to manage your user profile, manage assigned data sources, and log out.

View the following table for details about these features:

Icon

Name

Function

Apps

Click to explore all apps associated with Data Catalog, including Dashboard, that extend the visual discovery and relationship discovery capabilities of Data Catalog.

Profile

Click the Profile icon to open the User Profile and Data Sources where the user can manage the details and assign data sources with the required access levels.

Click the More icon and select Log Out to log out of Data Catalog

Edit

Click Edit to open the Landing Page Options window, where you can configure the landing page with available options in Shortcuts and Tables. Additionally, you can choose to have a vertical or stacked layout in Layout.

Icon

Name

Feature

Home

Returns you to the Home page from your current location in Data Catalog.

Data Canvas

Explore your data in the Data Canvas. For more information, see Data Canvas.

Glossary

Opens the Business Glossary page where you can create, organize, and curate business terms to help you navigate your data.

For more information, see Business Glossary.

Reference Data

Opens the Reference Data page. Reference data sets contain relatively static, unchanging data values that are commonly used by an organization. For more information, see Reference Data.

Management

Manage your data sources, users, user roles, workers, business rules, schedules, dictionaries, and more in the Manage Your Environment page.

Workers

Monitor the data activities’ progress on the Worker’s screen.

Using Galaxy View for Advanced Data Searches

Galaxy view offers an intuitive approach to navigating complex data structures, empowering users to conduct precise searches across databases. It's an invaluable tool for roles such as information security officers who need to pinpoint sensitive information efficiently, like credit card data within expansive databases.

Key Features:

Search Flexibility: Easily search for terms like "credit" with the ability to filter results. Filters such as Columns allow users to identify specific columns containing credit card information, while the Tables filter returns tables explicitly named with "credit".
Scope Definition: Tailor your search scope using filters to streamline the process of locating pertinent information. This ensures that you only get relevant results matching your search criteria.
Data Visualization: The Galaxy view provides a comprehensive overview, highlighting data relationships at a glance. This bird's eye view is particularly useful for understanding the structure and interconnections of your data beyond what a traditional navigation tree offers.
Drill-Down Capability: Once in the Galaxy view, users can delve deeper into specific data points for detailed information, ensuring a thorough analysis of the data structure and content.

Galaxy view is especially recommended for those who require a macro yet detailed perspective on data relationships, making it easier to manage and analyze vast databases effectively.

Obviously .. the data needs to be processed and Business Glosseries & Terms added.

To access Galaxy view from the Data Canvas, select, for example 'synthea' folder.

Click 'Actions' and select 'View Galaxy'.

Here are the key tasks you can perform in Galaxy view:

Task

Description

Enter a keyword and select Search to find specific information within the resources. For example, enter "patients" to just show those sources, tables, and columns containing patients information.

View Details

Right-click on a selected data resource or column in Galaxy view and select View Details. The details panel appears. Depending on your selection, you can view different information, such as properties, tags, and custom properties. Additionally, you can also view and add business terms to the resource.

View Items

Right-click on a data resource in Galaxy view and select View Items. You can view the associated parent and child data assets in a tree view.

Select and Select Tree

To select a single data resource, right-click on a data resource in Galaxy view and click Select. Additionally, you can select associated data resources by clicking Select Tree. When an item is selected, you can right-click and Deselect the item

Focus

Right-click on a selected data resource or table and select Focus. Only the resource and its children appear. Continue to drill down using the Focus option as needed or select Leave Focus to return to the full view.

If you want to reduce the amount of data displayed, you can filter the level of detail in your view by columns or tables.

In Galaxy view, click Filters to open the Filters dialog box and select one or more of the following options:

Filter Option

Description

Level of Detail

By default, Galaxy view shows down to the table level as a reduced set of data. Click Columns and apply to have a detailed view down to the column level.

Show Relationships

Helps to limit the results in the view with the data resources that are Declared Foreign Key and Discovered Foreign Key.

Show only Related Items

When the Show Relationships is active, you can choose a threshold number to refine the results further.

Show only Tagged Items

Select this check box to limit the results in the view with the data resources that have associated tags. You can further refine your view by selecting specific tags.

Show only Items with Business Terms

To further limit the results in the view, select this check box. You can further refine your view by selecting specific business terms.

Show Data Elements

You can also choose to show the data elements by selecting this check box.

Reset

Discard your filters.

PreviousOverview NextData Sources

Was this helpful?

Getting Started

Introduction

Accessing Your Catalog

User Interface

Top Menu

Left Menu Options

Explore Your Data with the Data Canvas

Using Galaxy View for Advanced Data Searches

Introduction

Accessing Your Catalog

Security Advisory: Handling Login Credentials

User Interface

Top Menu

Left Menu Options

Explore Your Data with the Data Canvas

Using Galaxy View for Advanced Data Searches