ETLBox 3.5.2-alpha

.NET 6.0 This package targets .NET 6.0. The package is compatible with this framework or higher. .NET Standard 2.0 This package targets .NET Standard 2.0. The package is compatible with this framework or higher.
This is a prerelease version of ETLBox.
There is a newer version of this package available.
See the version list below for details. 
dotnet add package ETLBox --version 3.5.2-alpha
                    


                    

                
NuGet\Install-Package ETLBox -Version 3.5.2-alpha
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package. 
<PackageReference Include="ETLBox" Version="3.5.2-alpha" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
<PackageVersion Include="ETLBox" Version="3.5.2-alpha" />
                    


                            Directory.Packages.props
                        

                    

                
<PackageReference Include="ETLBox" />
                    


                            Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package. 
paket add ETLBox --version 3.5.2-alpha
                    


                    

                
#r "nuget: ETLBox, 3.5.2-alpha"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package. 
#addin nuget:?package=ETLBox&version=3.5.2-alpha&prerelease
                    


                            Install ETLBox as a Cake Addin
                        

                    

                
#tool nuget:?package=ETLBox&version=3.5.2-alpha&prerelease
                    


                            Install ETLBox as a Cake Tool

What is ETLBox

ETLBox is a lightweight ETL (extract, transform, load) library and data integration toolbox for .NET. You can use it to read any data from different sources and connect them with customizable transformations. Finally, you can export the data into different databases, web endpoints, file types or any other destinations. While data is processed in memory, you can choose between different transformation components to harmonize, filter, aggregate, validate and clean your data.

ETLBox is a fully functional alternative to other ETL tools like SQLServer Integrations Services (SSIS) or Azure Data Factory. The main difference to other toolsets is that it doesn’t come with a User Interface. But no worries! Working with ETLBox, you will discover that creating data flows programmatically is the best approach for solving most of your ETL and data integration related problems.

Why should I choose ETLBox?

Here are a few things you can do with ETLBox:

  • Convert incoming data to a common format.
  • Prepare data for analysis and visualization.
  • Migrate between databases.
  • Share data processing logic across web apps, batch jobs, and APIs.
  • Power your data ingestion and integration tools.
  • Consume large CSV, Excel or Json files.
  • Process big data with a limited amount of memory.
  • Bulk insert, update or delete into your database.

Core concepts

ETLBox is a data processing engine based on .NET Core, giving you the power to create your own ETL processes. This engine runs inside your applications, APIs, and jobs to extract, filter, transform, migrate data on-the-fly. ETLBox speeds up your development by providing an easy-to-use toolbox for integrating your data from different sources within your app and load them into any target you like.

Learn more: www.etlbox.net

Ready to learn more? Visit www.etlbox.net and get started with coding your own ETL jobs with C#!

Product Compatible and additional computed target framework versions.
.NET net5.0 was computed.  net5.0-windows was computed.  net6.0 is compatible.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 is compatible.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed.  net9.0 was computed.  net9.0-android was computed.  net9.0-browser was computed.  net9.0-ios was computed.  net9.0-maccatalyst was computed.  net9.0-macos was computed.  net9.0-tvos was computed.  net9.0-windows was computed. 
.NET Core netcoreapp2.0 was computed.  netcoreapp2.1 was computed.  netcoreapp2.2 was computed.  netcoreapp3.0 was computed.  netcoreapp3.1 was computed. 
.NET Standard netstandard2.0 is compatible.  netstandard2.1 was computed. 
.NET Framework net461 was computed.  net462 was computed.  net463 was computed.  net47 was computed.  net471 was computed.  net472 was computed.  net48 was computed.  net481 was computed. 
MonoAndroid monoandroid was computed. 
MonoMac monomac was computed. 
MonoTouch monotouch was computed. 
Tizen tizen40 was computed.  tizen60 was computed. 
Xamarin.iOS xamarinios was computed. 
Xamarin.Mac xamarinmac was computed. 
Xamarin.TVOS xamarintvos was computed. 
Xamarin.WatchOS xamarinwatchos was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (32)

Showing the top 5 NuGet packages that depend on ETLBox:

Package Downloads
ETLBox.SqlServer

This is the SQL Server connector for ETLBox. It enables integration with Microsoft SQL Server for handling structured data in ETL workflows. ETLBox is a complete ETL (Extract, Transform, Load) library and data integration toolbox for .NET. # Build scalable, code-first ETL pipelines for SQL, NoSQL, APIs, and flat files. # Automate data movement, transformation, and synchronization with minimal memory usage. # Ideal for data warehousing, migrations, and big data processing. Simplify your data integration workflow: ETLBox enables efficient, asynchronous data processing by reading from databases, APIs, and file formats like CSV, Excel, and JSON. Transform data dynamically with row-based, batch, or lookup transformations, and read or write from/to multiple destinations in parallel. Key Features: * Stream large datasets efficiently without loading everything into memory * Maximize performance with parallel, task-based data flow execution * Connect to various data sources with built-in connectors or extend with custom components For tutorials, examples, and documentation, visit: https://www.etlbox.net/
ETLBox.Json

