Skip to main content
Skip table of contents

Tool Overview

This chapter covers the global functionality available in the title and menu bar of DATPROF Analyze. Subsequent chapters will dive deeper into the core functionality and detailed settings of the tool.

In general, the analysis process includes the following steps:

  • Creating a new project

  • Providing a connection to the database

  • Importing metadata from the database

  • Configuring the Analyze profiles

  • Running Analyze statistics

  • Analyzing the database and interpreting used profiles

These steps form the foundation for using DATPROF Analyze effectively.

Getting Started: Create or Open a Project

When DATPROF Analyze is launched, a dialog appears, allowing the user to choose between creating a new project or opening an existing one. The user is presented with three options:

DATPROF Analyze start screen.PNG
  • New project: This option prompts the user to enter a project name and select a location to save the project. Both fields are prefilled with default values. Upon confirmation, an empty project is created, and the Settings window is displayed.

  • Recently opened projects: The right side of the dialog lists recently opened projects. Clicking on any project from this list opens the last saved version.

  • Open existing project: This option displays a dialog box for selecting and opening a previously saved project.

Menu Overview

The menu provides access to various features and functions. It includes the following four options:

DATPROF Analyze Menu Bar.png
  • File

  • Project

  • Visualize

  • Help

File

The File menu provides options for managing and organizing your projects:

DATPROF Analyze Menu File.png
  • New Project: Opens a dialog box to create a new project.

  • Open existing project: Opens a dialog box to load an existing project.

  • Save: Saves changes made to the current project.

  • Save as: Saves the current project as a new project with a different name or location.

  • Close project: Closes the current project and returns to the opening dialog.

  • Exit: Closes the DATPROF Analyze application.

Project

The Project menu offers several features for managing metadata, generating reports, and viewing profiling data:

DATPROF Analyze Menu Project.png
  • Import and synchronize:  Opens a dialog to import metadata or use a DME file along with the synchronization metadata wizard.

  • Export Metadata to DME File: Opens a dialog to export the data model (partially or entirely) to a generic DATPROF file format. This format allows the exchange of data models and metadata within the DATPROF product suite, including DATPROF Subset, DATPROF Privacy, and DATPROF Analyze.

    • To export, navigate to Project → Export Metadata to DME File, and select the tables and foreign keys to export.

DATPROF Analyze Export meta data to DME-file.PNG

Using the menu option Project → Import and Synchronize metadata from DME file, the user can import a data model from a DME file into this project.

  • Generate analyze report: Collects all statistics and profiling data and generates an HTML report.

  • Profile Overview: Opens a view displaying all tables and columns, along with their respective analyzed profiles.

Visualize

The Visualize menu offers an option to view and interact with the data model in a visual format:

DATPROF Analyze Menu Visualize.png
  • Visualize data model: Displays a visual representation of the imported data model, including all user-defined relationships. The diagram shows all imported entities, along with any custom-added relations.

    Additionally, the window provides options to save or print (parts of) the displayed diagram.

Note: Before visualizing the data model, the metadata must be imported via the database connection.

DATPROF Analyze Visualization.png

Help

The Help menu provides access to resources for assistance, licensing, and product information:

DATPROF Analyze Menu Help.png
  • Help: Opens this user manual for DATPROF Analyze. You can access it online at this link.

  • Enter licence key: Opens a dialog where you can enter a purchased license key to activate DATPROF Analyze.

  • About DATPROF Analyze: Opens the About screen, displaying version information and license details for the DATPROF Analyze application.

DATPROF Analyze About Screen.png

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.