Active Explorer

Product Focus

Real-time view of any Oracle database Schema in the form of a visual data model.

Product Description

Active Explorer is a simple means of empowering the sophisticated as well as novice Oracle user with the ability to view any Oracle schema in the form of a simple data diagram, with no changes allowed. Thus, all Oracle database objects can be easily browsed by any user.

Product Architecture

The solution architecture is highly scalable. It can support hundreds of users and thousands of devices. It has multiple options to support active-active or active-passive architectures.

  • Database Compatibility:

    Oracle

    SQL Server

    DB2

  • Operating System Compatibility:

    Windows95/98/ME

    WindowsNT/2000 client connecting to ANY Database on the corporate network

  • Technical Requirements:

    Pentium 100MHz or higher

    10MB hard disk space

    64 MB RAM (128 MB recommended).

Benefits

  • Active Scheduler allows each and every Oracle developer to take complete control of SQL and PL/SQL program execution by providing a powerful mechanism for making schedules such that programs execute at a particular time of the day, week or month, and depending on certain conditions being met.
  • Alerts can be sent globally, depending on database field values, e.g. send and email to a person ABC when the order number ORD-XYZ is booked.
  • Extremely simple to set up and use, by any Oracle developer.
  • Migrate Data (DML) changes across database users, instances, and between ORACLE, MS-SQL Server and SYBASE simply, by creating schedules using ActiveScheduler.

Application Area

  • Data Warehouse applications where tables need to be cleaned depending on specific conditions.
  • Email notification requirement to setup a workflow for an approval process.
  • Database Change Management auto-notification scheduling.
  • Warning systems to alarm administrators of irregular activity.
  • Automate Data Migration functionality across the enterprise.
  • Automatic paging for sales and support personnel depending customer requests.
  • Schedule publishing of XML and other data queries on the WEB.