|
The Enterprise Blocks database services allow a client environment to interact with a target database. These services allow information about a data model to be queried from a client. They also allow powerful analyses to be created and executed against a database returning the results to a client.
|
|
Below is a description of the Enterprise Blocks database service providers.
|
OLE DB for OLAP (ODBO)
This service provider uses ADO to communicate with an ODBO data source including Microsoft Analysis Services. This provider implements all 50+ expression classes inside the Enterprise Blocks Expressions namespace. This means that just about any MDX script including any MDX function can be created using object-oriented programming with the Enterprise Blocks object model. Data analyses can include time-series analysis, rank/sort, and exceptions. Additional functions were also added including a query for members using a string search against member names. Additional features include support for cross-hierarchy analysis, custom scripts, named sets, and dimension members.
Download | Buy
|
XML for Analysis (XMLA)
This service provider uses the .NET managed provider ADOMD.NET to communicate with XML data sources including Microsoft Analysis Services, Hyperion Essbase, and SAS. This provider is currently in beta.
Download Beta
|
Microsoft SQL Server
This service provider uses the .NET managed provider classes in System.Data.SQLClient namespace to communicate with Microsoft SQL Server. This provider supports both cross-tab and table analysis directly against tables and views in SQL Server. The field relationships defined in the database are used to support cross-tab analysis. Additional field relationships can also be set up using SQL Server extended properties. SQL Server extended properties can also be used to specify field formatting, aggregation functions, and visibility and to set up user-friendly names for fields, tables, and views.
Download | Buy
|
