Version Control and Why You Need It

data-integration-essential-questions

Data integration is becoming a hot topic.

Business intelligence applications can make use of a comprehensive set of information provided through data integration to derive important business insights from a company’s historic and current data. By providing executives and managers with an in-depth understanding of the company’s current operations, as well as the opportunities and risks it faces in the marketplace, data integration can have a direct bottom-line impact.

In the past, the job of integrating systems was a complex, often costly, frequently cumbersome process, involving on-premise integration tools. These days a new breed of applications, SaaS (Software-as-a-service), is taking over as the integration platform of choice for new integration projects. There is a lot to consider when the developers and IT management approach a data integration project.

The features like ease of use, scalability and flexibility, real-time integration, security, and compliance are essential. This blog will talk about the importance of one feature that often gets overlooked – version control.

Why the version control is important?

Because the data integration tool is a software that is used in performing a data integration process on the data source moving the data to the destination. And, as you are planning to work on a big software project that consists of technical concepts, requires a collaboration of different team members and needs frequent changes, you need to use a version control system (VCS).

Version control is essential to track, organize and control changes over source code and avoid confusion, especially for large, fast-changing projects, like data integration.

Etlworks is a modern, cloud-first, any-to-any data integration platform that supports version control for connections, formats, listeners, flows & macros.

Etlworks Integrator automatically tracks changes for all artifacts: connections, formats, listeners, flows, macros, and schedules. There is nothing to configure except the retention policy.

Version control is supported for the following artifacts: flows, connections, formats, listeners, schedules, macros.

Using Etlwork’s built-in version control you can:

  • View the history of changes – who-changed-what-and-when.
  • Compare any two versions.
  • Revert to any previous version.
  • Add comments to the commit when saving the artifacts.

Etlworks version control 

To access the version control UI click the [@] button at the bottom left corner of each screen.

mceclip0

Then, click the [@] button at the bottom left corner of each screen to view the history of changes.

mceclip4

You can compare any two versions by selecting versions and click [View Diff between Selected]. mceclip5

The changes are displayed in a two-panel or unified view. From this view, you can navigate back and forward in the history of changes and also revert to any version.mceclip12

To view the specific version and compare it with a previous one click the [eye] button.mceclip6

To revert to any previous version:

Step 1. Click the [Revert] button.mceclip7

Step 2. Confirm that you want to revert to the previous version by clicking the Revert button.

Step 3. Click [Save] or [Save with message] to complete the revert.mceclip9

When saving any change, to any artifact you have an option to add a message (comments) to the commit. To add a message to the commit click the [Save with message] button.mceclip10

The commit message is displayed in the Change History popup.mceclip11

In Conclusion

After reading this blog, hopefully, you have a better understanding of version control. Version control is very helpful for organizing and backing up artifacts you are working with. It is also helpful for multiple people working on one artifact. Version Control is a great way to keep your artifacts organized and backed up in case of the worse.

Begin your data journey, get 14-day free trial!

Author: Olena S.

Data Architect, University of Pittsburgh

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s