Our experience in Data Management and Enterprise applications has made it possible to develop a marvelous data masking tool!


Data Terrains data masking tool masks sensitive data in Non-Production environments by an automated process. It reduces the risk of a data breach, which is more vulnerable in Non-Production environments where data is more vulnerable. This masking activity is irreversible. Using this Data Terrains masking tool, customers can be compliant with various privacy laws.

Sensitive Data Discovery

Data Terrains masking tool scans the data dictionary to find all sensitive data. It produces a configuration file before proceeding with the next step of data masking. Users can also customize the config file by adding or removing the column names in the config file. All the sensitive columns in the config file will be encrypted/masked using industry-leading standards. Our masking tool masks sensitive data while retaining referential integrity and data uniqueness, is flexible to take instructions from users on customization and suggests standards.

DB Features

• Generate report listing details of all users in the database.
• Option to LOCK all or a specific user in database.
• Option to UNLOCK all or a specific user in database.
• Option to GRANT a ROLE to all [PUBLIC] or a specific user in database.
• Option to REVOKE a ROLE from all or a specific user in database.

OS Features

  • Check if root ID exists with UID 0 and root login is Enabled/Disabled.
    Report listing SUDO users in the server.
    Generate report listing NON SUDO users in the server.
    Generate memory (RAM/SWAP) utilization (Total/Used/Free) report at specific intervals in the server.
    Generate Filesystem Utilization report and alert when utilization exceeds threshold limit.
    Generate Report listing all Running/Stopped/Disabled services in the server.
    Generate Report listing firewall details in the server.
    Generate Report listing all packages installed in the server.
    Generate User Detail report listing System Users/Non-System Users/Users belonging to SYS group.
    Generate User Activity (Login activity details, Abnormal time login details, Crash/Down details, Last Login details, Failed password attempts) report for all users or a specific user.
    Option to clean-up OS users.
    Generate report on File/Dir Permissions
    Listing Directories and Files with 777 Permissions
    Listing Files NOT owned by app id in the app directory.
    Generate report of Abnormal Files
    Listing Zero-byte files in the app directory
    Listing Files of size 0 Bytes to 5 KB in the app directory
    Generate report listing large files in the server with size exceeding the defined threshold limit / exceeding default size of 1 GB.
    Generate report listing the New/Deleted Files in app directory.
    Generate report mapping file to a process.
    Option to KILL process.
    Option to archive a directory.
    Option to Search for String Pattern in App directory.
    Generate report listing files accessed/modified specific days back.

Have you used Hyperion BRIO / SQR / IR reporting?

Try our BI DesignerPlus !

DataTerrain speeds the transition from Hyperion BRIO to Oracle OBIEE and OAC.

DataTerrain, a leader in the Business Intelligence domain for transition automation solutions, announced the launch of its BI DesignerPlus for customers looking to easily create more complex reports in OBIEE / OAC. If you have been using Hyperion BRIO / SQR / IR reporting for years, you can see why this product is so valuable.

While Oracle extended the support life of BRIO and announced the end of BRIO IR’s / SQR code development, it creates a need for supporting customers in newer products with popular features from the Hyperion world.

BI DesignerPlus from DataTerrain includes many popular BRIO features in the Oracle OBIEE / OAC reporting studio. The simple and user-friendly icons save enormous time and provide comfort for report developers to deliver complex reports in the Oracle OBIEE / OAC. BI DesignerPlus is a new plugin that extends for Oracle OBIEE / OAC, bridging gaps from the Hyperion BRIO to Oracle’s latest reporting platform.

The first benefit of using BI DesignerPlus is that complex OBIEE / OAC reports can be created with minimal XML coding or NO coding knowledge, saving time and costs.

The following are some of the critical features of BI DesignerPlus that make development easy:

  • CUME function support
  • Alternate row color for Tables
  • Suppression of Duplicates in Table
  • Distinct Count data aggregation for chart
  • Running Sum function
  • Running Count function

BI DesignerPlus brings the best report authoring tools (IR) features as an extension to Oracle OBIEE / OAC. It has a new graphical user interface (GUI) for easier chart creation and several other features that save considerable time in day-to-day report modification or design. As customers develop more complex reports or convert reports from existing BRIO platforms, BI DesignerPlus gives the Smart Report Creation advantage.

Time savings – the out-of-box functionalities significantly reduce the time to create a report—cost savings – reducing dependency on expert developers and manual errors.

DataTerrain is committed to being ahead of customer BI needs, delivering state-of-the-art solutions to increase business productivity while reducing costs. One product that will achieve this goal is BI DesignerPlus. Customers using BI DesignerPlus typically benefit from an 80% reduction in effort in creating BI Publisher reports. Please let us know if you are looking for a demo!