Fast analysis, better insight and rapid deployment with minimal IT involvement! These are the leading benefits of in-memory analytics.

In-memory analytics delivers decision insight with the agility that businesses demand. It’s a win for business users, who gain self-service analysis capabilities, and for IT departments, which can spend far less time on query analysis, cube building, aggregate table design, and other time- consuming performance-tuning tasks.

There was a time when the select few business intelligence users within your organization were happy to get a weekly report. Today, smart companies are striving to spread fact-based decision-making throughout the organization. This does not require expensive, hard-to-use tools that require extensive IT hand holding. Yellowfin’s in-memory database is ideal platform for making this possible.

To enable report writers to see information in business terms, Yellowfin provides a metadata layer.

This tool allows an administrator to map physical data into a simplified business view. The administrator or analyst can define key properties about the data, such as field definitions, reference code lookups and properties (eg. dimension, measure, non-additive measure, etc). The analyst can also create custom calculations such as ratios, averages, etc.

Users interact with the meta data layer and as such do not have to understand the complexity of the underlying data or database. They view data in simple business terms.

Yellowfin has a robust security model that ensures the security of your BI implementation. The areas on which Yellowfin is focused are:

1. User Authentication - Confirming that the person accessing Yellowfin is a known user, and that their identity can be verified.
2. User Authorisation - Determining the Yellowfin functionality, reports, and data that the user is authorized for. This includes:
   a. Role and functional security
   b. Report entity access
   c. Data level security
   
3. Internet architecture and transmission security - Ensuring that information delivery is secure and prevents unauthorized access.

Yellowfin can connect to and report from any database that has a JDBC driver and that supports SQL-92 compliant SQL.

Yellowfin can report from the following databases:

• DB2 Universal Database 8.1 or later
• Oracle Database 9i+
• PostgreSQL 8.0
• Progress 9.1
• MS SQL Server 2000+
• Ingres
• MySQL 4+
• HSQL
• MDX compliant cubes (eg SQL Server, Mondrian)
• ODBC
• OpenEdge
• AS/400
• Interbase
• Universe
• Firebird
• Cache DB
• Pervasive
• Sybase ASE
• Sybase Anywhere
• Sybase IQ
• SQLite
• Derby
• Teradata
• H2
• FoxPro
• Lotus Notes
• Microsoft Access