If you’re evaluating the best ETL database software for your cloud migration, here’s our take on key differences.
There’s no denying that production databases are critical for achieving business success, with use cases ranging from storing product and user events to backend systems for Enterprise Resource Planning (ERP) systems. The best practice to make use of this data is to centralize it in one place to provide context to and for your other systems, often done through an ETL process or tool. Two of the most popular database integration solutions on the market today are Fivetran and HVR, with a few distinct differences in how we approach ongoing database replication.
HVR’s primary focus for source support are databases. In addition to supporting the most popular relational and NoSQL databases as sources however, Fivetran also supports web applications, such as Salesforce and NetSuite, and 150+ other data source systems, such as event trackers to power your holistic analytics -- all with one tool.
Fivetran is a SaaS (Software as a Service) company, which, similar to other SaaS providers, means that there are no requirements to set up a server and perform lengthy installation prior to doing any replication. In comparison, HVR has a few hosting options available, including compatibility with on-premise servers and cloud providers such as Amazon Web Services. After installation of the software on a server to run, in some cases, you’ll also need to install an agent on your database server to process updates.
In addition to the extensive installation pre-work mentioned above, HVR also requires multiple “actions” be created and managed to initiate database replication, which in turn, require a higher level of technical knowledge to ensure that configuration won’t obstruct production processes. On the other hand, Fivetran simply requires a read-only user and read access to logs to detect updated data, as well as connection details, such as host name.
The use of CDC via database logs to capture updates is a feature shared by both Fivetran and HVR. However, there’s a slight difference in implementations, with HVR requiring that DDL statements causing schema change be specified as a part of the required actions, and a “refresh” action to trigger a resync to capture those be included as part of the workflow. Fivetran will automatically handle schema drift without manual intervention or customized workflow setups, and takes that one step further with History Mode to fulfill your Slowly Changing Dimensions (SCD) Type 2 needs.
By default, HVR provides a test environment that lasts for three hours, after which, you’ll need to reach out to their sales team to extend the trial time. The Fivetran free trial is 14 days, where the trial counter only starts after your initial historical sync has completed. After becoming a customer, either through our online credit card portal or a standard contract, every new integration set up still comes with 14 days of free usage, so that you can always test additional connectors.
As noted above, your 14-day trial counter doesn’t start until you’ve finished loading all of your currently available data, so we recommend signing up as soon as possible to familiarize yourself with our application.
Alternatively, if you’d like to explore best practices with us prior to starting your trial, we’re always available to present a demo that includes how to make the most use of your trial.
If your experience with either of our tools has been vastly different, we’d love to hear from you. Book time with us!