CData Enterprise data connectors have been a great addition to RAD Studio in recent years. All connectors extend the TFDConnection component of the FireDAC library which is the preferred library to access data with Delphi these days. Accessing any of the sources means writing SQL queries and using well-known database components even though you might not be working with a database in the backend (e.g. FTP, SFTP, DropBox, etc.).
I think it is worth mentioning that the 2019 release contains several connector for data sources that were not available before.
Interesting, in particular, is being able to connect to Amazon’s Marketplace. Furthermore, you will be able to access databases as Couchbase, Google Spanner, SAP Sybase, and Teradata. Access to the new Instagram API for business accounts is also possible. You may track FedEx packages using the FedEx data provider.
I feel a bit strange, still, to access data from a cloud drive using database queries, but CData does provide a solution for SFTP and Dropbox now.
Here’s the link to the announcement of the 2019 update:
In case you do not want any dependency on FireDAC and want to access some of the cloud sources without using database components, you might want to have a look at the excellent TMS Cloud Pack, which offers direct access from Delphi to these services:
You can find detailed information about all the available component packs and the different frameworks (VCL, FMX, FNC) here: