ETLBox 3.5.1

.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. 
dotnet add package ETLBox --version 3.5.1                

                    
                

            
NuGet\Install-Package ETLBox -Version 3.5.1
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.1" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add ETLBox --version 3.5.1                

                    
                

            
#r "nuget: ETLBox, 3.5.1"
#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. 
// Install ETLBox as a Cake Addin
#addin nuget:?package=ETLBox&version=3.5.1

// Install ETLBox as a Cake Tool
#tool nuget:?package=ETLBox&version=3.5.1

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. 
.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 pack for ETLBox. ETLBox is a lightweight ETL (extract, transform, load) library and data integration toolbox for .NET.
ETLBox.Json

This is the Json connector for ETLBox. ETLBox is a lightweight ETL (extract, transform, load) library and data integration toolbox for .NET.
ETLBox.Postgres

This is the Postgres connector pack for ETLBox. ETLBox is a lightweight ETL (extract, transform, load) library and data integration toolbox for .NET.
ETLBox.Csv

This is the Csv connector for ETLBox. ETLBox is a lightweight ETL (extract, transform, load) library and data integration toolbox for .NET.
ETLBox.MySql

This is the MySql connector for ETLBox. ETLBox is a lightweight ETL (extract, transform, load) library and data integration toolbox for .NET.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
3.5.1 779 11/15/2024
3.5.0 1,066 10/14/2024
3.4.4 831 9/30/2024
3.4.3 1,132 9/12/2024
3.4.2 1,050 9/3/2024
3.4.1 1,598 7/15/2024
3.4.0 2,606 5/29/2024
3.3.0 3,501 3/14/2024
3.2.0 10,174 1/11/2024
3.1.0 6,120 11/24/2023
3.0.2 12,229 10/6/2023
3.0.1 2,339 9/27/2023
3.0.0 6,165 7/11/2023
2.7.1 2,483 6/5/2023
2.7.0 5,094 4/4/2023
2.6.8 6,634 2/9/2023
2.6.7 4,652 1/9/2023
2.6.6 8,195 10/28/2022
2.6.5 6,954 10/19/2022
2.6.4 7,037 10/10/2022
2.6.3 7,096 9/26/2022
2.6.2 7,139 7/8/2022
2.6.1 7,590 5/19/2022
2.6.0 7,410 3/22/2022
2.5.2 7,208 12/30/2021
2.5.1 4,550 10/8/2021
2.5.0 8,222 9/27/2021
2.4.4 5,495 8/4/2021
2.4.3 4,268 7/16/2021
2.4.2 4,292 7/2/2021
2.4.1 9,347 5/17/2021
2.4.0 4,109 4/13/2021
2.3.2 1,706 3/2/2021
2.3.1 4,146 2/16/2021
2.3.0 5,297 1/11/2021
2.2.5 4,371 12/21/2020
2.2.4 3,674 12/15/2020
2.2.3 3,986 12/4/2020
2.2.1 1,570 11/23/2020
2.2.0 4,449 11/17/2020
2.1.4-beta 1,247 10/28/2020
2.1.4-alpha 769 10/24/2020
2.1.3 1,716 10/23/2020
2.1.2 5,471 9/24/2020
2.1.1 1,709 9/3/2020
2.1.0 3,874 9/3/2020
2.0.7 1,099 8/13/2020
2.0.6 1,162 8/13/2020
2.0.5 1,797 7/14/2020
2.0.4 1,595 7/9/2020
2.0.3 1,523 7/1/2020
2.0.2 3,937 7/1/2020
2.0.1 3,642 6/19/2020
2.0.0 3,202 6/10/2020
1.8.9 1,403 6/10/2020
1.8.8 1,229 5/27/2020
1.8.8-beta 832 5/24/2020
1.8.8-alpha 877 5/18/2020
1.8.7 16,982 5/12/2020
1.8.7-alpha 787 4/22/2020
1.8.6 3,735 4/21/2020
1.8.5 2,240 4/9/2020
1.8.4 1,096 4/6/2020
1.8.3 2,835 3/24/2020
1.8.2 1,359 3/9/2020
1.8.2-alpha 938 2/28/2020
1.8.1 2,613 2/27/2020
1.8.0 2,249 2/22/2020
1.8.0-rc2 939 2/15/2020
1.8.0-rc1 794 2/14/2020
1.8.0-beta 783 2/10/2020
1.8.0-alpha 872 2/4/2020
1.7.7 1,452 1/29/2020
1.7.6 1,266 1/15/2020
1.7.5 1,242 1/5/2020
1.7.5-alpha 826 1/3/2020
1.7.4 1,158 1/2/2020
1.7.4-alpha 794 12/31/2019
1.7.3 1,128 12/26/2019
1.7.2 1,133 12/16/2019
1.7.1 1,665 11/30/2019
1.7.0 963 11/25/2019
1.6.5 1,049 11/22/2019
1.6.4 1,009 11/17/2019
1.6.3 1,621 11/8/2019
1.6.2 1,035 11/4/2019
1.6.2-alpha 823 10/22/2019
1.6.1 1,370 10/18/2019
1.6.0 1,037 10/7/2019
1.5.0 1,113 9/13/2019
1.4.2 1,023 8/30/2019
1.4.1 944 8/27/2019
1.4.0 961 8/8/2019
1.3.2 934 8/5/2019
1.3.1 1,071 6/26/2019
1.3.0 1,044 6/6/2019
1.2.3 988 6/5/2019
1.2.2 1,093 5/24/2019
1.2.1 1,031 4/22/2019
1.2.0 1,085 4/13/2019
1.1.2 1,115 3/28/2019
1.1.1 1,423 2/2/2019
1.1.0 1,118 1/28/2019
1.1.0-beta 954 1/14/2019
1.0.1 1,211 12/20/2018
1.0.0 1,126 12/17/2018
0.1.1 1,247 12/10/2018

What's new in 3.5.1

Features:
- SqlTask.ExecuteNonQuery/ExecuteReader/ExecuteScalar: Added CancellationToken parameter
- Aggregation now also works only with GroupColumns (equivalent to a GROUP BY)
- ColumnTransformation: Order index is now equivalent to the position in the resulting order
- Aggregation using dynamic objects: 'double' is preserved as data type when aggregating
- ColumnTransformation: Check dynamic object performance
- DbMerge now offers a CompareFunc to override comparison check
- Lookup: Added ShouldSkipRow which specifies a condition when a row should be skipped
- Pivot: Renaming PivotValueColumn to PivotValue, ValueAggregationFunc to ValueCombination and DuplicateAggregationFunc to ValueAggregation
- Pivot: Introducing PivotRow to specify the columns for grouping

Bug Fixes:
- DbMerge: Proper exception message when one of the IdColumns of a POCO is not writeable
- Exception during stream creation in streaming destination now written into Exception property