ETLBox 1.8.0-beta

Build your own ETL & data integration jobs with this handy C# library. Create your own dataflow, where data is send from a source to a target and transformed on its way. Data can be read from or written into various sources, e.g. databases, flat files or web services. ETLbox works with any custom source and offers out-of-the-box support for SqlServer, SQLite, MySql, Postgres, Json, CSV, Excel, Access & more.

Install-Package ETLBox -Version 1.8.0-beta

dotnet add package ETLBox --version 1.8.0-beta

<PackageReference Include="ETLBox" Version="1.8.0-beta" />

paket add ETLBox --version 1.8.0-beta

Release Notes

Improving Lookup with new set of attributes to define matching and retrieving properties. Also a new Aggretion component that simplifies creating aggregates (e.g. to calculate SUM, MIN, MAX or Count or any other custom defined calculation).
API CHANGES: Adjusted CSVSource/CSVDestination and DBSource/DBDestination to real CamelCase - they are now CsvSource/CsvDestination and DbSource/DbDestination. Further, ConnectionString was renamed to SqlConnectionString.

Dependencies

• .NETStandard 2.0

  • CsvHelper (>= 12.2.2)
  • ExcelDataReader (>= 3.6.0)
  • Microsoft.Data.SqlClient (>= 1.1.0)
  • Microsoft.Extensions.Configuration.Json (>= 3.1.0)
  • MySql.Data (>= 8.0.18)
  • Newtonsoft.Json (>= 12.0.3)
  • NLog (>= 4.6.8)
  • NLog.Extensions.Logging (>= 1.6.1)
  • Npgsql (>= 4.1.2)
  • System.Data.Common (>= 4.3.0)
  • System.Data.Odbc (>= 4.7.0)
  • System.Data.SqlClient (>= 4.8.0)
  • System.Data.SQLite.Core (>= 1.0.112)
  • System.Threading.Tasks.Dataflow (>= 4.11.0)
  • TSQL.Parser (>= 1.3.0)
  • Unofficial.Microsoft.AnalysisServices.AdomdClientNetCore (>= 15.3.1.2)

Used By

Version History