Solving Data Integration: The Pros and Cons of Open Source and Commercial Software
Tags: opensource, database, datascience, devops
Published: 2020-10-11 23:49:17


<!-- wp:paragraph -->
<p>There was an awesome debate on DBT’s Slack last week discussing mainly about 2 things:</p>
<!-- /wp:paragraph -->

<!-- wp:list {"ordered":true} -->
<ol><li>The state of open-source alternatives to Fivetran</li><li>Whether an open-source (OSS) approach is more relevant than a commercial software approach in addressing the data integration problem.&nbsp;</li></ol>
<!-- /wp:list -->

<!-- wp:paragraph -->
<p>If you’re already on DBT’s Slack, here is <a href="https://getdbt.slack.com/archives/C0100SUQ0CW/p1601381009013800?thread_ts=1601381009013800&amp;cid=C0100SUQ0CW">the thread’s URL</a>. Even Fivetran’s CEO was involved in the debate.&nbsp;</p>
<!-- /wp:paragraph -->

<!-- wp:image -->
<figure class="wp-block-image"><img src="https://lh3.googleusercontent.com/MtdqC1O3Y_jxBMPDX4k8D3Rpfb_uG6qzK07cnj5C7QO6Zf-O-Hh5QZcV96GRBrSs72rCgHOHVwBAqBHYlsfvyGStAG7FD7Kbc_LOYy90Bp-Jba8pDeF8610AqFuLSEyt_Z4H4Cfj" alt=""/></figure>
<!-- /wp:image -->

<!-- wp:paragraph -->
<p>In this article, we want to discuss the second point and go over the different points mentioned by each party. The first point will come in another article. It’s more relevant to discuss whether an OSS approach makes sense before drilling down into the different alternatives.</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>We’ll go over the main challenges that companies face and see which approach fits best. We’ll call “commercial companies” the ones with a commercial software product, and “OSS companies” the ones with an open-source approach.</p>
<!-- /wp:paragraph -->

<!-- wp:heading -->
<h2>TL;DR</h2>
<!-- /wp:heading -->

<!-- wp:paragraph -->
<p>Here is a table summarizing the points mentioned in the debate.</p>
<!-- /wp:paragraph -->

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/1rtmz4ba9o12d8va6nj7.png)

<!-- wp:paragraph -->
<p>To better understand this table, we invite you to read the list of challenges each approach faces below.</p>
<!-- /wp:paragraph -->

<!-- wp:heading -->
<h2>1. Having a large number of high-quality well-maintained pre-built connectors</h2>
<!-- /wp:heading -->

<!-- wp:paragraph -->
<p>This might be the most challenging part for the open-source approach, but there are actually choices that can make an OSS approach even stronger than a commercial one on that matter.&nbsp;</p>
<!-- /wp:paragraph -->

<!-- wp:heading {"level":3} -->
<h3>Commercial approach</h3>
<!-- /wp:heading -->

<!-- wp:paragraph -->
<p>In this case, a company supports a limited number of connectors (the most used ones) and actively maintains them. They know when there is a schema change and when they need to update the connector, and can be pretty responsive on that, if the organization is responsive and scales well.&nbsp;</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>However, the more connectors, the more difficult it is for a commercial company to keep the same level of maintenance across all connectors. In an ideal world, the organization will grow linearly with the number of connectors. But most often, there are inefficient processes, so every organization will reach a limit. The more efficient they are, the higher the limit.&nbsp;</p>
<!-- /wp:paragraph -->

<!-- wp:heading {"level":3} -->
<h3>Open-source approach</h3>
<!-- /wp:heading -->

<!-- wp:paragraph -->
<p>When you look at Singer.io, you would think that an OSS approach is at a serious disadvantage here. But Singer.io has actually made several significant poor choices here:&nbsp;</p>
<!-- /wp:paragraph -->

<!-- wp:list -->
<ul><li>There is an absence of standardization / enforcement of protocol, and developers just add whatever they want in their implementation and messages.&nbsp;</li><li>Integrations live by themselves in their own repos. So each connector can be seen as an individual open-source project. This does not help when building a community.</li><li>There is no real ownership, nor direction for the project.&nbsp;</li></ul>
<!-- /wp:list -->

<!-- wp:paragraph -->
<p>So can we actually achieve a large number of high-quality well-maintained connectors with an open-source approach? The answer is <em>probably</em>, but only if the following conditions are met:</p>
<!-- /wp:paragraph -->

