Etl.Net 1.0.161-alpha

Mass processing data with a complete ETL for .net developers

This is a prerelease version of Etl.Net.
Install-Package Etl.Net -Version 1.0.161-alpha
dotnet add package Etl.Net --version 1.0.161-alpha
<PackageReference Include="Etl.Net" Version="1.0.161-alpha" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Etl.Net --version 1.0.161-alpha
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

ETL.net

Implementation of a multi platform reactive ETL for .net standard 2.0 working with a similar principle than SSIS, but that is used in the same way than Linq.
The reactive approach for the implementation of this engine ensures parallelized multi streams, high performances and low memory foot print even with million rows to process.

ETL Operators:
* Select Transformation
* Where Transformation
* Sort Transformation
* Left Join Transformation
* Lookup Transformation
* Union Transformation
* Skip Transformation
* Top Transformation
* Distinct Transformation
* Pivot Transformation
* Unpivot Transformation
* Aggregate Transformation
* Cross Apply Transformation
* Ensure Sorted Transformation
* Ensure Keyed Transformation
* Script Transformation
* Select keeping sorted Transformation
* Left join keeping sorted Transformation
* Lookup keeping sorted Transformation
* List folder files Data source
* Read csv file Data source
* Read excel file Data source
* Write csv file Data destination
* Write excel file Data destinaton (to be done)
* Read from Entity framework core Data source
* Write to Entity framework core Data destination
* Read from Entity framework Data source (to be done)
* Write to Entity framework Data destination (to be done)
* Entity framework core upsert Data destination
* Entity framework upsert Data destination (to be done)
* SQL Server bulk load Data destination (to be done)
* Read from sql server command Data source
* Write to sql server command Data destination
* List files from FTP Data source
* List file from SFTP Data source
* Read files from FTP Data source
* Read file from SFTP Data source
* Write files from FTP Data destination
* Write file from SFTP Data destination
* Read data from REST service Data source (to be done)
* Write data to REST service Data destination (to be done)
* Keep section Transformation
* Ignore section Transformation

Runtime features:
* Trace issued data of each node
* Trace any error
* Stop the entire process whenever an error is raised
* Trace statistic result of each node at the end of the process
* Trace time that is spent in each node at the end of the process (to be done)
* Publish a Job as a REST web service in web api core (to be done)
* Run any ETL operation on traces to permit to filter and save
* Show realtime process execution statistics as a sankey graph
* Web portal to host job definitions manage their executions (to be done)
* Power shell command tool to execute a job (to be done)
* Visual studio code addon to view the process as a sankey graph whenever the job definition class file is saved (to be done)
* Raise a warning on the risky node when a performance issue or a bad practice is detected given statistics (to be done)
* Interprets a T-SQL-like language script to build a job definition on the fly and run it (to be done)

  • .NETStandard 2.0

    • No dependencies.

NuGet packages (8)

Showing the top 5 NuGet packages that depend on Etl.Net:

Package Downloads
Etl.Net.ExecutionPlan
ExecutionPlan extensions for Etl.Net
Etl.Net.EntityFrameworkCore
EntityFrameworkCore extensions for Etl.Net
Etl.Net.TextFile
Text files extensions for Etl.Net
Etl.Net.ExcelFile
Excel files extensions for Etl.Net
Etl.Net.SqlServer
Sql Server extensions for Etl.Net

GitHub repositories

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated
1.0.161-alpha 369 3/7/2019
1.0.160-alpha 294 2/23/2019
1.0.159-alpha 286 2/20/2019
1.0.158-alpha 291 2/14/2019
1.0.157-alpha 274 2/9/2019
1.0.155-alpha 284 1/31/2019
1.0.152-alpha 279 1/22/2019
1.0.151-alpha 288 1/3/2019
1.0.150-alpha 282 12/30/2018
1.0.146-alpha 294 12/28/2018
1.0.144-alpha 256 12/27/2018
1.0.143-alpha 278 12/27/2018
1.0.142-alpha 263 12/26/2018
1.0.141-alpha 248 12/26/2018
1.0.140-alpha 304 11/21/2018
1.0.139-alpha 266 11/18/2018
1.0.138-alpha 285 11/18/2018
1.0.137-alpha 257 11/18/2018
1.0.136-alpha 249 11/18/2018
1.0.135-alpha 288 11/13/2018
1.0.134-alpha 296 11/12/2018
1.0.133-alpha 261 11/11/2018
1.0.132-alpha 268 11/4/2018
1.0.131-alpha 263 10/18/2018
1.0.130-alpha 289 10/16/2018
1.0.129-alpha 339 10/16/2018
1.0.128-alpha 282 10/1/2018
1.0.127-alpha 287 10/1/2018
1.0.126-alpha 263 9/30/2018
1.0.125-alpha 292 9/30/2018
1.0.124-alpha 280 9/28/2018
1.0.123-alpha 297 9/26/2018
1.0.122-alpha 289 9/25/2018
1.0.121-alpha 285 9/25/2018
1.0.120-alpha 282 9/25/2018
1.0.118-beta 282 9/25/2018
1.0.116-beta 278 9/25/2018
1.0.114-beta 278 9/25/2018
1.0.111-alpha 269 9/22/2018
1.0.109-alpha 272 9/21/2018
1.0.108-alpha 277 9/19/2018
1.0.107-alpha 290 9/16/2018
1.0.106-alpha 276 9/14/2018
1.0.105-alpha 310 9/14/2018
1.0.104-alpha 251 9/12/2018
1.0.103-alpha 280 9/12/2018
1.0.102-alpha 248 9/10/2018
1.0.101-alpha 256 9/10/2018
1.0.100-alpha 251 9/10/2018
1.0.99-alpha 265 9/10/2018
1.0.98-alpha 254 9/10/2018
1.0.97-alpha 293 9/10/2018
1.0.96-alpha 235 9/8/2018
1.0.95-alpha 249 9/6/2018
1.0.93-alpha 253 9/3/2018
1.0.88-alpha 267 9/2/2018
1.0.86-alpha 248 9/2/2018
1.0.85-alpha 203 9/2/2018