ETLBox 2.6.1

.NET 5.0 .NET Core 3.1 .NET Standard 2.0
Install-Package ETLBox -Version 2.6.1
dotnet add package ETLBox --version 2.6.1
<PackageReference Include="ETLBox" Version="2.6.1" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add ETLBox --version 2.6.1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: ETLBox, 2.6.1"
#r directive can be used in F# Interactive, C# scripting and .NET Interactive. 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=2.6.1

// Install ETLBox as a Cake Tool
#tool nuget:?package=ETLBox&version=2.6.1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

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 Versions
.NET net5.0 net5.0-windows net6.0 net6.0-android net6.0-ios net6.0-maccatalyst net6.0-macos net6.0-tvos net6.0-windows
.NET Core netcoreapp2.0 netcoreapp2.1 netcoreapp2.2 netcoreapp3.0 netcoreapp3.1
.NET Standard netstandard2.0 netstandard2.1
.NET Framework net461 net462 net463 net47 net471 net472 net48
MonoAndroid monoandroid
MonoMac monomac
MonoTouch monotouch
Tizen tizen40 tizen60
Xamarin.iOS xamarinios
Xamarin.Mac xamarinmac
Xamarin.TVOS xamarintvos
Xamarin.WatchOS xamarinwatchos
Compatible target framework(s)
Additional computed target framework(s)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (19)

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.MySql

This is the MySql connector 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.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
2.6.1 32 5/19/2022
2.6.0 495 3/22/2022
2.5.2 1,148 12/30/2021
2.5.1 1,409 10/8/2021
2.5.0 2,613 9/27/2021
2.4.4 1,449 8/4/2021
2.4.3 1,272 7/16/2021
2.4.2 1,382 7/2/2021
2.4.1 6,220 5/17/2021
2.4.0 1,187 4/13/2021
2.3.2 816 3/2/2021
2.3.1 1,250 2/16/2021
2.3.0 2,120 1/11/2021
2.2.5 1,692 12/21/2020
2.2.4 969 12/15/2020
2.2.3 1,320 12/4/2020
2.2.1 438 11/23/2020
2.2.0 1,634 11/17/2020
2.1.4-beta 269 10/28/2020
2.1.4-alpha 246 10/24/2020
2.1.3 1,014 10/23/2020
2.1.2 2,582 9/24/2020
2.1.1 849 9/3/2020
2.1.0 1,193 9/3/2020
2.0.7 443 8/13/2020
2.0.6 383 8/13/2020
2.0.5 576 7/14/2020
2.0.4 392 7/9/2020
2.0.3 701 7/1/2020
2.0.2 1,276 7/1/2020
2.0.1 1,112 6/19/2020
2.0.0 984 6/10/2020
1.8.9 416 6/10/2020
1.8.8 535 5/27/2020
1.8.8-beta 312 5/24/2020
1.8.8-alpha 327 5/18/2020
1.8.7 15,882 5/12/2020
1.8.7-alpha 302 4/22/2020
1.8.6 2,584 4/21/2020
1.8.5 1,377 4/9/2020
1.8.4 514 4/6/2020
1.8.3 2,175 3/24/2020
1.8.2 618 3/9/2020
1.8.2-alpha 355 2/28/2020
1.8.1 1,960 2/27/2020
1.8.0 626 2/22/2020
1.8.0-rc2 420 2/15/2020
1.8.0-rc1 292 2/14/2020
1.8.0-beta 294 2/10/2020
1.8.0-alpha 292 2/4/2020
1.7.7 772 1/29/2020
1.7.6 565 1/15/2020
1.7.5 531 1/5/2020
1.7.5-alpha 284 1/3/2020
1.7.4 477 1/2/2020
1.7.4-alpha 283 12/31/2019
1.7.3 484 12/26/2019
1.7.2 526 12/16/2019
1.7.1 1,000 11/30/2019
1.7.0 442 11/25/2019
1.6.5 418 11/22/2019
1.6.4 415 11/17/2019
1.6.3 705 11/8/2019
1.6.2 443 11/4/2019
1.6.2-alpha 316 10/22/2019
1.6.1 617 10/18/2019
1.6.0 482 10/7/2019
1.5.0 489 9/13/2019
1.4.2 423 8/30/2019
1.4.1 407 8/27/2019
1.4.0 446 8/8/2019
1.3.2 429 8/5/2019
1.3.1 461 6/26/2019
1.3.0 521 6/6/2019
1.2.3 433 6/5/2019
1.2.2 461 5/24/2019
1.2.1 551 4/22/2019
1.2.0 481 4/13/2019
1.1.2 501 3/28/2019
1.1.1 669 2/2/2019
1.1.0 545 1/28/2019
1.1.0-beta 498 1/14/2019
1.0.1 605 12/20/2018
1.0.0 520 12/17/2018
0.1.1 545 12/10/2018

Features:
ETLBox.MySql now references MySql.Data 8.0.29
XmlSource offers ElementNameRetrievalFunc to change the ElementName while processing Xml data
DbDestination and DbMerge  support instant reading of value generated columns (e.g. computed columns, identites or default values) after inserting/updating data
Fixing issue where IgnoreColumn set on mutiple props without column name threw an exception
Meta data retrieval for procedures in SqlServer added: TableDefinition.FromProcedureName(...)
ETLBoxError: Original exception now retrievable with GetException()
New connector: (Sybase) SAP ASE

Bugs:
Nullable int replaced with int type in ExcelColumn attribute (non basic CLR types lead to issues in attributes)