actionETL 0.40.0
dotnet add package actionETL --version 0.40.0
NuGet\Install-Package actionETL -Version 0.40.0
<PackageReference Include="actionETL" Version="0.40.0" />
paket add actionETL --version 0.40.0
#r "nuget: actionETL, 0.40.0"
// Install actionETL as a Cake Addin
#addin nuget:?package=actionETL&version=0.40.0
// Install actionETL as a Cake Tool
#tool nuget:?package=actionETL&version=0.40.0
Cross-platform ETL library for easily writing high performance, highly productive ETL data processing applications in C#, VB, etc. running on Windows and Linux. Well-suited to both small and truly large and complex projects.
- Community: Get your FREE license at https://envobi.com/community-edition
- Trial: Evaluate the commercial versions at https://envobi.com/trial
- Commercial: View and purchase the product at https://envobi.com/
### Supported Platforms ###
- .NET Framework 4.6.1+
- .NET Standard 2.0+
- .NET Core 2.1+ (via .NET Standard 2.0)
- .NET 5+ (via .NET Standard 2.0)
- Windows and Linux
- On-premises and cloud
### Features ###
- Extensive dataflow and control flow capabilities
- MariaDB, MySQL, PostgreSQL, SQLite, and SQL Server targeted database providers
- ODBC database provider for other databases
- High performance bulk insert
- Spreadsheet, delimited, fixed format, etc.
- Use nuget.org to easily retrieve new versions of actionETL
and much more, see https://envobi.com/ for details.
| 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 net481 |
| MonoAndroid | monoandroid |
| MonoMac | monomac |
| MonoTouch | monotouch |
| Tizen | tizen40 tizen60 |
| Xamarin.iOS | xamarinios |
| Xamarin.Mac | xamarinmac |
| Xamarin.TVOS | xamarintvos |
| Xamarin.WatchOS | xamarinwatchos |
-
.NETFramework 4.6.1
- EPPlus (>= 4.5.3.3)
- FileHelpers (>= 3.4.2)
- Microsoft.Data.SqlClient (>= 2.1.2)
- Microsoft.DotNet.PlatformAbstractions (>= 3.1.6)
- MySql.Data (>= 8.0.24)
- MySqlConnector (>= 1.3.3)
- Newtonsoft.Json (>= 12.0.3)
- NLog (>= 4.7.5)
- NodaTime (>= 2.4.13)
- Npgsql (>= 4.1.9)
- System.Collections.Immutable (>= 5.0.0)
- System.Data.SQLite.Core (>= 1.0.113.6)
- System.Runtime.CompilerServices.Unsafe (>= 5.0.0)
- System.Threading.Tasks.Extensions (>= 4.5.4)
- System.ValueTuple (>= 4.5.0)
-
.NETStandard 2.0
- EPPlus (>= 4.5.3.3)
- FileHelpers (>= 3.4.2)
- Microsoft.Data.SqlClient (>= 2.1.2)
- Microsoft.DotNet.PlatformAbstractions (>= 3.1.6)
- MySql.Data (>= 8.0.24)
- MySqlConnector (>= 1.3.3)
- Newtonsoft.Json (>= 12.0.3)
- NLog (>= 4.7.5)
- NodaTime (>= 2.4.13)
- Npgsql (>= 4.1.9)
- System.Collections.Immutable (>= 5.0.0)
- System.Configuration.ConfigurationManager (>= 5.0.0)
- System.Data.Odbc (>= 5.0.0)
- System.Data.SQLite.Core (>= 1.0.113.6)
- System.Reflection.Emit.Lightweight (>= 4.7.0)
- System.Runtime.CompilerServices.Unsafe (>= 5.0.0)
- System.Threading.Tasks.Extensions (>= 4.5.4)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
Added additional MySql/MariaDB provider "MySqlConnector" supporting high performance Bulk Insert.
Added transaction support to AdbMySqlConnectorBulkInsertTarget and AdbSqlClientBulkInsertTarget.
Added AdbSqlClientBulkInsertTarget.ColumnOrderHints and renamed SqlBulkCopyOptions to CopyOptions.
AdbInsertTarget:
- Reduced database round-trips
- Renamed SetMaxRows() to SetRowLimits()
- Deprecated SetSingleRow()
- Support setting default transaction size and disabling transactions
- Fixed column mapping bug
- ErrorOutput:
- Fixed redirection of rows on insert exception
- Linking disables creating transactions
- Linking throws if there is a pre-existing transaction
Added AdbProvider.WithSql92InsertStatement() to simplify setting default batch and transaction sizes.
IAdbInsertStatementService for AdbInsertTarget:
- Renamed DefaultParametersPerStatement to DefaultValuesPerBatch
- Renamed MaxParametersPerStatement to MaxValuesPerBatch
- Added AConfigSettings.InsertStatementValuesPerBatch
- Added AConfigSettings.InsertStatementValuesPerTransaction
- Added rowsPerBatch parameter to Create()
ErrorOutputPort:
- Added SendErrorBuffer() for sending a batch of rows
- Only log exception and message on the first row in a batch
- Fixed bug when logging a null column
Removed deprecated InputPort.TakeRows().
### Package Dependency Changes ###
- FileHelpers 3.4.1 > 3.4.2
- Microsoft.Data.SqlClient 2.0.1 > 2.1.2
- MySqlConnector 1.3.3 added
- MySql.Data 8.0.22 > 8.0.24
- NodaTime 2.4.8 > 2.4.13
- Npgsql 4.1.6 > 4.1.9
- System.Net.NameResolution removed
- System.Net.Primitives removed