TrustRadius: an HG Insights company

Skyvia

Score10 out of 10

40 Reviews and Ratings

What is Skyvia?

Skyvia is a no-code cloud data integration platform for ETL, ELT, Reverse ETL, data migration, one-way and bi-directional data sync, workflow automation, and real-time connectivity.

Read more details.

Media

Screenshot of Export
Screenshot of Query
Screenshot of Backup Schedule
Screenshot of Integration

1 / 4

Screenshot of Export

Top Performing Features

  • Business rules and workflow

    Ability to define and manage business rules and workflows

    Category average: 8.2

  • Connect to traditional data sources

    Ability to connect to traditional data sources like relational databases, flat files, XML files and packaged applications

    Category average: 8.9

  • Simple transformations

    Simple data transformations are calculations, data type conversions, aggregations and search and replace operations

    Category average: 8.8

Areas for Improvement

  • Data model creation

    Ability to create and maintain data models using a graphical tool to define relationships between data

    Category average: 8.3

Who Buys & Uses Skyvia

Pros

  • Facilitating data integration and syncing across diverse platforms
  • Ease of use and straightforward setup for quick implementation
  • Robust real-time connectivity to a wide array of data sources and SaaS solutions

Cons

  • Slower processing times and occasional job status discrepancies
  • User interface can be confusing to navigate until familiar
  • Query editor lacks controls to prevent excessive usage limit consumption

Skyvia Review.

Use Cases and Deployment Scope

We use Skyvia to transfer data between our Systems of Record and our Data Warehouse System of Truth. The Data transfer layer is key to pulling raw data from individual systems, tagging rows properly, and working with the destination system. Adding Skyvia to our tech stack was smooth, and the testing and monitoring capabilities have been great!

Pros

  • Ease of Use.
  • Great Support team.
  • Connects to all the systems we need.

Cons

  • Stronger Error Logging & Troubleshooting.
  • Allow for Copy table names and export lists easier.

Return on Investment

  • Still too early to tell. It has been cost-effective during the implementation stage of our Data Warehouse.

Usability

Alternatives Considered

Boomi, Fivetran and MuleSoft Anypoint Platform

Other Software Used

Salesforce Sales Engagement, NetSuite ERP, Zendesk Suite

Intuitive product for data sharing

Use Cases and Deployment Scope

We used Skyvia to integrate data into Airtable from Hubspot and Quickbooks, which allowed us to efficiently calculate Sales Commissions without any hassle. Skyvia worked seamlessly in the background, automating processes and saving us countless hours of tedious manual entry.

Pros

  • Easy to set up
  • Runs in the background
  • Intuitive Interfaces
  • Transparent pricing

Cons

  • Better training for more complex modules

Return on Investment

  • Tremendous time savings
  • Ensured data accuracy

Usability

Alternatives Considered

Zapier

Using Skyvia with HubSpot

Use Cases and Deployment Scope

We are using Skyvia to connect our Hubspot CRM system to our internal reporting systems by replicating the data into our Azure SQL server. The reporting in Hubspot did not meet our executives needs and could not report effectively on Line Items. By copying the data each day to SQL we can provide all information our business requires.

Pros

  • Simple Interface to build dataflows
  • Alerts are sent if issues incurred
  • Support is very good
  • Minimal maintenance

Cons

  • The accounts team requires Invoices to sent - only proforma invoices are available
  • It is not an issue with Skyvia, but with Hubspot it is not possible to download changed data only for the Line Item table. Therefore a full download is required and therefore limits me to updating the data just once a day

Return on Investment

  • Without Skyvia, we would not have been able to use HubSpot in the way we do which would have increased the workload on the HubSpot users and the Financial departments significantly.

Usability

Other Software Used

Azure Service Fabric, Microsoft Power BI, Notion

Great Value and Easy to Use

Use Cases and Deployment Scope

We were looking for a way to drive our own HubSpot analysis using PowerBI and wanted a data extract that was easy to manage and maintain. Skyvia was so easy to set up and get running that we immediately adopted it for that purpose. Being able to run the extraction from within the PowerBI or Qlik Cloud environment without any code was a huge saving for us. It has continued to provide results week after week, month after month with no maintenance.

Pros

  • Easy to view and validate the data we wanted
  • Simple to write queries that provided the data using ODATA
  • Rugged performance month after month

Cons

  • Sometimes a little confusing to navigate

Return on Investment

  • Sales Reporting was available on demand a big step forward for us
  • From testing to having a working data connection was hours not days
  • Setting and forgetting meant ongoing cost apart from the licensing

Usability

Great product for gaining access to data from 3rd party sources

Use Cases and Deployment Scope

It allows me to access data from a 3rd party source without learning how to program with APIs.

Pros

  • Connection to the data source
  • Listing of available tables
  • Preview and save queries

Cons

  • Selection of fields to be removed could be easier in the query editor
  • Live Chat support
  • Telephone contact

Return on Investment

  • Make it easy to retrieve data from remote data source via API calls
  • Easy integration with MS Excel
  • Reusable stored connections and queries

Usability