ノーコードでクラウド上のデータとの連携を実現。
詳細はこちら →
SAS Data Sets FireDAC Component を使えば、Delphi & C++ Builder アプリケーションからSAS Data Sets データに簡単に連携できます。 Rapidly create and deploy powerful Delphi & C++ Builder Apps that integrate with SAS Data Sets.
機能紹介
- Connect to live SAS Data Sets data, for real-time data access
- Full support for data aggregation and complex JOINs in SQL queries
- Generate table schema automatically based on existing SAS Data Sets data or manually for greater control of the content you need
Specifications
- Native FireDAC Components for SAS Data Sets 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 := 'SASDataSetsConnection';
FDConnection1.DriverName := 'CData.Fire.SASDataSets';
with FDConnection1.Params as
TFDPhysCDataSASDataSetsConnectionDefParams do begin
...
end;
FDConnection1.Connected := true;
FDQuery1.Active := true;
FDQuery1.Open('select * from SASDataSetTable');
...
Type SQL, Get SAS Data Sets
データ連携アプリケーションを開発する最適解。 RDBMS の扱いと同感覚で、SAS Data Sets への連携を、標準SQL で実装可能。JOIN、更新系、集計など多彩なSQL サポート。
SELECT WITH INNER JOIN
SELECT SASDataSetTable.Id, SASDataSetTable.Name, SASDataSetTable.Fax, Opportunity.AccountId, Opportunity.CloseDate FROM SASDataSetTable INNER JOIN Opportunity ON SASDataSetTable.Id = Opportunity.AccountId
集計関数
SELECT Name, AVG(AnnualRevenue) FROM SASDataSetTable GROUP BY Name
CRUD 処理
UPDATE SASDataSetTable SET Name='John' WHERE Id = @myId