Abstract
In previous chapters, we have discussed not only the basics of migration/integration but also the types of documents required to develop a communication flow and strategic plan. The central theme through all this is that detail matters. And maintaining this level of detail is nowhere more critical than in the hub of your design known as the extraction, transformation, and load (ETL) middleware. We covered the features of this component to some degree in Chapter 2 and the accompanying Source-to-Target mapping spreadsheet in Chapter 4. Because it has such a significant impact as to the success or failure of your project, this chapter will focus on the options available to you for choosing the right tools and discuss several of the ETL tools currently in the marketplace that will best fit your integration needs.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Notes
- 1.
“Grail Knight: But Choose Wisely, for While the True Grail Will Bring You Life, the False Grail Will Take It from You.” 2019. Quotes.net. www.quotes.net/mquote/46785
- 2.
“ETL vs. ELT: The Difference Is in the How.” 2019. Blog.panoply.io. https://blog.panoply.io/etl-vs-elt-the-difference-is-in-the-how
- 3.
“ETL (Extract, Transform and Load).” 2019. Syncsort. www.syncsort.com/en/glossary/etl
- 4.
2019. Guru99.com. www.guru99.com/etl-extract-load-process.html
- 5.
“Data in Transit—An Overview | Sciencedirect Topics.” 2019. Sciencedirect.com. www.sciencedirect.com/topics/computer-science/data-in-transit
- 6.
“What Is Personally Identifiable Information (PII)?” 2019. Searchfinancialsecurity. https://searchfinancialsecurity.techtarget.com/definition/personally-identifiable-information
- 7.
“Best Practices for Securing Your Data In-Motion—Help Net Security.” 2019. Help Net Security. www.helpnetsecurity.com/2016/10/25/securing-data-in-motion/
- 8.
“Data in Motion—How to Protect It—5 Key Considerations.” 2019. Microsoft Pulse. https://pulse.microsoft.com/en-ie/technology-lifestyle-en-ie/na/fa3-data-in-motion-how-to-protect-it-5-key-considerations/
- 9.
2019. Guru99.com. www.guru99.com/etl-extract-load-process.html
- 10.
“What Is Data Integrity and Why Is It Important?—Talend.” 2019. Talend Real-Time Open Source Data Integration Software. www.talend.com/resources/what-is-data-integrity/
- 11.
“Oracle/PLSQL: ORA-01400 Error Message.” 2019. Techonthenet.com. www.techonthenet.com/oracle/errors/ora01400.php
- 12.
“What Is Unicode, UTF-8, UTF-16?” 2019. Stack Overflow. https://stackoverflow.com/questions/2241348/what-is-unicode-utf-8-utf-16
- 13.
“Talend Downloads: ETL Tools, Data Integration, and More.” 2019. Talend Real-Time Open Source Data Integration Software. www.talend.com/download/
- 14.
Matt Casters, Roland Bouman, and Jos van Dongen. 2010. Pentaho Kettle Solutions. Indianapolis: Wiley.
- 15.
“Microsoft Evaluation Center.” 2019. Microsoft.com. www.microsoft.com/en-us/evalcenter/evaluate-sql-server
- 16.
“Top Python ETL Tools (aka Airflow vs. the World).” 2019. Blog.panoply.io. https://blog.panoply.io/top-9-python-etl-tools-and-when-to-use-them
- 17.
“ETL Is Dying.” 2019. Data, Analytics and Beyond. https://tombreur.wordpress.com/2017/02/19/etl-is-dying/
- 18.
Goldfedder, Jarrett. 2017. “ETL: It’s Not Dead Yet.” Linkedin.com. www.linkedin.com/pulse/etl-its-dead-yet-jarrett-goldfedder
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2020 Jarrett Goldfedder
About this chapter
Cite this chapter
Goldfedder, J. (2020). Choosing an ETL Tool. In: Building a Data Integration Team. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-5653-4_5
Download citation
DOI: https://doi.org/10.1007/978-1-4842-5653-4_5
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-5652-7
Online ISBN: 978-1-4842-5653-4
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books