Etl.Net 1.0.114-beta

This is a prerelease version of Etl.Net.
There is a newer prerelease version of this package available.
See the version list below for details.
dotnet add package Etl.Net --version 1.0.114-beta                
NuGet\Install-Package Etl.Net -Version 1.0.114-beta                
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="Etl.Net" Version="1.0.114-beta" />                
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Etl.Net --version 1.0.114-beta                
#r "nuget: Etl.Net, 1.0.114-beta"                
#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 Etl.Net as a Cake Addin
#addin nuget:?package=Etl.Net&version=1.0.114-beta&prerelease

// Install Etl.Net as a Cake Tool
#tool nuget:?package=Etl.Net&version=1.0.114-beta&prerelease                

Mass processing data with a complete ETL for .net developers

Product Compatible and additional computed target framework versions.
.NET net5.0 was computed.  net5.0-windows was computed.  net6.0 was computed.  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 was computed.  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.
  • .NETStandard 2.0

    • No dependencies.

NuGet packages (8)

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

Package Downloads
Etl.Net.TextFile

Text files extensions for Etl.Net

Etl.Net.EntityFrameworkCore

EntityFrameworkCore extensions for Etl.Net

Etl.Net.ExecutionPlan

ExecutionPlan 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 Downloads Last updated
1.0.161-alpha 1,063 3/7/2019 1.0.161-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.160-alpha 727 2/23/2019 1.0.160-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.159-alpha 757 2/20/2019 1.0.159-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.158-alpha 808 2/14/2019 1.0.158-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.157-alpha 761 2/9/2019 1.0.157-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.155-alpha 792 1/31/2019 1.0.155-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.152-alpha 766 1/22/2019 1.0.152-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.151-alpha 732 1/3/2019 1.0.151-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.150-alpha 749 12/30/2018 1.0.150-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.146-alpha 762 12/28/2018 1.0.146-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.144-alpha 753 12/27/2018 1.0.144-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.143-alpha 744 12/27/2018 1.0.143-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.142-alpha 674 12/26/2018 1.0.142-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.141-alpha 696 12/26/2018 1.0.141-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.140-alpha 775 11/21/2018 1.0.140-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.139-alpha 733 11/18/2018 1.0.139-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.138-alpha 756 11/18/2018 1.0.138-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.137-alpha 724 11/18/2018 1.0.137-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.136-alpha 701 11/18/2018 1.0.136-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.135-alpha 747 11/13/2018 1.0.135-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.134-alpha 752 11/12/2018 1.0.134-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.133-alpha 713 11/11/2018 1.0.133-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.132-alpha 708 11/4/2018 1.0.132-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.131-alpha 738 10/18/2018 1.0.131-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.130-alpha 745 10/16/2018 1.0.130-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.129-alpha 783 10/16/2018 1.0.129-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.128-alpha 761 10/1/2018 1.0.128-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.127-alpha 749 10/1/2018 1.0.127-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.126-alpha 737 9/30/2018 1.0.126-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.125-alpha 726 9/30/2018 1.0.125-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.124-alpha 741 9/28/2018 1.0.124-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.123-alpha 812 9/26/2018 1.0.123-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.122-alpha 773 9/25/2018 1.0.122-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.121-alpha 756 9/25/2018 1.0.121-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.120-alpha 754 9/25/2018 1.0.120-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.118-beta 748 9/25/2018 1.0.118-beta is deprecated because it is no longer maintained and has critical bugs.
1.0.116-beta 749 9/25/2018 1.0.116-beta is deprecated because it is no longer maintained and has critical bugs.
1.0.114-beta 752 9/25/2018 1.0.114-beta is deprecated because it is no longer maintained and has critical bugs.
1.0.111-alpha 752 9/22/2018 1.0.111-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.109-alpha 733 9/21/2018 1.0.109-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.108-alpha 756 9/19/2018 1.0.108-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.107-alpha 767 9/16/2018 1.0.107-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.106-alpha 721 9/14/2018 1.0.106-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.105-alpha 788 9/14/2018 1.0.105-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.104-alpha 725 9/12/2018 1.0.104-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.103-alpha 744 9/12/2018 1.0.103-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.102-alpha 693 9/10/2018 1.0.102-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.101-alpha 704 9/10/2018 1.0.101-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.100-alpha 718 9/10/2018 1.0.100-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.99-alpha 714 9/10/2018 1.0.99-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.98-alpha 693 9/10/2018 1.0.98-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.97-alpha 754 9/10/2018 1.0.97-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.96-alpha 690 9/8/2018 1.0.96-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.95-alpha 668 9/6/2018 1.0.95-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.93-alpha 635 9/3/2018 1.0.93-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.88-alpha 683 9/2/2018 1.0.88-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.86-alpha 659 9/2/2018 1.0.86-alpha is deprecated because it is no longer maintained and has critical bugs.
1.0.85-alpha 563 9/2/2018 1.0.85-alpha is deprecated because it is no longer maintained and has critical bugs.

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 (to be done)
* 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 (to be done)
* Entity framework upsert Data destination (to be done)
* SQL Server bulk load Data destination (to be done)
* Read from sql server command Data source (to be done)
* Write to sql server command Data destination (to be done)
* List files from FTP Data source (to be done)
* List file from SFTP Data source (to be done)
* Read files from FTP Data source (to be done)
* Read file from SFTP Data source (to be done)
* Write files from FTP Data destination (to be done)
* Write file from SFTP Data destination (to be done)
* Read data from REST service Data source (to be done)
* Write data to REST service Data destination (to be done)
* Keep section Transformation (to be done)
* Ignore section Transformation (to be done)

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 graphic to represent the process as a directed graph
* Show graphic to represent the process as a sankey graph
* Show graphic to represent process execution statistics as a directed graph
* Show graphic to represent process execution statistics as a sankey graph
* Show realtime process execution statistics as a directed graph (to be done)
* Show realtime process execution statistics as a sankey graph (to be done)
* 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 directed graph whenever the job definition class file is saved (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)