Devart is glad to present the new 3.5 version of Skyvia - our online service for cloud data integration.
The new Skyvia version offers a cloud SQL client for cloud and relational data sources and improved control of cloud source metadata cache.
With Skyvia Query you will be able to use SQL to query and manage your cloud and relational data directly from a web browser. It allows you to query data with SELECT statements and see the query results in the browser or export them to CSV files, work with several queries on the same page simultaneously, perform DML statements against both cloud and relational data, etc.
Skyvia offers full support for SQL-92 syntax for cloud sources, allowing you to perform complex queries with aggregations, SQL functions, etc. against your cloud sources and get exactly the data you need, presented in the most informative way. Full DML support makes Skyvia a perfect tool for mass cloud data updates, and it takes care about protecting your data from user errors by allowing you to preview all the changes before actually applying them.
For databases Skyvia fully supports all the SQL they support including DDL statements if necessary, and allows you to access and manage your data whenever you need and from anywhere.
For more information visit the Query page.
By default Skyvia caches metadata from your cloud connections and works with this cache afterwards. If a cloud object structure changed since that, this change may be ignored until the cache is refreshed.
Skyvia 3.5 offers more options for control when the cache is refreshed and allows per-object manual cache refresh. First, you may configure the interval between refreshing a cache for a cloud connection in the connection editor and clear the connection cache on the connection details page. Second, when editing an integration package, you can refresh metadata for a cloud object in the task editor of the task that uses this object.
Please try our new functionality and leave feedback.