For a free demo, questions about DB-Harbour,
or to discuss other implementation options
(PL/SQL only, lightweight & open-source),
feel free to contact us via email or phone:

dbh@data-appstairs.com
+49 (0) 9131 6824 300
We look forward to hearing from you!

Already a customer - Manage your tickets

DB-Harbour Logo

A DBA tool and technical reporting framework for Oracle databases.

>> more details

DB-HARBOUR

is a DBA tool and technical reporting framework for Oracle databases.

>> more details

DB-Harbour Logo
Enter a select query
Enter a select query
Enter a select query

SELECT

data cyclically from multiple databases in parallel.

SELECT

data cyclically from multiple databases in parallel.

Type in a Select-Query
Type in a Select-Query
Tablespace Overview
Tablespace Overview
Tablespace Overview

RESULTS

appear in custom formats and can be filtered precisely.

RESULTS

appear in custom formats and can be filtered precisely.

Tablespace Overview
Tablespace Overview
Compare Database-Users
Compare Database-Users
Compare Database-Users

COMPARE

data to ensure persistent DB compliance.

COMPARE

data to ensure persistent DB compliance.

Compare Database-Users
Compare Database-Users
Performance / Wait-Event Graph
Performance / Wait-Event Graph
Performance / Wait-Event Graph

GRAPHS

showing current or historical data for better analysis.

GRAPHS

showing current or historical data for better analysis.

Performance / Wait-Event Graph
Performance / Wait-Event Graph
Dashboard Overview
Dashboard Overview
Dashboard Overview

DASHBOARDS

giving you a quick overview of the current health of your database(s).

DASHBOARDS

giving you a quick overview of the current health of your database(s).

Dashboard Overview
Dashboard Overview

Advantages of DB-Harbour

Advantages of DB-Harbour

 

  • Everything in one reporting framework - from the select query to the dashboard
  • Convenient operation of all functions via web interface
  • Pull method: No agents or PL/SQL code necessary in target databases
  • Free-form entry of the select query
  • Automated creation and maintenance of all tables created based on queries
  • Highly adaptable thanks to many freely configurable settings
  • Access control to functions of the web interface possible through user/rights management
  • Oracle Standard Edition sufficient
  • Secure operation ensured by appropriate application architecture and best practice recommendations during installation (for web server, repository database, and users in target databases)
  • Continuous support and further development of DB-Harbour by Data-Appstairs

 

