詳しくはこちら
 
Google Campaign Manager
 

DoubleClick FireDAC Components

FireDAC を使ってGoogle Campaign Manager にSQL で接続

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


  ダウンロード   価格

Google 関連ドライバーはこちら

Google 関連ドライバー


Google Campaign Manager FireDAC Component を使えば、Delphi & C++ Builder アプリケーションからGoogle Campaign Manager データに簡単に連携できます。 An easy-to-use database-like interface for Delphi & C++Builder Apps to access live DoubleClick Campaign Manager data (Ads, Accounts, Creatives, Orders, and more).

機能紹介

  • Work with a relational model of your DoubleClick Campaign Manager data based on dimensions and metrics
  • Connect to live Google Campaign Manager 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 Google Campaign Manager 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 := 'GoogleCampaignManagerConnection';
	FDConnection1.DriverName := 'CData.Fire.GoogleCampaignManager';
	with FDConnection1.Params as
	    TFDPhysCDataGoogleCampaignManagerConnectionDefParams do begin

	    ...
	end;


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

	...

Type SQL, Get Google Campaign Manager


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

SELECT WITH INNER JOIN

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

集計関数

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

CRUD 処理

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


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