Repository Data Model

The repository is stored in an H2 database. It contains the following structures:

  • Connections: The logical definition of used connections (databases, SAP systems, web services, etc.)
  • Master Data General: Configuration data
  • Authorisation: datasqill environments and access permissions
  • Batch: Scheduled executions and their folders
  • Runtime Metadata: Metadata of the used (external) databases
  • Transformation: All information about the contents of a worksheet and its folders
  • Master Data Module: Configuration data for the modules
  • Runtime Job Execution: Tables containing all information about the executions

datasqill data model