The drive to continually improve Oracle Applications reporting for our customers has led to technology advances unsurpassed in the market. Innovation is key to our success—our customers are our inspiration.
The technology behind Noetix’s reporting solution for Oracle Applications begins
with the metadata discovery and generation capabilities encompassed in Noetix
MetaBuilder. This patented technology deciphers the customer’s unique
implementation of an enterprise application and automatically generates
configuration-specific business views and pre-built reports. The generated
reporting objects known as Noetix views and Noetix answers provide instant
operational reporting. Noetix MetaBuilder technology works out-of-the-box for
Oracle E-Business Suite.
Patented technology for accessing data from disparate data sources and for executing federated queries is instrumental to Noetix’s reporting platform. The core functionality of Noetix QueryServer envelops this query routing technology. Noetix QueryServer receives requests in the form of SQL from the Noetix Connect component on a web server; it parses the SQL and rewrites it for the correct data sources. The server, connection and authentication information for the data source is included. The rewritten SQL with the associated information is then passed back to the web server which then executes the query directly against the data sources. This provides scalability and load balancing at the web server level as well as transparent access to any data in the enterprise regardless of the physical location of the data.
AJAX and SOA
In 2001, the advent of web services popularized the use of open standards such as SOAP and WSDL. Noetix WebQuery was enhanced to conform to the use of these technologies. The term SOA (Services Oriented Architecture) is the latest term to describe architectures using these technology types. SOA has been used extensively while designing and building new features and functionality of both Noetix QueryServer and Noetix Dashboard. Components such as Noetix Delivery Server and Noetix Dashboard Viewer adhere to SOA best practices. In the future, Noetix plans to re-factor our complete product suite to release a highly interoperable set of products using SOA.
Noetix was founded by providing reporting solutions for Oracle E-Business Suite based on the Oracle Database and related technology stack. When NoetixViews was first architected, the pioneering developers sought to leverage these technologies to provide the most seamless solution that could be easily integrated and maintained by IT organizations skilled in Oracle technologies. Database views, SQL, PL/SQL, SQL*Loader, and SQL*Plus form the main technology components of NoetixViews. Although these technologies have been available for decades, they will continue to be relevant and thrive in an Oracle environment.
The conceptual architecture visually displays the areas within business intelligence that Noetix supports. This includes the Enterprise Applications (the data sources); the unique Metadata Discovery and Generation technology of Noetix; amalgamation with Data Integration and ETL tools; together delivering reporting objects comprised of Business Views and Pre-Built Reports along with a user experience via the Query, Reporting and Data Visualization Tools.
The Solution Selector allows you to choose the particular BI technology stack of interest—Noetix, Oracle, Cognos, Business Objects, Microsoft or Informatica—and the resultant conceptual architecture. The Solution Selector is not representative of all possible solutions as Noetix views reside in an Oracle Database and therefore support any tool that can connect to the database. However, choosing a particular solution will reveal the relationships between Noetix products and the most common vendor products used to create a robust BI technology stack.