SQL Support for Cloud Applications

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.

How It Works

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.

Query Cloud Data

SELECT * FROM Account 
WHERE Type  LIKE 'Customer%'
ORDER BY Name

Immediate Data Access

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.

SELECT  
  strftime('%Y', CreatedDate) AS Year,  
  SUM(Amount) AS Total
FROM Opportunity
GROUP BY strftime('%Y', CreatedDate)

Support for Advanced SQL Features

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.

Manage Cloud Data

Skyvia fully supports the syntax of INSERT, UPDATE, and DELETE SQL statements for cloud sources. This makes Skyvia a perfect tool to perform mass data update operations on cloud data sources, since you can easily update or delete multiple records with a single update or delete statement.

INSERT INTO Contact 
	(FirstName, LastName, Phone, Email) 
VALUES
	(
	 'John',
	 'Smith',
	 '(650) 450-8820',
	 'johnsmith@devart.com'
	)

INSERT

You can use an INSERT statement to quickly create a new record with only the necessary fields filled. RETURNING clause is supported in the INSERT statement. The following INSERT statement creates a new Salesforce Contact.

UPDATE PricebookEntry
SET UnitPrice = UnitPrice*1.05
WHERE Pricebook2ID = '01sA0000000Tq1aIAC'

UPDATE

With UPDATE statements you can perform mass cloud data updates. Skyvia allows you to preview changes before applying, so the operation is safe. This UPDATE statement increases all prices in a specific Salesforce Pricebook2 by 5%

DELETE FROM Contact
WHERE AccountID IS NULL

DELETE

With a single DELETE statement you can easily delete all the records that satisfy to the specified WHERE condition. ID value is not required. The following DELETE statement deletes all Salesforce contacts not assigned to accounts.

Cloud SQL Support in Skyvia Products

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.