Escendo Analytics

Escendo Architect

Escendo Analyzer

---

Escendo Architect: Build and Manage In-Database Analytics

Developers and administrators can access the powerful Escendo Analytics application framework through Architect, with functionality to build and manage applications, structures, models, rules, code for deploying and managing a sophisticated in-database analytical environment. Architect can add capabilities to a broad range of functional roles:

• Developers:

  A flexible workbench which allows not only coding, and object creation and modification, Escendo Architect gives you command line access for interative testing and development. The Escendo Analytics platform leverages and extends the power and functionality of the Oracle OLAP Option DML. Other features support multi developer activities which allow more code reuse, and a number of features such as intellligent cascading deletes, auto-matching brackets and parentheses save time and help avoid mistakes.

• Database Administrators:

  Besides being good for performance and real-time analytics, being inside the database, Escendo offers full compatibility with RMAN, archivelog, flashback query, flashback table and partitioning. Yes, we map logical to physical partions to allow your dbas to manage your data more effectively.

• Development Managers:

  A fully automated mutli-developer environment allows collaborative teamwork in the development cycle. Allowing developers to work in the same environment instead of multiple copies allows a steamlined, effective development cycle.

• Quality Control:

  A robust multi-developer environment with check-out-check-in, version control with optional subversion integration can both help teams to reduce errors as well as time to resolve issues. Automatically matches <> and () structures as you are programming to help ensure code is correct, and reduce tedious structural de-bugging. Other features include promotion and multi-environment controls, code comparison across versions and workspaces

• Information Security:

  Escendo Architect allows multiple levels of access and control so that you can contol access and manipulation of structures and code by object type.

• Business Managment:

  Fewer coding errors, faster development and lower cost to maintain more advanced features means getting critical business information ready and available faster and more accurately.

Going Beyond OLAP to True In-Database Analytics

Most Business Intelligence technologies make you trade-off between powerful analytics and large data sets. Some proprietary cube technologies do a great job at exposing complex analyses, but are able to practically handle significantly less data than robust databases such as Oracle. SQL-based OLAP technologies can generally access more data than their cube brethren, but do so at the cost of reduced analytics, and increased management complexity and expense.

Escendo Architect helps you deploy your most demanding analytical applications, and truly get the best of both worlds; the ability to easily handle advanced analytics, while leveraging the strength, speed, and scalability of the world's most powerful database.

Oracle Express Migrations

For those companies currently using Oracle Express (including OFA, OSA, and custom applications), Escendo Architect empowers quick and easy migrations of their existing Express applications to Escendo Analytics with complete protection for data, hierarchies, models, formulae, and programs as well as most reports. By converting to Escendo Analytics, Express users get a powerful and integrated solution for preserving the functionality and stability of their Express applications while eliminating the costs, complexities, and constraints of changing OLAP technologies.

Of course, by using Escendo Architect to migrate your Express applications to Escendo Analytics, you have a perfect opportunity to improve the performance, scalability, and manageability of your decision support application. Best practices would mandate a review of processes structures and user access, but with an Escendo conversion changes and rework can be done selectively vs wholesale reimplementation. This not only makes for a better application today, but it provides an environment that will continue to meet the demands of users for years to come. Preserve and extend your ROI instead of throwing away the capital already invested.

To learn more about migrating Express applications to Escendo Analytics using Architect, read our Express Migrations Overview.