Skip to content

ETL procedures written in Java for data registration in openBIS version 20

License

Notifications You must be signed in to change notification settings

qbicsoftware/openbis20-java-dropboxes

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

18 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

OpenBiS Dropboxes

!!! abstract After the Data Scanner, data registration in openbis can be automated by dropboxes. We use Java Dropboxes to move files into OpenBis (see the Documentation on Java Dropboxes)

Context

sequenceDiagram
  autonumber
  User ->> SFTP Folder : move files
  Data Scanner ->> SFTP Folder : is new data present?
  SFTP Folder ->> Data Scanner : Yes
  Data Scanner ->> Dropbox Incoming : move files
  Data Scanner ->> Dropbox Incoming : create marker file
  Dropbox ->> Dropbox Incoming : Is marker file present?
  Dropbox Incoming ->> Dropbox : Yes
  Dropbox ->> OpenBiS : Register data
Loading

Dropbox Process

The dropbox processes the data before moving it into OpenBiS. A successful processing is shown below.

The process is triggered when a marker filed called MARKER_is_finished_<dirname> with <dirname> being the folder to be registered, is created.

sequenceDiagram
  autonumber
  IncomingFolder ->> Dropbox: Folder and Markerfile exist
  Dropbox ->> IncomingFolder: Read provenance.json
  Dropbox ->> Dropbox: Parse measurement ID
  Dropbox ->> OpenBiS DSS: Get measurement sample
  OpenBiS DSS ->> Dropbox: Give measurement sample
  Dropbox ->> OpenBiS DSS: Has measurement datasets?
  OpenBiS DSS ->> Dropbox: No
  Dropbox ->> Dropbox: Parse measurement properties
  Dropbox ->> OpenBiS DSS: Create dataset
  Dropbox ->> OpenBiS DSS: Send files to dataset
Loading

Dropbox Configuration

The dropbox configuration can be found at ... on the OpenBiS instance. Each folder within this directory creates a dropbox.

Within each folder exists a directory lib and a file plugin.properties. The lib folder is where you place your dropbox jar file. The plugin.properties is where you configure your dropbox.

incoming-dir=...
incoming-data-completeness-condition=marker-file
top-level-data-set-handler=ch.systemsx.cisd.etlserver.registrator.api.v2.JavaTopLevelDataSetHandlerV2
program-class=life.qbic.registration.openbis.OpenBisDropboxETL
storage-processor=ch.systemsx.cisd.etlserver.DefaultStorageProcessor

!!! info Ususally you only need to adapt the incoming-dir and program-class when setting up a new dropbox. For more configuration options please see the OpenBiS documentation.

About

ETL procedures written in Java for data registration in openBIS version 20

Resources

License

Stars

Watchers

Forks

Packages

No packages published