> ## Documentation Index
> Fetch the complete documentation index at: https://docs.activeviam.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Properties

> Reference of configuration properties for the Data Extraction Engine (DEE) and Enhanced Drillthrough, including required properties such as `data.extraction.service.base.dir.path`, thread pool sizing, file retention, and CSV formatting options.

The Data Extraction Engine (DEE) exposes properties for the extraction service, Enhanced Drillthrough, and their defaults, grouped by required and optional settings.

## Required properties

Here are the required properties for the extraction engine:

| Property                                | Description                                                                                     | Default value        |
| --------------------------------------- | ----------------------------------------------------------------------------------------------- | -------------------- |
| `data.extraction.service.base.dir.path` | Path to the folder in which the files will be generated for regular extractions                 | must provide a value |
| `data.extraction.service.http.base.url` | URL mount point to access the folder as a Web File Server for regular extractions               | must provide a value |
| `enhanced.drillthrough.base.dir.path`   | Path to the folder in which the files will be generated for Enhanced Drillthrough extractions   | must provide a value |
| `enhanced.drillthrough.http.base.url`   | URL mount point to access the folder as a Web File Server for Enhanced Drillthrough extractions | must provide a value |

## Additional properties

Here are additional properties that can be set:

### Data Extraction Engine configuration properties

| Property                                          | Description                                                                                                                                                                                                                                                                     | Default value                           |
| ------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | --------------------------------------- |
| `data.extraction.templates.base.dir.path`         | Path to the folder holding the JSON order template files.                                                                                                                                                                                                                       |                                         |
| `dee.admin.granted.authority`                     | Granted authorities.                                                                                                                                                                                                                                                            | `ROLE_DEE_ADMIN`                        |
| `dee.thread.pool.size`                            | Number of possible concurrent extractions.                                                                                                                                                                                                                                      | half the number of cores on the machine |
| `dee.task.retention.min.days`                     | Number of days the generated files are retained.                                                                                                                                                                                                                                | `7`                                     |
| `data.extraction.service.with.user.folders`       | Include the user name in the generated folder path. Example: `/Output/User1/extraction.csv`                                                                                                                                                                                     | `true`                                  |
| `data.extraction.service.with.task.folders`       | Include the task ID in the generated folder path.                                                                                                                                                                                                                               | `false`                                 |
| `enable.data.extraction.service.logging`          | Enable service logging.                                                                                                                                                                                                                                                         | `true`                                  |
| `enable.data.extraction.service.detailed.logging` | Enable detailed service logging.                                                                                                                                                                                                                                                | `false`                                 |
| `enable.data.extraction.service.log.memory.stats` | Enable logging memory stats for the service.                                                                                                                                                                                                                                    | `false`                                 |
| `dee.get-aggregates-query.use-default-members`    | Enable using default members for missing coordinates of slicing hierarchies.<br /> When set to `true`, all members of a slicing hierarchy will be expressed in the query results.<br />To include only the default member of slicing hierarchies, set this property to `false`. | `true`                                  |

## Enhanced Drillthrough properties

Here is a list of the properties exposed, as well as their default value, for the Enhanced Drillthrough.

| Property                                        | Description                                                           | Default value                           |
| ----------------------------------------------- | --------------------------------------------------------------------- | --------------------------------------- |
| `enhanced.drillthrough.thread.pool.size`        | Number of possible concurrent extractions                             | half the number of cores on the machine |
| `enhanced.drillthrough.max.rows.per.file`       | Maximum number of rows in the generated file                          | `10000000`                              |
| `enhanced.drillthrough.max.raw.data.per.file`   | Maximum size for the raw data contained in the generated file (bytes) | `1073741824`                            |
| `enhanced.drillthrough.csv.separator`           | CSV Column separator                                                  | `,`                                     |
| `enhanced.drillthrough.surrounding.quotes.flag` | Add some surrounding double quotes around each column value           | `false`                                 |
| `enable.edt.service.logging`                    | Enable the logging of the service                                     | `true`                                  |
| `enable.edt.service.detailed.logging`           | Enable the detailed logging of the service                            | `false`                                 |
| `enable.edt.service.log.memory.stats`           | Enable the logging of the memory stats for the service                | `false`                                 |