Patented.  Tested.  Proven.

Since the deployment of the first “out-of-the-box” enterprise applications, access to operational data has been an ongoing challenge for IT organizations. The billions of dollars spent on these enterprise applications and subsequent query and reporting tools has left decision makers unable to answer their own business questions due to the complexities of such systems. As management continues to demand improved operational visibility, requiring robust yet flexible reporting capabilities, IT departments and reporting administrators have grown increasingly frustrated by the challenge of a never-ending report development and maintenance effort. 

The Business Intelligence Challenge

Since most enterprise applications are designed for transactional efficiency, their databases contain complex data structures that make little sense to the non-technical professional, impeding their ability to build reports on their own. A true user-friendly reporting solution requires that a meaningful business terminology-to-database mapping or “metadata layer” be built before any report development can begin. Query and reporting tools from leading Business Intelligence (BI) software vendors such as Business Objects, Cognos, and Microsoft provide generic metadata templates which attempt to jumpstart the mapping effort, but require a significant amount of manual effort to connect it all together. The setup and maintenance of this metadata layer is both labor intensive and costly.

No two organizations implement and configure ERP and CRM solutions in exactly the same way. A true plug-n-play reporting solution—as marketed by many BI vendors—has not been achieved. The one-size-fits-all approach to a metadata layer isn’t a viable solution due to custom business rules, specific user roles, and security, as well as unique organizational hierarchies. The challenge of implementing a relatively generic BI solution is very difficult.

Bridging the information gap between application complexity and reporting simplicity is the challenge in implementing, deploying, and maintaining BI technologies for any organization.

The Noetix Solution

With a history of innovation and Oracle expertise, in 1994 Noetix began perfecting a faster, easier way to bridge the information gap. For more than a decade, Noetix has developed, refined, and improved the technology known as Noetix MetaBuilder. Noetix MetaBuilder simplifies reporting by:

  • Scanning an enterprise application’s setup,
  • Discovering its unique configurations, and
  • Generating metadata.

The generated metadata enables organizations to quickly create and maintain business terminology-to-database mappings that jumpstart the report development effort. Noetix MetaBuilder can regenerate your metadata layer time and again to keep it synchronized with your application.
This generated metadata is the foundation for the NoetixViews family of products.

Noetix MetaBuilder takes three sources of metadata and combines them to create a metadata layer tailored to the organization’s application environment.

Two sources of metadata are provided with NoetixViews out-of-the box. These are the business metadata and the technical metadata. They map the business terminology to the database structure. This “handcrafted” metadata has been built and maintained by Noetix for more than 12 years, utilizing input and feedback from Noetix customers.

The third source of metadata is dynamically extracted from the customer’s application configuration referred to as the application metadata. This metadata is used to tailor the reporting objects to reflect the organization’s business terminology, ensuring that the unique characteristics of the application are captured.

How a Metadata Layer Empowers End Users to Answer their Questions

The automatic generation and regeneration of a metadata layer is a clear benefit to the IT organization not only in the time and cost savings, but also from the standpoint that end users can tap into this resource to begin answering their own business questions—freeing up IT staff to work on other more critical projects.

The reporting objects generated by Noetix MetaBuilder are accessible through the end users’ tool of choice in familiar business terminology such as Company Name and Department versus technical terms like ATTRIBUTE4 and SEGMENT12. The closer the metadata view of the data resembles the common business object, the greater the likelihood a non-technical professional will succeed at writing their own ad hoc reports.

How It Works

Noetix MetaBuilder takes three sources of metadata and combines them to create a metadata layer tailored to the organization’s application environment.

Two sources of metadata are provided with NoetixViews out-of-the box. These are the business metadata and the technical metadata. They map the business terminology to the database structure. This “handcrafted” metadata has been built and maintained by Noetix for more than 12 years, utilizing input and feedback from Noetix customers.

The third source of metadata is dynamically extracted from the customer’s application configuration referred to as the application metadata. This metadata is used to tailor the reporting objects to reflect the organization’s business terminology, ensuring that the unique characteristics of the application are captured.