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 / 30 days ago
Disclaimer: I work for Fivetran, a data integration company. - Source: Reddit / 7 months ago
Disclaimer: I'm a product evangelist for a data integration company called Fivetran, so I'm shamelessly shilling here. - Source: Reddit / 8 months ago
I really like the theme they’re using on https://fivetran.com. - Source: Reddit / 10 months 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 / 11 months 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 1 year 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: Reddit / over 1 year 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 1 year 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 1 year 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 1 year 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 2 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: Reddit / almost 2 years ago
Do you know an article comparing Fivetran to other products?
Suggest a link to a post with product alternatives.