Skyvia provides advanced SQL support for cloud sources, such as Salesforce, QuickBooks, Dynamics CRM, MailChimp, etc., which don't support SQL natively. Instead of studying web APIs of each source, you can use familiar SQL statements to access and modify your data.
Our cloud SQL client wraps the specificity of the cloud data source interfaces and greatly extends capabilities of the data access to cloud data sources allowing you to use complex select statements to query data and perform mass cloud data updates with DML statements.
Simple queries are directly compiled to web API calls. These API calls are executed by the cloud data source, providing the best performance.
More complex queries are split in parts, and parts of query are executed against the cloud data source. Our SQL engine processes the results and applies advanced SQL features, used in the query. Returned data are presented to the user.
With Skyvia it's very easy to select cloud data. Skyvia allows you to quickly select a cloud object, specify filtering and sorting conditions in the query editor in order to get exactly the data you want, execute the query, and retrieve your data.
For example, you can use the SQL query on the screenshot to get all Salesforce customer accounts, ordered by their names.
Skyvia SQL client is not limited to simple cases like the previous one, and it allows creating complex SELECT queries with aggregations, SQL functions, etc. to get the data in a form you need - summarized, aggregated, or detailed. For example, if you run the SQL query on the screenshot, it would returns total sale amount grouped by years.
Use full power of SQL to retrieve your cloud data in exactly the form you need, analyse them, and leverage your data-driven decision making.
Currently Skyvia supports SQL to cloud applications in the Query product. Skyvia Query supports querying cloud data with SELECT statements and managing data via DML statements with changes preview. It allows viewing the returned data in the browser in a grid or as charts and exporting data to various file formats.