When we configure your OpenClincia Data Mart, we make the following changes to your OpenClinica instance.

(Note: All changes are done in the extract.properties file. The extract.properties file is located at %tomcat_home%/OpenClinica/WEB-INF/classes/extract.properties.)

The following items are added under the “extract.10” set in the file:

extract.11.odmType=clinical_data
extract.11.file=ODMReportStylesheet.xsl
extract.11.fileDescription=Datamart
extract.11.linkText=Run Now
extract.11.helpText=Generate the Datamart
extract.11.location=$exportFilePath/$datasetName/DATAMART2
extract.11.exportname=sql_$datasetName$date.sql
extract.11.post=db1
extract.11.zip=true
extract.11.deleteOld=true
extract.11.success=Your extract job completed successfully. The file is available for download $linkURL.
extract.11.failure=The extract did not complete due to errors. Please contact your system administrator for details.

Additionally, we configure the following (based on your settings) in the “SQL Postprocessor Configurations” section of the extract.properties file.

db1.username=datamart
db1.password=datamart
db1.url=jdbc:postgresql://localhost:5432/datamart
db1.dataBase=postgres