ノーコードでクラウド上のデータとの連携を実現。
詳細はこちら →
SharePoint Excel Services FireDAC Component を使えば、Delphi & C++ Builder アプリケーションからSharePoint Excel Services データに簡単に連携できます。 Rapidly create and deploy powerful Delphi & C++Builder Apps that integrate with live Excel Spreadsheet content hosted on SharePoint server!
機能紹介
- Access SharePoint Excel Services data either as an entire worksheet or from discrete ranges of data within a worksheet
- Represent discrete blocks of data as tables through automatic detection or by manually specifying ranges of data
- Optionally specify if the first row of data should be used for field names
- Compatible with SharePoint 2013 and 2016, Excel 2007+
- 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 SharePoint Excel Services 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 SharePoint Excel Services 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
200+ FireDAC Drivers For Real-Time Data Access
詳細
FireDAC Components
あらゆるデータソースにRDB と同感覚で連携が可能に
標準FireDAC Components
MySQL やSQL Server のようなRDBMS への接続と同感覚。 TDFManager、TDFConnection、TDFQueryUse といった標準FireDAC components として。
FDConnection1.Name := 'SharePointExcelServicesConnection';
FDConnection1.DriverName := 'CData.Fire.SharePointExcelServices';
with FDConnection1.Params as
TFDPhysCDataSharePointExcelServicesConnectionDefParams do begin
...
end;
FDConnection1.Connected := true;
FDQuery1.Active := true;
FDQuery1.Open('select * from ExcelSheet');
...
Type SQL, Get SharePoint Excel Services
データ連携アプリケーションを開発する最適解。 RDBMS の扱いと同感覚で、SharePoint Excel Services への連携を、標準SQL で実装可能。JOIN、更新系、集計など多彩なSQL サポート。
SELECT WITH INNER JOIN
SELECT ExcelSheet.Id, ExcelSheet.Name, ExcelSheet.Fax, Opportunity.AccountId, Opportunity.CloseDate FROM ExcelSheet INNER JOIN Opportunity ON ExcelSheet.Id = Opportunity.AccountId
集計関数
SELECT Name, AVG(AnnualRevenue) FROM ExcelSheet GROUP BY Name
CRUD 処理
UPDATE ExcelSheet SET Name='John' WHERE Id = @myId