System Requirements

The library is available as the actionETL and actionETL.templates.dotnet packages from nuget.org (see An Introduction to NuGet), making it very easy to get started and to keep your ETL applications up to date. You can deploy both on-premises and in the cloud.

The library targets the following frameworks:

actionETL targets	Your project can target
.NET Standard 2.0 (Linux or Windows)	- .NET Core 2.1+ - .NET 5+ - .NET Standard 2.0+ - .NET Framework 4.7.2+ (non-default)
.NET Framework 4.6.1 (Windows only)	.NET Framework 4.6.1+

You can:

Develop and publish your actionETL applications on Windows® and/or Linux®
- You can even use VS Code on Windows as your IDE while remotely building and running on Linux, see Developing in WSL
Deploy and execute your application on the same OS, from Windows to Linux, or from Linux to Windows
- .NET Framework is Windows only
- .NET Core and .NET 5+ applications can optionally be "self-contained" and not require any framework installation on the target computer

Note

Database drivers (except for some ODBC servers) and Excel™ drivers listed below do not need to be installed on development or execution hosts, they are either included with actionETL or retrieved from NuGet during the build process, and are part of the deployed files. This simplifies deployment.

Development Requirements

Windows or Linux
Any .NET development environment, e.g.:
- dotnet command line tool
- Visual Studio® 2017 or later (e.g. the free Community edition)
  - Beginner tutorials Get started with Visual Studio and Get started with a C# console app in Visual Studio
- The free Visual Studio Code
Ensure your target .NET SDK(s) are installed
- For .NET Core and .NET 5+, see Install the .NET Core SDK. This page also lists minimum Visual Studio versions.
- For .NET Framework, see Installation guide (.NET Framework)
C# 7.2 or later is recommended, although earlier versions can also be used with only minor drawbacks.
- Other .NET languages such as Visual Basic® can also be used. Some parts of the library API may be inaccessible if your language version does not yet support the corresponding C# features.
NuGet dependencies, which will be automatically retrieved on package restore. These include:
- Data access:
  - EPPlus 4.x (which is free) - read & write Excel™ files
  - FileHelpers - read & write delimited (CSV) and fixed format files
  - Microsoft.Data.SqlClient - SQL Server access
  - MySql.Data - MySQL™ and MariaDB™ access
  - MySqlConnector - MySQL™ and MariaDB™ access (with bulk insert)
  - Newtonsoft.Json - Reading JSON configuration files
  - Npgsql - PostgreSQL® access
  - System.Data.SQLite.Core - SQLite access
  - System.Data.Odbc - ODBC access for other databases
- Logging:
  - NLog - default logging system, can be replaced

Execution Requirements

For hosts that only executes deployed actionETL applications:

Windows or Linux
self-contained .NET Core and .NET 5+ applications only require the published/deployed files
Non-self-contained applications consume less disk storage, but require the target .NET runtime to be present on the execution host (see runtime downloads).

Install or Update Dotnet Templates

To allow creating actionETL projects using dotnet new templates, each developer should:

Ensure .NET Core SDK (v2.1 or later) is installed on your development computer, see Install the .NET Core SDK
Install or update the actionETL templates from nuget.org:
```
dotnet new --install actionETL.templates.dotnet
```

For full details, see the Dotnet Templates article.

actionETL License

actionETL requires a license to run. Please get a FREE Community license, a free trial license or purchase a commercial license.

Also see the Licensing article.