Etl.Net 1.0.161-alpha

.NET Standard 2.0
Suggested Alternatives

Paillave.EtlNet.Core

This is a prerelease version of Etl.Net.
dotnet add package Etl.Net --version 1.0.161-alpha
NuGet\Install-Package Etl.Net -Version 1.0.161-alpha
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.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
#r "nuget: Etl.Net, 1.0.161-alpha"
#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 Etl.Net as a Cake Addin
#addin nuget:?package=Etl.Net&version=1.0.161-alpha&prerelease

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

Mass processing data with a complete ETL for .net developers

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 net7.0 net7.0-android net7.0-ios net7.0-maccatalyst net7.0-macos net7.0-tvos net7.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.
  • .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.SqlServer

Sql Server extensions for Etl.Net

Etl.Net.ExcelFile

Excel files extensions for Etl.Net

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
1.0.161-alpha 943 3/7/2019
1.0.160-alpha 674 2/23/2019
1.0.159-alpha 709 2/20/2019
1.0.158-alpha 750 2/14/2019
1.0.157-alpha 709 2/9/2019
1.0.155-alpha 746 1/31/2019
1.0.152-alpha 715 1/22/2019
1.0.151-alpha 683 1/3/2019
1.0.150-alpha 699 12/30/2018
1.0.146-alpha 713 12/28/2018
1.0.144-alpha 699 12/27/2018
1.0.143-alpha 695 12/27/2018
1.0.142-alpha 626 12/26/2018
1.0.141-alpha 644 12/26/2018
1.0.140-alpha 706 11/21/2018
1.0.139-alpha 679 11/18/2018
1.0.138-alpha 703 11/18/2018
1.0.137-alpha 669 11/18/2018
1.0.136-alpha 642 11/18/2018
1.0.135-alpha 695 11/13/2018
1.0.134-alpha 702 11/12/2018
1.0.133-alpha 660 11/11/2018
1.0.132-alpha 653 11/4/2018
1.0.131-alpha 684 10/18/2018
1.0.130-alpha 691 10/16/2018
1.0.129-alpha 726 10/16/2018
1.0.128-alpha 711 10/1/2018
1.0.127-alpha 697 10/1/2018
1.0.126-alpha 687 9/30/2018
1.0.125-alpha 673 9/30/2018
1.0.124-alpha 669 9/28/2018
1.0.123-alpha 732 9/26/2018
1.0.122-alpha 695 9/25/2018
1.0.121-alpha 685 9/25/2018
1.0.120-alpha 688 9/25/2018
1.0.118-beta 685 9/25/2018
1.0.116-beta 684 9/25/2018
1.0.114-beta 686 9/25/2018
1.0.111-alpha 685 9/22/2018
1.0.109-alpha 665 9/21/2018
1.0.108-alpha 691 9/19/2018
1.0.107-alpha 702 9/16/2018
1.0.106-alpha 655 9/14/2018
1.0.105-alpha 715 9/14/2018
1.0.104-alpha 662 9/12/2018
1.0.103-alpha 678 9/12/2018
1.0.102-alpha 633 9/10/2018
1.0.101-alpha 639 9/10/2018
1.0.100-alpha 649 9/10/2018
1.0.99-alpha 651 9/10/2018
1.0.98-alpha 630 9/10/2018
1.0.97-alpha 679 9/10/2018
1.0.96-alpha 627 9/8/2018
1.0.95-alpha 604 9/6/2018
1.0.93-alpha 571 9/3/2018
1.0.88-alpha 611 9/2/2018
1.0.86-alpha 586 9/2/2018
1.0.85-alpha 496 9/2/2018

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)