詳しくはこちら
 
Sage 50 UK
 

Sage UK FireDAC Components

Delphi & C++Builder アプリの外部データ接続機能を拡張！

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


  ダウンロード   価格

Sage Accounting 関連ドライバーはこちら

Sage Accounting 関連ドライバー


Sage 50 UK FireDAC Component を使えば、Delphi & C++ Builder アプリケーションからSage 50 UK データに簡単に連携できます。 Complete read-write access to Sage 50 UK enables developers to search (Customers, Transactions, Invoices, Sales Receipts, etc.), update items, edit customers, and more, from Delphi and C++Builder Apps.

機能紹介

  • SQL-92 access to local company datasets and datasets on network drives
  • Compatible with Sage 50 UK 2012 and above
  • Powerful metadata querying enables SQL-like access to non-database sources
  • Push down query optimization pushes SQL operations down to the server whenever possible, increasing performance
  • Client-side query execution engine, supports SQL-92 operations that are not available server-side
  • Connect to live Sage 50 UK 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 Sage 50 UK seamlessly integrate with RAD Studio
  • Comprehensive support for CRUD (Create, Read, Update, & Delete)
  • 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 := 'Sage50UKConnection';
	FDConnection1.DriverName := 'CData.Fire.Sage50UK';
	with FDConnection1.Params as
	    TFDPhysCDataSage50UKConnectionDefParams do begin

	    ...
	end;


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

	...

Type SQL, Get Sage 50 UK


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

SELECT WITH INNER JOIN

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

集計関数

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

CRUD 処理

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


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