ETLBox 1.0.1
It's all in the box! Run all your ETL jobs with this awesome C# class library.
ETLBox is a comprehensive C# class library that is able to manage your whole ETL or ELT. You can use it to run some simple (or complex) sql against your database. You can easily manage your database using some easy-to-use and easy-to-understand objects. You can even create your own dataflow, where data is send from a source to a target and transformed on its way.
See the version list below for details.
Install-Package ETLBox -Version 1.0.1
dotnet add package ETLBox --version 1.0.1
<PackageReference Include="ETLBox" Version="1.0.1" />
paket add ETLBox --version 1.0.1
ETLBox
It's all in the box! Run all your ETL jobs with this awesome C# class library.
What is ETLBox
ETLBox is a comprehensive C# class library that is able to manage your whole ETL or ELT. You can use it to run some simple (or complex) sql against your database. You can easily manage your database using some easy-to-use and easy-to-understand objects. Or you can create your own dataflow pipeline, where data is send from a source to a target and transformed on its way. All that comes with extended logging capabilites, that allow you to monitor and anlayze your ETL job runs.
Why ETLBox
Perhaps you are looking for an alternative to Sql Server Integrations Services (SSIS). Or you are searching for a framework to define and run ETL jobs with C# code. The goal of ETLBox is to provide an easy-to-use but still powerful library with which you can create complex ETL routines and sophisticated data flows.
Advantages of using ETLBox
Build ETL in C#: Code your ETL with a language fitting your team’s skills and that is coming with a mature toolset
Run locally: Develop and test your ETL code locally on your desktop using your existing development & debugging tools.
Process In-Memory: ETLBox comes with dataflow components that allow in-memory processing which is much faster than storing data on disk and processing later.
Know your errors: When exceptions are raised you get the exact line of code where your ETL stopped, including a hands-on description of the error.
Manage Change: Track you changes with git (or other source controls), code review your etl logic, and use your existing CI/CD processes.
Embedded or standalone: With .net core and .net standard, etlbox is a self-deploying toolbox – usable where .net core runs. (.NET Core 2.1 or higher required)
ETLBox capabilites
ETLBox is split into two main components: Control Flow Tasks and Data Flow Tasks. Both components will provide customizable logging functionalities.
ETLBox
It's all in the box! Run all your ETL jobs with this awesome C# class library.
What is ETLBox
ETLBox is a comprehensive C# class library that is able to manage your whole ETL or ELT. You can use it to run some simple (or complex) sql against your database. You can easily manage your database using some easy-to-use and easy-to-understand objects. Or you can create your own dataflow pipeline, where data is send from a source to a target and transformed on its way. All that comes with extended logging capabilites, that allow you to monitor and anlayze your ETL job runs.
Why ETLBox
Perhaps you are looking for an alternative to Sql Server Integrations Services (SSIS). Or you are searching for a framework to define and run ETL jobs with C# code. The goal of ETLBox is to provide an easy-to-use but still powerful library with which you can create complex ETL routines and sophisticated data flows.
Advantages of using ETLBox
Build ETL in C#: Code your ETL with a language fitting your team’s skills and that is coming with a mature toolset
Run locally: Develop and test your ETL code locally on your desktop using your existing development & debugging tools.
Process In-Memory: ETLBox comes with dataflow components that allow in-memory processing which is much faster than storing data on disk and processing later.
Know your errors: When exceptions are raised you get the exact line of code where your ETL stopped, including a hands-on description of the error.
Manage Change: Track you changes with git (or other source controls), code review your etl logic, and use your existing CI/CD processes.
Embedded or standalone: With .net core and .net standard, etlbox is a self-deploying toolbox – usable where .net core runs. (.NET Core 2.1 or higher required)
ETLBox capabilites
ETLBox is split into two main components: Control Flow Tasks and Data Flow Tasks. Both components will provide customizable logging functionalities.
Release Notes
Reorganization of namespace.
See the API documentation for a whole list of all namespaces:
http://etlbox.net/api/index.html
Dependencies
-
.NETCoreApp 2.1
- CsvHelper (>= 12.0.1)
- Microsoft.SqlServer.SqlManagementObjects (>= 140.17283.0)
- Newtonsoft.Json (>= 12.0.1)
- NLog (>= 4.5.11)
- NLog.Extensions.Logging (>= 1.3.0)
- System.Data.Common (>= 4.3.0)
- System.Data.SqlClient (>= 4.6.0)
- System.Threading.Tasks.Dataflow (>= 4.9.0)
- Unofficial.Microsoft.AnalysisServices.AdomdClientNetCore (>= 15.3.1)
Used By
NuGet packages (14)
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.Excel
This is the Excel 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 History
Version | Downloads | Last updated |
---|---|---|
2.3.0 | 110 | 1/11/2021 |
2.2.5 | 176 | 12/21/2020 |
2.2.4 | 102 | 12/15/2020 |
2.2.3 | 342 | 12/4/2020 |
2.2.1 | 111 | 11/23/2020 |
2.2.0 | 516 | 11/17/2020 |
2.1.4-beta | 95 | 10/28/2020 |
2.1.4-alpha | 118 | 10/24/2020 |
2.1.3 | 253 | 10/23/2020 |
2.1.2 | 691 | 9/24/2020 |
2.1.1 | 420 | 9/3/2020 |
2.1.0 | 249 | 9/3/2020 |
2.0.7 | 206 | 8/13/2020 |
2.0.6 | 154 | 8/13/2020 |
2.0.5 | 322 | 7/14/2020 |
2.0.4 | 159 | 7/9/2020 |
2.0.3 | 455 | 7/1/2020 |
2.0.2 | 336 | 7/1/2020 |
2.0.1 | 319 | 6/19/2020 |
2.0.0 | 316 | 6/10/2020 |
1.8.9 | 152 | 6/10/2020 |
1.8.8 | 285 | 5/27/2020 |
1.8.8-beta | 182 | 5/24/2020 |
1.8.8-alpha | 171 | 5/18/2020 |
1.8.7 | 6,242 | 5/12/2020 |
1.8.7-alpha | 138 | 4/22/2020 |
1.8.6 | 1,712 | 4/21/2020 |
1.8.5 | 602 | 4/9/2020 |
1.8.4 | 230 | 4/6/2020 |
1.8.3 | 933 | 3/24/2020 |
1.8.2 | 302 | 3/9/2020 |
1.8.2-alpha | 220 | 2/28/2020 |
1.8.1 | 1,656 | 2/27/2020 |
1.8.0 | 336 | 2/22/2020 |
1.8.0-rc2 | 268 | 2/15/2020 |
1.8.0-rc1 | 152 | 2/14/2020 |
1.8.0-beta | 159 | 2/10/2020 |
1.8.0-alpha | 148 | 2/4/2020 |
1.7.7 | 391 | 1/29/2020 |
1.7.6 | 287 | 1/15/2020 |
1.7.5 | 266 | 1/5/2020 |
1.7.5-alpha | 137 | 1/3/2020 |
1.7.4 | 237 | 1/2/2020 |
1.7.4-alpha | 152 | 12/31/2019 |
1.7.3 | 256 | 12/26/2019 |
1.7.2 | 232 | 12/16/2019 |
1.7.1 | 729 | 11/30/2019 |
1.7.0 | 196 | 11/25/2019 |
1.6.5 | 162 | 11/22/2019 |
1.6.4 | 183 | 11/17/2019 |
1.6.3 | 310 | 11/8/2019 |
1.6.2 | 175 | 11/4/2019 |
1.6.2-alpha | 157 | 10/22/2019 |
1.6.1 | 342 | 10/18/2019 |
1.6.0 | 213 | 10/7/2019 |
1.5.0 | 262 | 9/13/2019 |
1.4.2 | 250 | 8/30/2019 |
1.4.1 | 228 | 8/27/2019 |
1.4.0 | 284 | 8/8/2019 |
1.3.2 | 265 | 8/5/2019 |
1.3.1 | 299 | 6/26/2019 |
1.3.0 | 321 | 6/6/2019 |
1.2.3 | 281 | 6/5/2019 |
1.2.2 | 298 | 5/24/2019 |
1.2.1 | 388 | 4/22/2019 |
1.2.0 | 302 | 4/13/2019 |
1.1.2 | 317 | 3/28/2019 |
1.1.1 | 439 | 2/2/2019 |
1.1.0 | 328 | 1/28/2019 |
1.1.0-beta | 300 | 1/14/2019 |
1.0.1 | 392 | 12/20/2018 |
1.0.0 | 307 | 12/17/2018 |
0.1.1 | 308 | 12/10/2018 |