USE CASES

  • Whether for internal checks or external audits (e.g., CIS auditing) - with DB-Harbour you can check if your databases are configured in accordance with security requirements and automatically receive a permanent overview and historization:

    - Are the database users in the correct profiles, and what password versions do the users have?
    - Are there users who have never logged in or who need to be deleted?
    - Reading, central storage, and evaluation of the auditing views (e.g., fine-grained auditing or unified auditing)
    - Preparing audits and permanently ensuring security requirements (e.g., checking for public database links or ANY grants)
    - Further testing of your own security standards (e.g., configuration of database vault or TTS encryption)

    Whether for internal checks or external audits (e.g., CIS auditing) - with DB-Harbour you can check if your databases are configured in accordance with security requirements and automatically receive a permanent overview and historization:

    - Are the database users in the correct profiles, and what password versions do the users have?
    - Are there users who have never logged in or who need to be deleted?
    - Reading, central storage and evaluation of the auditing views (e.g., fine-grained auditing or unified auditing)
    - Preparing audits and permanently ensuring security requirements (e.g., checking for public database links or ANY grants)
    - Further testing of your own security standards (e.g., configuration of database vault or TTS encryption)

  • In contrast to monitoring tools, DB-Harbor can be used to carry out a more in-depth backup analysis, which can be used to avoid future problems in advance. With the help of DB-Harbour, many questions about the backup of Oracle databases can be answered quickly, conveniently, and permanently:

    - Are there new datafiles or PDBs that have never been backed up?
    - What is the status and timestamp of datafile copies?
    - Free space within the Flash Recovery Area and in ASM disk groups
    - Did any backups fail?
    - How have the backup volume and backup durations developed over the last few years?
    - Does changing the backup strategy make sense, and can space be saved?

    In contrast to monitoring tools, DB-Harbor can be used to carry out a more in-depth backup analysis, which can be used to avoid future problems in advance. With the help of DB-Harbour, many questions about the backup of Oracle databases can be answered quickly, conveniently, and permanently:

    - Are there new datafiles or PDBs that have never been backed up?
    - What is the status and timestamp of datafile copies?
    - Free space within the Flash Recovery Area and in ASM disk groups
    - Did any backups fail?
    - How have the backup volume and backup durations developed over the last few years?
    - Does changing the backup strategy make sense, and can space be saved?

  • If you do not use an Enterprise Edition or the Performance & Tuning Pack, performance evaluation is less convenient because the use of Cloud Control or AWR reports is not possible. By setting up appropriate rules in DB-Harbour, a lot of performance information can be queried and visualized:

    - Display of waits (e.g., per class and/or event)
    - Top SQL statements (e.g., per number of executions or per IO/CPU load)
    - Are there longer blocking sessions, deadlocks, or other “long runners”?
    - Have execution plans of statements changed?
    - How have the number of processes and sessions changed recently?
    - Further queries for individual cases (e.g., monitoring of rollback operations or refreshes of materialized views)

    If you do not use an Enterprise Edition or the Performance & Tuning Pack, performance evaluation is less convenient because the use of Cloud Control or AWR reports is not possible. By setting up appropriate rules in DB-Harbour, a lot of performance information can be queried and visualized:

    - Display of waits (e.g., per class and/or event)
    - Top SQL statements (e.g., per number of executions or per IO/CPU load)
    - Are there longer blocking sessions, deadlocks, or other “long runners”?
    - Have execution plans of statements changed?
    - How have the number of processes and sessions changed recently?
    - Further queries for individual cases (e.g., monitoring of rollback operations or refreshes of materialized views)

  • For large database environments, homogenization and standardization make sense wherever possible. This makes it easier to automate tasks and reduces complexity and susceptibility to errors. Using DB-Harbour, many properties of the database can be queried and permanently checked through comparisons:

    - Are all Redolog groups created uniformly, and is there any indication that an adjustment makes sense?
    - Which database parameters are set or have been changed?
    - Are all tablespaces created correctly (e.g., size, autoextend, etc.)?
    - Do all databases have the same patch level?
    - How is the distribution of PDBs to CDBs, and can optimizations be made here?

    For large database environments, homogenization and standardization make sense wherever possible. This makes it easier to automate tasks and reduces complexity and susceptibility to errors. Using DB-Harbour, many properties of the database can be queried and permanently checked through comparisons:

    - Are all Redolog groups created uniformly, and is there any indication that an adjustment makes sense?
    - Which database parameters are set or have been changed?
    - Are all tablespaces created correctly (e.g., size, autoextend, etc.)?
    - Do all databases have the same patch level?
    - How is the distribution of PDBs to CDBs, and can optimizations be made here?

  • In addition to database metadata (classic queries from the V$- or DBA_-views), there is usually also application-specific information that can be evaluated with DB-Harbour. Here are some use cases that can be implemented on the tables or views using your own rules and corresponding select privileges:

    - Checking and historizing runtimes or results of batch runs (e.g., in your DWH environment).
    - Collecting and evaluating application-specific log tables.
    - Are there problems in application schemas of the databases (e.g., invalid objects, blocked users, or "broken" jobs)?
    - All other information that is of interest and can be queried via a select statement.

    In addition to database metadata (classic queries from the V$- or DBA_-views), there is usually also application-specific information that can be evaluated with DB-Harbour. Here are some use cases that can be implemented on the tables or views using your own rules and corresponding select privileges:

    - Checking and historizing runtimes or results of batch runs (e.g., in your DWH environment).
    - Collecting and evaluating application-specific log tables.
    - Are there problems in application schemas of the databases (e.g., invalid objects, blocked users, or "broken" jobs)?
    - All other information that is of interest and can be queried via a select statement.