This is the JSON connector for ETLBox. It lets you handle structured and semi-structured JSON data, whether working with files or APIs. ETLBox is a complete ETL (Extract, Transform, Load) library and data integration toolbox for .NET. # Build scalable, code-first ETL pipelines for SQL, NoSQL, APIs, and flat files. # Automate data movement, transformation, and synchronization with minimal memory usage. # Ideal for data warehousing, migrations, and big data processing. Simplify your data integration workflow: ETLBox enables efficient, asynchronous data processing by reading from databases, APIs, and file formats like CSV, Excel, and JSON. Transform data dynamically with row-based, batch, or lookup transformations, and read or write from/to multiple destinations in parallel. Key Features: * Stream large datasets efficiently without loading everything into memory * Maximize performance with parallel, task-based data flow execution * Connect to various data sources with built-in connectors or extend with custom components For tutorials, examples, and documentation, visit: https://www.etlbox.net/
ETLBox.Postgres

This is the PostgreSQL connector for ETLBox. It supports reading from and writing to PostgreSQL databases for scalable data pipelines. ETLBox is a complete ETL (Extract, Transform, Load) library and data integration toolbox for .NET. # Build scalable, code-first ETL pipelines for SQL, NoSQL, APIs, and flat files. # Automate data movement, transformation, and synchronization with minimal memory usage. # Ideal for data warehousing, migrations, and big data processing. Simplify your data integration workflow: ETLBox enables efficient, asynchronous data processing by reading from databases, APIs, and file formats like CSV, Excel, and JSON. Transform data dynamically with row-based, batch, or lookup transformations, and read or write from/to multiple destinations in parallel. Key Features: * Stream large datasets efficiently without loading everything into memory * Maximize performance with parallel, task-based data flow execution * Connect to various data sources with built-in connectors or extend with custom components For tutorials, examples, and documentation, visit: https://www.etlbox.net/
ETLBox.Csv

This is the CSV connector for ETLBox. It helps you read and write data in CSV format, making it easy to handle flat-file data for import, export, and transformations. ETLBox is a complete ETL (Extract, Transform, Load) library and data integration toolbox for .NET. # Build scalable, code-first ETL pipelines for SQL, NoSQL, APIs, and flat files. # Automate data movement, transformation, and synchronization with minimal memory usage. # Ideal for data warehousing, migrations, and big data processing. Simplify your data integration workflow: ETLBox enables efficient, asynchronous data processing by reading from databases, APIs, and file formats like CSV, Excel, and JSON. Transform data dynamically with row-based, batch, or lookup transformations, and read or write from/to multiple destinations in parallel. Key Features: * Stream large datasets efficiently without loading everything into memory * Maximize performance with parallel, task-based data flow execution * Connect to various data sources with built-in connectors or extend with custom components For tutorials, examples, and documentation, visit: https://www.etlbox.net/
ETLBox.MySql