<!-- wp:list -->
<ul><li>One single repo for the whole project and all connectors. This will help consolidate the developments, and it will unify the community behind one single project and one vision. This means that the project and community can be opinionated about what a connector should be, and how it should be built.&nbsp;</li><li>Detailed logs for all users, with the ability to easily surface the issue on the GitHub project to the whole community.</li><li>A separation between extract-load and transformation. Users would be able to use the connector without any normalization, so they use their own transformation processes.&nbsp; By doing so, we can more easily identify where failures happen, and how to solve them. Plus, it would make it easier to support a lot more integrations faster.&nbsp;</li></ul>
<!-- /wp:list -->

<!-- wp:paragraph -->
<p>A last note here: when users use a connector on prod and see it fail, they will be able to fix it without waiting for external support teams (as for commercial companies), and the whole community will be able to benefit from the fix.&nbsp;</p>
<!-- /wp:paragraph -->

<!-- wp:heading -->
<h2>2. Addressing unique corner cases and unique needs</h2>
<!-- /wp:heading -->

<!-- wp:paragraph -->
<p>Every company is opinionated about the way it wants to use a connector; each has specific needs.&nbsp;</p>
<!-- /wp:paragraph -->

<!-- wp:heading {"level":3} -->
<h3>Commercial approach</h3>
<!-- /wp:heading -->

<!-- wp:paragraph -->
<p>Commercial companies have a ROI-driven relationship with connectors. Any additional work on any edge case will need to have some ROI, or the company will have a hard time scaling. That also means that the commercial company will most likely have very high quality connectors for the most used ones. But it can’t afford to keep that level of quality across all integrations, and thus won’t be addressing their corner cases. With their finite resources, it will always be a trade-off. Commercial companies can’t address the long tail of integrations and can’t meet all unique needs.&nbsp;</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>Furthermore, in the case a client’s needs are not met, the client won’t be able to customize the existing connector to their needs. That is the limitation of this approach.&nbsp;</p>
<!-- /wp:paragraph -->

<!-- wp:heading {"level":3} -->
<h3>Open-source approach</h3>
<!-- /wp:heading -->

<!-- wp:paragraph -->
<p>It is actually not obvious that an OSS approach would easily address all unique corner cases. Contributors build the connectors with their use cases and needs in mind; they won’t be building a high quality connector to address most companies’ needs.&nbsp;</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>However, there are ways to avoid that:&nbsp;</p>
<!-- /wp:paragraph -->

<!-- wp:list {"ordered":true} -->
<ol><li>Setting standards and enforce protocols, with one single platform / project, as mentioned in the first point.&nbsp;</li><li>Decoupling extract-load (EL) and normalization. A lot of the customization can be done directly in normalization, but a lot of the EL is common to everyone. In that case, everybody can benefit from the EL part and use their own transformation tools to address their own needs.&nbsp;</li><li>Enabling contributors to build their connectors using the language of their choice by running connectors as Docker containers</li></ol>
<!-- /wp:list -->

<!-- wp:paragraph -->
<p>Being open source lets any engineer adapt any pre-built connectors to their needs, so every company will be able to address their own needs. The question is more about how much effort would be needed for each of their cases.&nbsp;</p>
<!-- /wp:paragraph -->

<!-- wp:heading -->
<h2>3. Pricing model indexed on usage</h2>
<!-- /wp:heading -->

<!-- wp:paragraph -->
<p>All existing commercial products have their pricing indexed in some way on the volume of data transferred and the number of connectors used. That means that teams cannot use those services without always thinking about costs. </p>

<p>On the other hand, open-source products will base their pricing on the features used and not the volume of data as it is self-hosted. So once adopted, teams do not have to worry about costs and can use all connectors freely. 
</p>
<!-- /wp:paragraph -->

<!-- wp:heading -->
<h2>4. Debugging autonomy</h2>
<!-- /wp:heading -->

<!-- wp:paragraph -->
<p>This is an easy one. When dealing with a commercial product, if you face an issue, the only thing you can do is contact their support, and hope that your issue will be prioritized in the list of issues the company’s engineering team must resolve. You won’t be able to know when the issue will be fixed. It can take hours at best, or months.&nbsp;</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>With open source, you don’t need to wait on anybody. You can fix the integration yourself. Having this ability is important if the integration is vital to your business.&nbsp;</p>
<!-- /wp:paragraph -->

<!-- wp:heading -->
<h2>5. Getting the internal resources</h2>
<!-- /wp:heading -->

<!-- wp:paragraph -->
<p>By resources, we mean either budget or the engineering time to work on the integrations. At <a href="http://airbyte.io">Airbyte</a>, we don’t like the word <em>resources</em> when talking about people. But, in this context. it is the only common one we could think of.&nbsp;</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>The truth is that in a lot of enterprises, it can be easier to justify hiring a new employee than getting even a modest budget approved for an external vendor. Depending on the open-source project, most or all of the job could be already done. That’s one of the reasons why most companies use open-source technologies rather than external vendors.&nbsp;</p>
<!-- /wp:paragraph -->