How does it work

 

Description of DB-Harbour Web-Application

How does it work

If you want to know current waits, tablespace stats, logged-on users, or whatever is selectable, all you have to do is enter a suitable select. All tables containing results based on your query will be created automatically and can be browsed for one, some, or all databases in your repository.

DB-Harbour has two types of data:
1) Basedata: Representing your repository (databases, environments, applications, domains, and hosts).
2) Dynamic data: Will be created when you add rules (select statements), which will be executed on databases defined in your basedata repository.

In the background, DB-Harbour uses DB-Links or JDBC (recommended) to execute the queries.

To run DB-Harbour, all you need is an Oracle Database (holding the DB-Harbour repository and executing queries), a web server with Oracle Client and PHP installed for operation & presentation and a read-only user (schema with select privileges only) on all databases you would like to query.

 

Core Features

 

  • Create new rules (select queries) or use predefined rules, assign them to a subset or all databases, and let them be executed in customizable intervals. It is possible to create multiple different select queries per rule. Additionally, you are able to restrict select queries on database version, database role, or cluster type. Beyond this, you have the opportunity to select values from CBD only and map the result set to PDBs in the DB-Harbour repository.
    All tables created by your rules can be browsed, filtered, sorted, and customized (column format type / visibility) according to your wishes.

    Create new rules (select queries) or use predefined rules, assign them to a subset or all databases, and let them be executed in customizable intervals. It is possible to create multiple different select queries per rule. Additionally, you are able to restrict select queries on database version, database role, or cluster type. Beyond this, you have the opportunity to select values from CBD only and map the result set to PDBs in the DB-Harbour repository.
    All tables created by your rules can be browsed, filtered, sorted, and customized (column format type / visibility) according to your wishes.

  • Before new data will be queried, old results can be deleted or archived. You have the choice between differential archiving (only values changed since the last run) or complete archiving (all values for a certain date/time).
    Depending on which interval was chosen for the rule, archiving can lead to massive data growth. Because of this, it is also possible to compress archived values using customizable compression windows and aggregation functions for each result column of your query. So you can compress data without losing the information that matters for each individual rule.

    Before new data will be queried, old results can be deleted or archived. You have the choice between differential archiving (only values changed since the last run) or complete archiving (all values for a certain date/time).
    Depending on which interval was chosen for the rule, archiving can lead to massive data growth. Because of this, it is also possible to compress archived values using customizable compression windows and aggregation functions for each result column of your query. So you can compress data without losing the information that matters for each individual rule.

  • Once a rule is executed and results are loaded, it is possible to transport all or a subset of values to a basedata table with the same structure. After the transfer, the values can be adjusted and mapped to environments or applications. Based on this data, you are now able to control which columns should be compared in what manner. This feature allows you to rapidly set up conformity management for every rule you want this for. With the help of this, you can create a User-Management to check profiles and default tablespaces or a Parameter-Management to check database parameters, for example.

    Once a rule is executed and results are loaded, it is possible to transport all or a subset of values to a basedata table with the same structure. After the transfer, the values can be adjusted and mapped to environments or applications. Based on this data, you are now able to control which columns should be compared in what manner. This feature allows you to rapidly set up conformity management for every rule you want this for. With the help of this, you can create a User-Management to check profiles and default tablespaces or a Parameter-Management to check database parameters, for example.

  • With DB-Harbour, you can create graphs that are based on your basedata or dynamic data (created by rules). It is also possible to create graphs out of archived & compressed data. DB-Harbour allows you to create views in order to combine data from different rules or basedata. Besides all common graph types such as bar, area, pie, etc., a gauge type is also available for faster compliance checks of your comparison results. The look of graphs (colors, fonts, etc.) is adaptable with the help of custom styles. On top of that, logarithmic presentation of values or stacked value graphs are achievable. The graphs are interactive and provide features such as timeline zooming or deselection/selection of values, for example.

    With DB-Harbour, you can create graphs that are based on your basedata or dynamic data (created by rules). It is also possible to create graphs out of archived & compressed data. DB-Harbour allows you to to create views in order to combine data from different rules or basedata. Besides all common graph types such as bar, area, pie, etc., a gauge type is also available for faster compliance checks of your comparison results. The look of graphs (colors, fonts, etc.) is adaptable with the help of custom styles. On top of that, logarithmic presentation of values or stacked value graphs are achievable. The graphs are interactive and provide features such as timeline zooming or deselection/selection of values, for example.

  • Finally, you can use your graphs and gathered data to create dashboards, PDF reports, and slideshows. In addition, contexts (groups of databases) or context groups can be defined. Contexts allow you to create dashboards, which automatically perform a refresh and iterate through the defined context. The content of tables and graphs on the dashboard is only shown for the current context. Also, PDF reports can use the advantage of database contexts, of course. With the help of slideshows, multiple dashboards can be shown successively.

    Finally, you can use your graphs and gathered data to create dashboards, PDF reports, and slideshows. In addition, contexts (groups of databases) or context groups can be defined. Contexts allow you to create dashboards, which automatically perform a refresh and iterate through the defined context. The content of tables and graphs on the dashboard is only shown for the current context. Also, PDF reports can use the advantage of database contexts, of course. With the help of slideshows, multiple dashboards can be shown successively.

