ノーコードでクラウド上のデータとの連携を実現。
詳細はこちら →SAP Hybris C4C FireDAC Component を使えば、Delphi & C++ Builder アプリケーションからSAP Hybris C4C データに簡単に連携できます。 Straightforward SAP Hybris C4C integration. Now accessing SAP Hybris Leads, Contacts, Opportunities, Accounts, etc. from Delphi & C++Builder Apps is as easy as querying SQL Server.
機能紹介
- SQL-92 access to SAP Hybris Cloud for Customer (C4C) data
- 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 SAP Hybris C4C 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 SAP Hybris C4C 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
FireDAC Components
あらゆるデータソースにRDB と同感覚で連携が可能に
標準FireDAC Components
MySQL やSQL Server のようなRDBMS への接続と同感覚。 TDFManager、TDFConnection、TDFQueryUse といった標準FireDAC components として。
FDConnection1.Name := 'SAPHybrisC4CConnection'; FDConnection1.DriverName := 'CData.Fire.SAPHybrisC4C'; with FDConnection1.Params as TFDPhysCDataSAPHybrisC4CConnectionDefParams do begin ... end; FDConnection1.Connected := true; FDQuery1.Active := true; FDQuery1.Open('select * from Leads'); ...
Type SQL, Get SAP Hybris C4C
データ連携アプリケーションを開発する最適解。 RDBMS の扱いと同感覚で、SAP Hybris C4C への連携を、標準SQL で実装可能。JOIN、更新系、集計など多彩なSQL サポート。
SELECT WITH INNER JOIN
SELECT Leads.Id, Leads.Name, Leads.Fax, Opportunity.AccountId, Opportunity.CloseDate FROM Leads INNER JOIN Opportunity ON Leads.Id = Opportunity.AccountId
集計関数
SELECT Name, AVG(AnnualRevenue) FROM Leads GROUP BY Name
CRUD 処理
UPDATE Leads SET Name='John' WHERE Id = @myId