Transforming Network Infrastructure Industry News

[May 15, 2015]

Cloud SQL Tool and Better Metadata Cache Management in Skyvia 3.5

Devart introduced the new 3.5 version of Skyvia - an online service for cloud data integration, backup and management. The new Skyvia version offers a cloud SQL client for cloud and relational data sources, and improved control of cloud source metadata cache.

Online SQL Tool Skyvia Query allows using SQL for quering and managing cloud and relational data directly from a web browser. It allows querying data with SELECT statements and viewing query results in the browser or exporting them to CSV files, working with several queries on the same page simultaneously and performing DML statements against both cloud and relational data.

Skyvia offers full support for SQL-92 syntax for cloud sources, makes possible performing complex queries with aggregations, SQL functions, etc. against the cloud sources and getting the needed data, 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 the data from user errors with preview of all the changes before actually applying them.

For databases Skyvia fully supports all the SQL they support including DDL statements if necessary, and provides an ability to access and manage the data anytime and from anywhere.

Better Cloud Metadata Cache Management 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 over metadata cache refreshing and allows per-object manual cache refresh. First, user can 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, while editing an integration package, user can refresh metadata for a cloud object in the task editor of the task that uses this object.

Discover more information about Skyvia at https://skyvia.com About Devart Devart is a recognized vendor of database connectivity solutions for Microsoft .NET and Embarcadero Delphi development platforms as well as database development and management software.

Company's solutions support such databases as Microsoft SQL Server, Oracle, MySQL, PostgreSQL, InterBase, Firebird, DB2, SQLite, etc. Along with database oriented software Devart offers productivity tools for Visual Studio and cloud service for data integration and backup Skyvia.

For additional information about Devart visit http://www.devart.com/

As a community-building service, TMCnet allows user submitted content which is not always proofed by TMCnet editors. If you feel this entry is of inferior quality or wish to report it for some reason, please forward the URL to "webedit [AT] tmcnet [DOT] com" with your comments.

[ Back To Transforming Network Infrastructure's Homepage ]

Community Voices
Learn More ›

Freedom from rigid architectures
Learn More ›

FREE Transforming Network Infrastructure eNewsletter - Sign Up

Featured Blog Entries

Reflections from an Interop Veteran and Alum

When I returned to the Fiber Mountain™ offices in Connecticut after exhibiting at Interop Las Vegas 2015, I couldn’t help but think about how much the event has evolved through the years. I have been attending this seminal IT and networking conference since its inception in 1986 when it was called the TCP/IP Vendor Workshop, focused on interoperability of various TCP/IP program stacks.

What Fiber Mountain's Interop Recognition Means for Our Industry

When Fiber Mountain™ began its journey with a launch at Interop New York last fall, we certainly believed that we had a solution that would make a significant impact in the data center space.

What On-Board Optics Means for Density and Flexibility

This past week I read an article in Lightwave Magazine and another in Network World about the formation of the Consortium for On-board Optics (COBO), a group that seeks to create specifications and increase the faceplate density of data center switches and adapters.

Scaling Hyperscale in an Age of Exponential Growth and Virtualization

Over the past several years server, network, storage and application virtualization has revolutionized the way hyperscale data centers are built by consolidating workloads. The trend has simplified network architecture significantly and resulted in huge cost savings as well.

MENU