Even looking past these limitations, internal scripts invariably require development and maintenance time, and as any developer knows, can break at the worst of times :) Method #2: Use Zapier? (https://zapier.com) Want to use Zapier to do this? You can’t. Not only because it doesn’t track deletes, updates to existing records, and only does one way syncs. But because Snowflake isn’t supported. Method #3:... - Source: Hacker News / about 1 year ago
Disclaimer: I work for Fivetran, a data integration company. Source: over 1 year ago
Disclaimer: I'm a product evangelist for a data integration company called Fivetran, so I'm shamelessly shilling here. Source: over 1 year ago
I really like the theme they’re using on https://fivetran.com. Source: almost 2 years ago
From experience then, believe me when I say you don't want to build these. Thankfully, ETL products like Fivetran and Stitch run and maintain these extraction processes for you. - Source: dev.to / about 2 years ago
We chose Airbyte because of their open source self-hosted offering and their connector flexibility. There are other open source tools in the market like StitchData or Meltano but have limitations as discussed in this post by the Airbyte team. If you don’t want to self host extraction, consider Fivetran. - Source: dev.to / about 2 years ago
If the APIs you're connecting to are from common third-party vendors like Salesforce, Zendesk, and so forth, or from common operational RDBMSes like PostgreSQL or MySQL, you can use off-the-shelf data connectors from Fivetran, Stitch, Matillion, or other data pipeline providers to automatically extract, normalize, and load the data to your data warehouse. Source: over 2 years ago
The tools in this category are called ELT tools. ELT stands for "extract, load, transform," which are the steps required to take your data from a system like Salesforce or QuickBooks and insert it into your data warehouse. Tools in this category are Fivetran and Stitch. - Source: dev.to / over 2 years ago
Hightouch Audiences requires that you have a data warehouse or data lake That has event data on how your users are interacting with your product. Hightouch does not replace your existing event tracking or ELT Workflows: in fact, it enhances it. The More data you make available in your warehouse (such as billing data From Stripe, sales data from Salesforce, etc), the more powerful your Audiences can be. - Source: dev.to / over 2 years ago
If your company is price sensitive, you might opt for a free open source tool such as Airbyte but absorb the engineering costs of setup and maintenance. If your company wishes to focus their engineering resources on other tasks other than extraction and loading, they can use a managed service like Fivetran where they pay for the service. - Source: dev.to / over 2 years ago
There are integration companies that solve this specific use-case. I’ve used Fivetran [0] and highly recommend it. They will extract-load data from your SaaS to your warehouse of choice and your data scientists can run SQL against the tables. Their most popular warehouses are Redshift and Snowflake. So you can still use a centralized data warehouse without dedicating internal resources to the integrations. [0]... - Source: Hacker News / almost 3 years ago
I don't have much info about the pricing, but I would definitely suggest checking out some other (what I would consider newer) options. I am not sure what your use case is so they may not be a good fit, but you can use tools like Fivetran or Tray, or open-source specs like Meltano/Airbyte. There are also some SaaS tools like Paragon Connect or hotglue. Source: almost 3 years ago
Do you know an article comparing Fivetran to other products?
Suggest a link to a post with product alternatives.
This is an informative page about Fivetran. You can review and discuss the product here. The primary details have not been verified within the last quarter, and they might be outdated. If you think we are missing something, please use the means on this page to comment or suggest changes. All reviews and comments are highly encouranged and appreciated as they help everyone in the community to make an informed choice. Please always be kind and objective when evaluating a product and sharing your opinion.