Azure Data Catalog FireDAC Components

FireDAC を使ってAzure Data Catalog にSQL で接続

Delphi とC++ Builder アプリをAzure Data Catalog にリアルタイム接続。簡単かつ高速です。


  ダウンロード   価格

Microsoft Azure 関連ドライバーはこちら


Azure Data Catalog FireDAC Component を使えば、Delphi & C++ Builder アプリケーションからAzure Data Catalog データに簡単に連携できます。 Rapidly create and deploy powerful Delphi & C++Builder Apps that integrate with Azure Data Catalog.

機能紹介

  • SQL access to the full Azure metadata catalog
  • Connect to live Azure Data Catalog data, for real-time data access
  • Full support for data aggregation and complex JOINs in SQL queries
  • Secure connectivity through modern cryptography, including TLS 1.2, SHA-256, ECC, etc.

Specifications

  • Native FireDAC Components for Azure Data Catalog seamlessly integrate with RAD Studio
  • Full Unicode support for data, parameter, & metadata
  • Support for 32-bit & 64-bit operating systems
  • Requires Delphi, C++ Builder, or RAD Studio 10.2 Professional or higher


AVAILABLE IN:
FireDAC SUBSCRIPTIONS
225+ FireDAC Drivers For Real-Time Data Access
詳細

FireDAC Components

あらゆるデータソースにRDB と同感覚で連携が可能に



標準FireDAC Components


MySQL やSQL Server のようなRDBMS への接続と同感覚。 TDFManager、TDFConnection、TDFQueryUse といった標準FireDAC components として。


	FDConnection1.Name := 'AzureDataCatalogConnection';
	FDConnection1.DriverName := 'CData.Fire.AzureDataCatalog';
	with FDConnection1.Params as
	    TFDPhysCDataAzureDataCatalogConnectionDefParams do begin

	    ...
	end;


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

	...

	

Type SQL, Get Azure Data Catalog


データ連携アプリケーションを開発する最適解。 RDBMS の扱いと同感覚で、Azure Data Catalog への連携を、標準SQL で実装可能。JOIN、更新系、集計など多彩なSQL サポート。

SELECT WITH INNER JOIN

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

集計関数

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

CRUD 処理

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


エンタープライズレベルの機能