Electronic Data Capture (EDC)

RPB integrates with OpenClinica (3.9) or LibreClinica (1.x) Electronic Data Capture system which is used to build eCRF forms and conduct study data.

OS Init Application Server Database
Debian 9 (Stretch) System V JDK 7, Tomcat 7 PostgreSQL 8.4 PostgreSQL 9.5
Debian 11 (Bullseye) System V JDK 8, Tomcat 9 PostgreSQL 13

PostgreSQL

  • Port: 5432
  • Locale: UTF8
  • Root user: postgres
Listing 2 Create clinica role and openclinica database
psql -U postgres -c "CREATE ROLE clinica LOGIN ENCRYPTED PASSWORD 'clinica' SUPERUSER NOINHERIT NOCREATEDB NOCREATEROLE"
psql -U postgres -c "CREATE DATABASE openclinica WITH ENCODING='UTF8' OWNER=clinica"

OpenClinica

OpenClinica instance need to be configured to know where to look for Designer application if it is installed.

Listing 3 Specify URL of Designer for redirection from OpenClinica
vi TOMCAT_HOME/openclinica.config/datainfo.properties

designerURL=http://hostname.de:8080/Designer

Tomcat need to be restarted to apply these configuration changes.

Designer

Designer distributable WAR file need to be deployed to Tomcat. Afterward the Designer need to be configured to allow OpenClinica instances to use it. Property “allowHosts” need to list all servers (running OpenClinica instances) which are allowed to used Designer (only server host and port are necessary, without OpenClinica application name).

Listing 4 Specify servers that are allowed to use the Designer
vi TOMCAT_HOME/webapps/Designer/WEB-INF/classes/resource.properties

allowHosts=localhost:8080, hostname.de:8080, radplanbio.partner-site.de

Tomcat need to be restarted to apply these configuration changes.

Enketo

Mobile friendly forms.