> For the complete documentation index, see [llms.txt](https://driftserver.gitbook.io/drift-server/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://driftserver.gitbook.io/drift-server/use/get-started/configuration.md).

# Configuration

The *systemdescription.yaml* file is located in directory store/system  

This file contains following sample  content

```yaml
---

subSystems:
  - key: PETSDB
    type: jdbc
    name: Pets Database
  - key: PRODUCTSDB
    type: jdbc
    name: Product Catalog
  - key: fs1
    type: filesystem
    name: 'Drive C:'

environments:
  - key: LOCAL
    name: Local
  - key: DEV
    name: Develop

connectionDetails:

  PETSDB::LOCAL: !<JDBCConnectionDetails>

    userName: user1
    password: pwd
    jdbcUrl: jdbc:h2:tcp://localhost/./test

    tableNames:
      - OWNERS
      - PETS
      - VETS

  PRODUCTSDB::LOCAL: !<JDBCConnectionDetails>

    userName: user1
    password: pwd
    jdbcUrl: jdbc:h2:tcp://localhost/./test2

    tableNames:
      - CUSTOMER
      - PRODUCT
      - SUPPLIER

  fs1::LOCAL: !<FileSystemSettings>
    directories:
      - path: C:\drift-file-system-test\root-folder-1
      - path: C:\drift-file-system-test\root-folder-2

```

The file has 3 sections:

* subsystems:&#x20;
  * a list subsystem descriptions
  * every subsystem has

    * key: unique id of the subsystem
    * type:&#x20;
      * 'jdbc' for SQL database subsystem
      * 'filesystem' for a file system
    * description

* environments
  * a list of environments (e.g. LOCAL, DEVELOPMENT, STAGING, PROD...)
  * every subsystem has a&#x20;

    * key: unique id of the environment
    * description&#x20;

* connectionDetails
  * a map of subsystem specific connection details for each subsystem/env combination
  * key: combination of \<subsystem key>::\<environment key>
  * value: subsystem specific connection details
    * jdbc: see [JDBC Connections](/drift-server/use/get-started/configuration/jdbc-connections.md)
    * filesystem: see [Filesysystem](/drift-server/use/get-started/configuration/filesystem.md)