This is the MySQL connector for ETLBox. It lets you connect to MySQL databases, handling relational data for ETL tasks and integrations. ETLBox is a complete ETL (Extract, Transform, Load) library and data integration toolbox for .NET. # Build scalable, code-first ETL pipelines for SQL, NoSQL, APIs, and flat files. # Automate data movement, transformation, and synchronization with minimal memory usage. # Ideal for data warehousing, migrations, and big data processing. Simplify your data integration workflow: ETLBox enables efficient, asynchronous data processing by reading from databases, APIs, and file formats like CSV, Excel, and JSON. Transform data dynamically with row-based, batch, or lookup transformations, and read or write from/to multiple destinations in parallel. Key Features: * Stream large datasets efficiently without loading everything into memory * Maximize performance with parallel, task-based data flow execution * Connect to various data sources with built-in connectors or extend with custom components For tutorials, examples, and documentation, visit: https://www.etlbox.net/

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
3.7.0 16,422 3/7/2025
3.6.1 19,208 1/6/2025
3.5.2 3,699 12/20/2024
3.5.2-beta 88 12/10/2024
3.5.2-alpha 80 12/3/2024
3.5.1 932 11/15/2024
3.5.0 2,346 10/14/2024
3.4.4 851 9/30/2024
3.4.3 1,209 9/12/2024
3.4.2 1,070 9/3/2024
3.4.1 1,646 7/15/2024
3.4.0 2,907 5/29/2024
3.3.0 3,782 3/14/2024
3.2.0 11,690 1/11/2024
3.1.0 6,167 11/24/2023
3.0.2 16,266 10/6/2023
3.0.1 2,375 9/27/2023
3.0.0 6,543 7/11/2023
2.7.1 2,526 6/5/2023
2.7.0 5,127 4/4/2023
2.6.8 6,691 2/9/2023
2.6.7 4,688 1/9/2023
2.6.6 8,248 10/28/2022
2.6.5 6,976 10/19/2022
2.6.4 7,079 10/10/2022
2.6.3 7,118 9/26/2022
2.6.2 7,203 7/8/2022
2.6.1 7,618 5/19/2022
2.6.0 7,581 3/22/2022
2.5.2 7,463 12/30/2021
2.5.1 4,586 10/8/2021
2.5.0 8,266 9/27/2021
2.4.4 5,553 8/4/2021
2.4.3 4,296 7/16/2021
2.4.2 4,320 7/2/2021
2.4.1 9,411 5/17/2021
2.4.0 4,142 4/13/2021
2.3.2 1,780 3/2/2021
2.3.1 4,185 2/16/2021
2.3.0 5,441 1/11/2021
2.2.5 4,428 12/21/2020
2.2.4 3,707 12/15/2020
2.2.3 4,019 12/4/2020
2.2.1 1,605 11/23/2020
2.2.0 4,482 11/17/2020
2.1.4-beta 1,294 10/28/2020
2.1.4-alpha 799 10/24/2020
2.1.3 1,751 10/23/2020
2.1.2 5,530 9/24/2020
2.1.1 1,742 9/3/2020
2.1.0 3,909 9/3/2020
2.0.7 1,133 8/13/2020
2.0.6 1,196 8/13/2020
2.0.5 1,833 7/14/2020
2.0.4 1,628 7/9/2020
2.0.3 1,558 7/1/2020
2.0.2 3,990 7/1/2020
2.0.1 3,701 6/19/2020
2.0.0 3,236 6/10/2020
1.8.9 1,685 6/10/2020
1.8.8 1,512 5/27/2020
1.8.8-beta 1,113 5/24/2020
1.8.8-alpha 1,153 5/18/2020
1.8.7 17,267 5/12/2020
1.8.7-alpha 1,063 4/22/2020
1.8.6 4,087 4/21/2020
1.8.5 2,527 4/9/2020
1.8.4 1,380 4/6/2020
1.8.3 3,123 3/24/2020
1.8.2 1,396 3/9/2020
1.8.2-alpha 969 2/28/2020
1.8.1 2,649 2/27/2020
1.8.0 2,360 2/22/2020
1.8.0-rc2 971 2/15/2020
1.8.0-rc1 825 2/14/2020
1.8.0-beta 815 2/10/2020
1.8.0-alpha 904 2/4/2020
1.7.7 1,491 1/29/2020
1.7.6 1,302 1/15/2020
1.7.5 1,289 1/5/2020
1.7.5-alpha 858 1/3/2020
1.7.4 1,196 1/2/2020
1.7.4-alpha 831 12/31/2019
1.7.3 1,166 12/26/2019
1.7.2 1,170 12/16/2019
1.7.1 1,702 11/30/2019
1.7.0 1,005 11/25/2019
1.6.5 1,084 11/22/2019
1.6.4 1,047 11/17/2019
1.6.3 1,731 11/8/2019
1.6.2 1,071 11/4/2019
1.6.2-alpha 857 10/22/2019
1.6.1 1,450 10/18/2019
1.6.0 1,075 10/7/2019
1.5.0 1,155 9/13/2019
1.4.2 1,062 8/30/2019
1.4.1 983 8/27/2019
1.4.0 999 8/8/2019
1.3.2 975 8/5/2019
1.3.1 1,109 6/26/2019
1.3.0 1,083 6/6/2019
1.2.3 1,027 6/5/2019
1.2.2 1,132 5/24/2019
1.2.1 1,070 4/22/2019
1.2.0 1,127 4/13/2019
1.1.2 1,161 3/28/2019
1.1.1 1,467 2/2/2019
1.1.0 1,162 1/28/2019
1.1.0-beta 996 1/14/2019
1.0.1 1,255 12/20/2018
1.0.0 1,168 12/17/2018
0.1.1 1,293 12/10/2018

What's new in 3.5.2 Alpha:

Features:
- ColumnTransformation: ReorderFunc now accepts object as return value, e.g. for sorting of string or date values
- Pivot: PivotValues now use same aggregation methods, custom functions and predicates like AggregationColumn
- Pivot: Added GrandTotal for columns and rows
- Pivot: ValueCombination has been removed
- Pivot: Added FlattenAggregationResults to flatten data if 2 or more PivotValues are used