SQL Analysis Services FireDAC Components

Rapidly create and deploy powerful Delphi & C++Builder Apps that integrate with SQL Analysis Services.

  • Connect to SQL Analysis Services data from Rad Studio Data Explorer.
  • Supports Direct query and MDX query capabilities
  • Easy-to-use client library enables developers to easily integrate Delphi & C++Builder Apps with SQL Analysis Services report data.

  download beta

CData FireDAC Components for SQL Analysis Services
 Included in FireDAC Subscriptions: 125+ Components for real-time data access.

Extend Delphi & C++Builder Apps with unrivaled data connectivity!

SQL Analysis Services FireDAC Components Included in Enterprise Subscriptions


Get the SQL Analysis Services FireDAC Components together with 125+ additional components for SaaS, NoSQL, and Big Data integration! Our components offer the fastest & easiest way to build data driven Apps.

  • More than 125+ FireDAC Components for NoSQL, Big Data, & SaaS integration.
  • One year of free updates, upgrades, new releases, and support.

Learn More  



FireDAC Components in Action

Connecting to Any Data Source is as Easy as Connecting to a Database



Standard FireDAC Components


Just like connecting with a typical RDBMS like MySQL. or SQL Server. Use standard FireDAC components like TDFManager, TDFConnection, TDFQuery, etc.


FDConnection1.Name := 'SQLAnalysisServicesConnection';
FDConnection1.DriverName := 'CData.Fire.SQLAnalysisServices';
with FDConnection1.Params as     
    TFDPhysCDataSQLAnalysisServicesConnectionDefParams do begin

    ...
end;


FDConnection1.Connected := true;
FDQuery1.Active := true;
FDQuery1.Open('select * from SSASData');

...

Type SQL, Get SQL Analysis Services


The easiest way to build data-centric applications. Write standard SQL queries to interact with SQL Analysis Services, just like working with any RDBMS. Supports joins, updates, aggregation, and more.

SELECT WITH INNER JOIN

SELECT SSASData.Id, SSASData.Name, SSASData.Fax,     
  Opportunity.AccountId, Opportunity.CloseDate
FROM SSASData
INNER JOIN Opportunity
  ON SSASData.Id = Opportunity.AccountId

AGGREGATE FUNCTIONS

SELECT Name, AVG(AnnualRevenue) FROM SSASData GROUP BY Name

CRUD OPERATIONS

UPDATE SSASData SET Name='John' WHERE Id = @myId



Powerful Enterprise features