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 the 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. Skyvia allows users to create complex SELECT queries with aggregations, SQL functions, etc. to get the data in the format you need - summarized, aggregated, or detailed. For example, look at the SQL query shown in the figure to the left - the query returns total sale amounts grouped in years.
Use the full power of SQL to retrieve your data from the cloud in exactly the form you need it. Make it more efficient to retrieve and analyze your data so your decision-making will be more effective in turn.
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.