Content area
Full text
I recently had the opportunity to try Meta X Database Intelligences ExtendX Data Unlimited 2.0, which works with an in-memory data structure. Similar to the functionality seen in Microsoft Excel, ExtendX provides drag-and-drop functionality for creating pivot tables and pivot charts. ExtendX lets you analyze a relational data set consisting of one or more tables, much in the same way you analyze an OLAP data source and with similar query speed.
ExtendX requires the Microsoft .NET Framework 4.0 or later. It supports data stored in SQL Server, DB2, Microsoft Access, and Pervasive SQL.
Installing the product is very simple and quick. You download the executable from CNET'S Download.com using a link provided by ExtendX, then run the executable.
Once installed, you just need to configure three connection strings and enter the license key. The connection strings arc created using a familiar interface that builds each string for you and utilizes either Windows or SQL Server authentication. The product needs the connections to access the main database (which holds the data you want to analyze), repository database (which stores views of your data), and ExtendX database (which stores metadata used by the product). You only need read permissions on the main database, as it's never altered....