ETLBox 2.7.0

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#!

No packages depend on ETLBox.

Features: Aggregation: Adding AggregationCondition to only execute predefined aggregation methods when condition is met Added async methods for SqlTask (e.g. ExecuteNonQueryAsync), RowCountTask and TruncateTableTask DbMerge: ValueGeneratedColumns are now also populated for Exists in DbMerge output RowCountTask: Changed return type of Count() and HasRows() to expected return types int and bool Improving thrown exceptions- now the original exception is always thrown (was AggregateException before) CsvSource: Enabling auto detection of delimiter in default configuration Adding RequestCount to StreamMetaData Added ValueToSqlConversionFunc for Odbc/OleDb connection managers ExcelSource: Exposes property SheetNumber to specify a sheet index instead of a sheet name ExcelSource: Sheet name comparison by default is now case-insensitive (can be switched back to case-sensitive) ExcelDestination: Default Sheetname set to "Sheet1" Bug fixes: Aggregation: Group columns with the FirstValue aggregation method now properly retrieves the first value for a group Fixed slowed ODBC connector execution performance for tables with more than 20 columns ExcelSource: Only first sheet will be read from source if no sheet name is specified Fixed AccessViolation errors for bulk inserts via Odbc with MySql connector DbSource: Fixed issue with no white spaces when parsing column names in sql

.NET Core 3.1

.NET Standard 2.0

.NET 6.0

.NET Standard 2.1

.NET 5.0

Version Downloads Last updated
2.7.0 11 04/22/2024