Security

Security

When enabling users to execute statements across multiple databases simultaneously, ensuring a high level of security is crucial. In the Oracle backend, multiple schemas are used to enforce separation of duties and strict data isolation.

On all target databases, only users with read-only (SELECT) privileges are allowed. Even if a more privileged user were configured, DB-Harbour prevents any DML or DDL execution through strict prechecks using sandbox users and validation mechanisms. This ensures that such operations cannot be executed unintentionally or maliciously.

On the application (web frontend) level, user access is managed through a system of groups and granular privilege settings. Access to specific databases, rules, environments, and individual features can be controlled precisely. DB-Harbour is also multi-tenant capable, allowing different clients to be defined with isolated access.

 

Additional Features

Custom basedata tables and fields can be created to add non technical information (CSI or contact persons for example)
CSV-Export for all tables and CSV-Import for basedata tables (helps to build up your repository really fast).
TNS-Names import to get all databases imported at once (when having a global tnsnames.ora file)
Duplicate detection to avoid having configured the same database multiple times.
Automatic CDB/PDB, RAC and Data-Guard detection and historicization of database changes.
PL/SQL interface, which can be integrated in your automation process, to keep data up to date automatically.
Customizable parallel degree for intervals and timeouts for rules to help everything runs smoothly.
Use and create own categories helping you to organize results of rules in different folders.
View Builder to combine or aggregate basedata and dynamic data and automatic hierarchical view creation for every rule.
Global filters (time range & databases) for browsing complete repository precisely.
Add permanent private and public filters that can be used for dashboards and reports.
Change data formatting of all dynamic tables and add custom formats.

 

Start to cargo your Metadata now...

 

File Icons

Start to cargo your Metadata now...

...To fully utilize and benefit from it!

Don't hesitate to ask us for a presentation, demo version, or pricing of DB-Harbour. Write to dbh@data-appstairs.com or simply call us at +49 (0) 9131 6824 300.

We can also help you with integrating DB-Harbour into your current setup or using it partially to connect it with existing applications. Additionally, we support you in creating rule sets (to implement use cases described above, for example). Furthermore, an open-source, lightweight version (PL/SQL & JDBC only) can be implemented into your existing repository, enabling you to gather data from your Oracle databases in the same way.