iWay Software's Data Adapter for Essbase – XML, SQL, JDBC, and ODBC-Based Enterprise Integration
Accelerating Essbase Integration
iWay Software's intelligent Essbase adapter provides highly efficient access to Essbase data. The adapter is engineered in the same way as other iWay data adapters, so developers may use ANSI-standard SQL statements to access Essbase data from any iWay tool. Third-party products can also access the adapter via iWay connectors, including ODBC, OLE DB, JDBC, XML, iWay Business Services (Web services), and others. In addition, data may be integrated with more than 300 other information sources, including other relational and nonrelational databases, transaction systems, custom or packaged applications, message-oriented middleware, XML documents, EDI networks, and more.
How iWay Intelligent Data Adapters Work Together
All iWay Intelligent Adapters are designed for consistent operation within iWay's robust middleware framework, thereby minimizing the skill sets required to use each database and support new projects. Each adapter consists of a communications interface, an SQL translator that manages adapter operations in either SQL or iWay's universal Data Manipulation Language (DML), and a database interface that translates ANSI SQL into native API calls. Multiple iWay adapters running on the same platform can all share communications and translation components for greater efficiency.
Highly Optimized for Essbase
The iWay Intelligent Adapter for Essbase receives ANSI-standard SQL requests and translates them into iWay's universal DML. These DML statements are used to access the target database using Essbase client API calls to retrieve data targeted in the request.
Special features and settings for iWay's Essbase Adapter include:
- Support for Parent/Child views as well as Federation views
- Support for all eight levels of period-to-date reporting
- Ability to handle Scenario dimensions as normal dimensions or as pseudo account dimensions
- ALIAS names support
- Substitution Variable support
- Ability to access multiple servers
- Ability to treat any dimension as an Accounts/Measures dimension without altering the Accounts TAG in the outline
- Read-only capability
Special iWay Performance Features
The iWay adapter directly provides query control via the RECORDLIMIT feature to reduce communication traffic, CPU usage, and I/O activity. iWay's Resource Analyzer and Resource Governor products may also be used to analyze and control resources on a global basis independently of the adapter being used.
Some of our other Intelligent Adapters include:
Find Out More
For More Information
No other company provides the kind of sophisticated data integration and SOA-based integration technology that iWay Software does. To find out more, call toll-free (866) 297-4929 or e-mail us at info@iwaysoftware.com.