<!-- wp:heading -->
<h2>6. Easy to use by any teams (analysts, finance teams, etc.)</h2>
<!-- /wp:heading -->

<!-- wp:paragraph -->
<p>Once consolidated, the data is used by different teams: business intelligence / analysts, data scientists, finance teams, customer success, product or marketing team, etc. That is the beauty of products like Fivetran: anybody can use them and anyone can add more data.</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>One would think that ease of use is exclusive to commercial products, but that is actually not true. For instance, Gitlab and many other OSS projects have UIs that are usable by a&nbsp; non-technical audience. Airbyte has one and it is one of its primary features.&nbsp;</p>
<!-- /wp:paragraph -->

<!-- wp:heading -->
<h2>7. Security and privacy compliance</h2>
<!-- /wp:heading -->

<!-- wp:paragraph -->
<p>We’re talking about data, and most probably this involves customer data. All companies are subject to privacy compliance laws, such as GDPR, CCPA, HIPAA, etc. As a matter of fact, above a certain stage (about 100 employees) in a company, all external products need to go through a security compliance process that can take several months.&nbsp;</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>With open source, teams just use the technology directly without such processes. The adoption is frictionless, and the engineering need can be met overnight.&nbsp;</p>
<!-- /wp:paragraph -->

<!-- wp:heading -->
<h2>8. Moving data between internal databases</h2>
<!-- /wp:heading -->

<!-- wp:paragraph -->
<p>Commercial products mostly sit in the cloud. So if you have to replicate data from an internal database to another, it makes no sense to have the data move through the external vendor. In addition to the vendor’s costs, you need to add egress costs and the issue it poses in terms of privacy.&nbsp;</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>Open-source products are mostly self-hosted, so they don’t have this problem.</p>
<!-- /wp:paragraph -->

<!-- wp:heading -->
<h2>Is open source hard without a direct revenue channel?</h2>
<!-- /wp:heading -->

<!-- wp:paragraph -->
<p>One of the comments in the thread was that “open source is hard without a direct revenue channel to support it.”&nbsp; That is actually true for any company. If you have a hard time getting revenues, you can’t scale the team or your effort.&nbsp;</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>According to Bessemer, <a href="https://www.bvp.com/atlas/roadmap-open-source/">open-source companies grow faster</a> in revenues than many cloud leaders.&nbsp;</p>
<!-- /wp:paragraph -->

<!-- wp:image -->
<figure class="wp-block-image"><img src="https://lh5.googleusercontent.com/ImKtflGSkc2wKvg1offFRX12gzMbnRDhLsKJ0WFAOmqaQSBKdhCLH9y-I7MReVtIZvsOlCqktrJ2QE2ELlcJAo4nWwuMfo9Tjy8x35gMc6VPD2SHGw41mEs0CKJlwYsS60icn56b" alt=""/></figure>
<!-- /wp:image -->

<!-- wp:heading -->
<h2>Some other interesting quotes / points</h2>
<!-- /wp:heading -->

<!-- wp:paragraph -->
<p>“The general argument for open-source software that applies to all software: Having access to the source code means users have freedom--the freedom to change the software how they see fit and fix issues.”</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>“If you spent months or years using, say, Fivetran, and all of a sudden Fivetran goes out of business or significantly changes its business, you could run the software yourself, even if just for a period of time. I’ve been there when it’s happened with other software; it’s not pretty, and sometimes you only have days or weeks of heads up.”</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>“If it’s open source, I can run it without Fivetran, so for special circumstances, like compliance or high volume, I don’t have to deal with legal or cost limitations.”</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>“I can see the code running my integration; I can more quickly debug issues. I can also easily create integrations anyone can choose to use. Tools like Fivetran and Stitch only work a percentage of the time; open source allows me to fill in that gap without creating one-off scripts (or Fivetran lambda functions) or going back and forth for weeks or months with support on a bug that I could fix in a few hours.”</p>
<!-- /wp:paragraph -->

<!-- wp:heading -->
<h2>Conclusion</h2>
<!-- /wp:heading -->

<!-- wp:paragraph -->
<p>If the open-source project is well structured and well thought through, there will be no points where a commercial approach can be better. The issue is that, until now, there were no good open-source projects that could alleviate the dangers to this approach.&nbsp;</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>If you like how we think an open-source project can address all the possible concerns by building a single platform with a single repo, a defined data protocol, a ready-to-use UI, and decoupling of EL and normalization, you should definitely have a look at what we’re building at <a href="http://airbyte.io">Airbyte</a>. We want to become the open-source standard for data integrations.&nbsp;</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>Let us know if you think we missed anything. Our goal is to see things from all perspectives and to keep this article up to date.</p>
<!-- /wp:paragraph -->