Editing Extract, transform, load (section)

== Implementations ==

An established ETL framework may improve connectivity and [[scalability]].{{citation needed|date=December 2011}} A good ETL tool must be able to communicate with the many different [[relational database]]s and read the various file formats used throughout an organization. ETL tools have started to migrate into [[enterprise application integration]], or even [[enterprise service bus]], systems that now cover much more than just the extraction, transformation, and loading of data. Many ETL vendors now have [[data profiling]], [[data quality]], and [[Metadata (computing)|metadata]] capabilities. A common use case for ETL tools include converting CSV files to formats readable by relational databases. A typical translation of millions of records is facilitated by ETL tools that enable users to input csv-like data feeds/files and import them into a database with as little code as possible.

ETL tools are typically used by a broad range of professionals – from students in computer science looking to quickly import large data sets to database architects in charge of company account management, ETL tools have become a convenient tool that can be relied on to get maximum performance. ETL tools in most cases contain a GUI that helps users conveniently transform data, using a visual data mapper, as opposed to writing large programs to parse files and modify data types.

While ETL tools have traditionally been for developers and IT staff, research firm Gartner wrote that the new trend is to provide these capabilities to business users so they can themselves create connections and data integrations when needed, rather than going to the IT staff.<ref>{{cite web|title=The Inexorable Rise of Self Service Data Integration|url=http://blogs.gartner.com/andrew_white/2015/05/22/the-inexorable-rise-of-self-service-data-integration/|work=Gartner|date=22 May 2015|access-date=31 January 2016}}</ref> Gartner refers to these non-technical users as Citizen Integrators.<ref>{{cite web|title=Embrace the Citizen Integrator|url=https://www.gartner.com/doc/2891817/embrace-citizen-integrator-approach-improve|work=Gartner|access-date=September 29, 2021}}</ref>