---
title: "Add ETL Operation"
url: "https://docs.ravendb.net/6.2/client-api/operations/maintenance/etl/add-etl"
version: "6.2"
language: "java"
---

# Add ETL Operation

> Client language: Java. Also available for [C#](https://docs.ravendb.net/6.2/client-api/operations/maintenance/etl/add-etl.md), [Node.js](https://docs.ravendb.net/6.2/client-api/operations/maintenance/etl/add-etl.nodejs.md).
>
> RavenDB publishes an official agent skill for coding assistants at https://docs.ravendb.net/skills/ravendb/SKILL.md (also installable with `npx skills add ravendb/skills`). The skill describes itself as: "Read this before writing any RavenDB query, client call or /databases/ request. Covers server setup, document modelling, the Node.js, .NET and Python clients, RQL, indexes, vector search and AI agents. Code written from recall tends to run and return the wrong rows, because RQL resembles SQL and the clients take field names as plain strings."

> **Note**
>
> - Use the `AddEtlOperation` method to add a new ongoing ETL task to your database.
>
> - To learn about ETL (Extract, Transfer, Load) ongoing tasks, see article [ETL Basics](https://docs.ravendb.net/6.2/server/ongoing-tasks/etl/basics.md).  
>   To learn how to manage ETL tasks from the Studio, see [Ongoing tasks - overview](https://docs.ravendb.net/6.2/studio/database/tasks/ongoing-tasks/general-info.md).
>
> - In this page:
>   - [Example - add Raven ETL](#example---add-raven-etl)
>   - [Example - add SQL ETL](#example---add-sql-etl)
>   - [Example - add OLAP ETL](#example---add-olap-etl)
>   - [Syntax](#syntax)

## Example - add Raven ETL

```java
RavenEtlConfiguration configuration = new RavenEtlConfiguration();
configuration.setName("Employees ETL");
Transformation transformation = new Transformation();
transformation.setName("Script #1");
transformation.setScript("loadToEmployees ({\n" +
  "  Name: this.FirstName + ' ' + this.LastName,\n" +
  "  Title: this.Title\n" +
  "});");

configuration.setTransforms(Arrays.asList(transformation));
AddEtlOperation<RavenConnectionString> operation = new AddEtlOperation<>(configuration);
AddEtlOperationResult result = store.maintenance().send(operation);
```

> **Note**
>
> **Secure servers**:
>
> To [connect secure RavenDB servers](https://docs.ravendb.net/6.2/server/security/authentication/certificate-management.md#enabling-communication-between-servers:-importing-and-exporting-certificates)
> you need to
>
> 1. Export the server certificate from the source server.
> 2. Install it as a client certificate on the destination server.
>
> This can be done in the RavenDB Studio -> Server Management -> [Certificates view](https://docs.ravendb.net/6.2/server/security/authentication/certificate-management.md#studio-certificates-management-view).

## Example - add SQL ETL

```java
SqlEtlConfiguration configuration = new SqlEtlConfiguration();
SqlEtlTable table1 = new SqlEtlTable();
table1.setTableName("Orders");
table1.setDocumentIdColumn("Id");
table1.setInsertOnlyMode(false);

SqlEtlTable table2 = new SqlEtlTable();
table2.setTableName("OrderLines");
table2.setDocumentIdColumn("OrderId");
table2.setInsertOnlyMode(false);

configuration.setSqlTables(Arrays.asList(table1, table2));
configuration.setName("Order to SQL");
configuration.setConnectionStringName("sql-connection-string-name");

Transformation transformation = new Transformation();
transformation.setName("Script #1");
transformation.setCollections(Arrays.asList("Orders"));
transformation.setScript("var orderData = {\n" +
  "    Id: id(this),\n" +
  "    OrderLinesCount: this.Lines.length,\n" +
  "    TotalCost: 0\n" +
  "};\n" +
  "\n" +
  "    for (var i = 0; i < this.Lines.length; i++) {\n" +
  "        var line = this.Lines[i];\n" +
  "        orderData.TotalCost += line.PricePerUnit;\n" +
  "\n" +
  "        // Load to SQL table 'OrderLines'\n" +
  "        loadToOrderLines({\n" +
  "            OrderId: id(this),\n" +
  "            Qty: line.Quantity,\n" +
  "            Product: line.Product,\n" +
  "            Cost: line.PricePerUnit\n" +
  "        });\n" +
  "    }\n" +
  "    orderData.TotalCost = Math.round(orderData.TotalCost  * 100) / 100;\n" +
  "\n" +
  "    // Load to SQL table 'Orders'\n" +
  "    loadToOrders(orderData)");

configuration.setTransforms(Arrays.asList(transformation));

AddEtlOperation<SqlConnectionString> operation = new AddEtlOperation<>(configuration);

AddEtlOperationResult result = store.maintenance().send(operation);
```

## Example - add OLAP ETL

```java
OlapEtlConfiguration configuration = new OlapEtlConfiguration();

configuration.setName("Orders ETL");
configuration.setConnectionStringName("olap-connection-string-name");

Transformation transformation = new Transformation();
transformation.setName("Script #1");
transformation.setCollections(Arrays.asList("Orders"));
transformation.setScript("var orderDate = new Date(this.OrderedAt);\n"+
  "var year = orderDate.getFullYear();\n"+
  "var month = orderDate.getMonth();\n"+
  "var key = new Date(year, month);\n"+
  "loadToOrders(key, {\n"+
  "    Company : this.Company,\n"+
  "    ShipVia : this.ShipVia\n"+
  "})"
);

configuration.setTransforms(Arrays.asList(transformation));

AddEtlOperation<OlapConnectionString> operation = new AddEtlOperation<OlapConnectionString>(configuration);

AddEtlOperationResult result = store.maintenance().send(operation);
```

## Syntax

```java
public AddEtlOperation(EtlConfiguration<T> configuration);
```

| Parameter | Type | Description |
| - | - | - |
| **configuration** | `EtlConfiguration<T>` | ETL configuration where `T` is connection string type |

## See also

- [ETL basics](https://docs.ravendb.net/6.2/server/ongoing-tasks/etl/basics.md)
- [RavenDB ETL](https://docs.ravendb.net/6.2/server/ongoing-tasks/etl/raven.md)
- [SQL ETL](https://docs.ravendb.net/6.2/server/ongoing-tasks/etl/sql.md)
- [OLAP ETL](https://docs.ravendb.net/6.2/server/ongoing-tasks/etl/olap.md)
- [Elasticsearch ETL](https://docs.ravendb.net/6.2/server/ongoing-tasks/etl/elasticsearch.md)
- [Kafka ETL](https://docs.ravendb.net/6.2/server/ongoing-tasks/etl/queue-etl/kafka.md)
- [RabbitMQ ETL](https://docs.ravendb.net/6.2/server/ongoing-tasks/etl/queue-etl/rabbit-mq.md)
- [Azure Queue Storage ETL](https://docs.ravendb.net/6.2/server/ongoing-tasks/etl/queue-etl/azure-queue.md)
- [Ongoing tasks - overview](https://docs.ravendb.net/6.2/studio/database/tasks/ongoing-tasks/general-info.md)
- [RavenDB ETL Task](https://docs.ravendb.net/6.2/studio/database/tasks/ongoing-tasks/ravendb-etl-task.md)
- [OLAP ETL Task](https://docs.ravendb.net/6.2/studio/database/tasks/ongoing-tasks/olap-etl-task.md)
- [Elasticsearch ETL Task](https://docs.ravendb.net/6.2/studio/database/tasks/ongoing-tasks/elasticsearch-etl-task.md)
- [Kafka ETL Task](https://docs.ravendb.net/6.2/studio/database/tasks/ongoing-tasks/kafka-etl-task.md)
- [RabbitMQ ETL Task](https://docs.ravendb.net/6.2/studio/database/tasks/ongoing-tasks/rabbitmq-etl-task.md)
- [Azure Queue Storage ETL Task](https://docs.ravendb.net/6.2/studio/database/tasks/ongoing-tasks/azure-queue-storage-etl.md)
- [Add](https://docs.ravendb.net/6.2/client-api/operations/maintenance/connection-strings/add-connection-string.md)
- [Get](https://docs.ravendb.net/6.2/client-api/operations/maintenance/connection-strings/get-connection-string.md)
- [Remove](https://docs.ravendb.net/6.2/client-api/operations/maintenance/connection-strings/remove-connection-string.md)
