ノーコードでクラウド上のデータとの連携を実現。
詳細はこちら →Cassandra FireDAC Component を使えば、Delphi & C++ Builder アプリケーションからCassandra データに簡単に連携できます。 Connect Delphi & C++Builder Apps with the Cassandra real-time NoSQL cloud database service. Use Apache Cassandra as the big data backend that powers your Delphi & C++Builder Apps.
機能紹介
- Cassandra 2.0 through 3.0 Compatibility – Leverages the faster performance and improved security of Cassandra V3.0.
- CQL Pass-through Capability – Delivers native CQL3 or CQL2 data access to clustered Cassandra data, enabling users to create queries in CQL or SQL
- Enables SQL-92 capabilities on Apache Cassandra NoSQL data.
- Flexible NoSQL flattening - automatic schema generation, flexible querying etc.
- Connect to live Apache Cassandra data, for real-time data access
- Full support for data aggregation and complex JOINs in SQL queries
Specifications
- Native FireDAC Components for Cassandra 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 := 'CassandraConnection'; FDConnection1.DriverName := 'CData.Fire.Cassandra'; with FDConnection1.Params as TFDPhysCDataCassandraConnectionDefParams do begin ... end; FDConnection1.Connected := true; FDQuery1.Active := true; FDQuery1.Open('select * from CQL Queries'); ...
Type SQL, Get Cassandra
データ連携アプリケーションを開発する最適解。 RDBMS の扱いと同感覚で、Cassandra への連携を、標準SQL で実装可能。JOIN、更新系、集計など多彩なSQL サポート。
SELECT WITH INNER JOIN
SELECT CQL Queries.Id, CQL Queries.Name, CQL Queries.Fax, Opportunity.AccountId, Opportunity.CloseDate FROM CQL Queries INNER JOIN Opportunity ON CQL Queries.Id = Opportunity.AccountId
集計関数
SELECT Name, AVG(AnnualRevenue) FROM CQL Queries GROUP BY Name
CRUD 処理
UPDATE CQL Queries SET Name='John' WHERE Id = @myId