Install R

• Install dependency pacakges that are required by R

sudo apt install dirmngr apt-transport-https ca-certificates software-properties-common libssl-dev libxml2-dev -y

• fetch and import the GPG key and store it in cran.gpg (apt will use it for verifying the authenticity)

gpg --keyserver keyserver.ubuntu.com --recv-key '95C0FAF38DB3CCAD0C080A7BDC78B2DDEABC47B7'
gpg --armor --export '95C0FAF38DB3CCAD0C080A7BDC78B2DDEABC47B7' | gpg --dearmor | sudo tee /usr/share/keyrings/cran.gpg > /dev/null

• import the CRAN repository

echo "deb [signed-by=/usr/share/keyrings/cran.gpg] https://cloud.r-project.org/bin/linux/debian bookworm-cran40/" | sudo tee /etc/apt/sources.list.d/cran.list

• refresh the apt repository

sudo apt update

• Install R

sudo apt install r-base r-base-dev

• Install Java

export JAVA_HOME=/usr/lib/jvm/openjdk
export PATH="$JAVA_HOME/bin::/root/.cargo/bin:$PATH"
export LD_LIBRARY_PATH=/usr/lib/jvm/openjdk-11/lib/server

JAVA_HOME_11=/usr/lib/jvm/openjdk
arch="$(dpkg --print-architecture)"; case "$arch" in 'amd64') downloadUrl='https://github.com/AdoptOpenJDK/openjdk11-upstream-binaries/releases/download/jdk-11.0.16%2B8/OpenJDK11U-jdk_x64_linux_11.0.16_8.tar.gz'; ;; 'arm64') downloadUrl='https://github.com/AdoptOpenJDK/openjdk11-upstream-binaries/releases/download/jdk-11.0.16%2B8/OpenJDK11U-jdk_aarch64_linux_11.0.16_8.tar.gz'; ;; *) echo >&2 "error: unsupported architecture: '$arch'"; exit 1 ;; esac; wget --progress=dot:giga -O openjdk.tgz "$downloadUrl"; 
sudo mkdir -p ${JAVA_HOME_11} 
sudo tar --extract --file openjdk.tgz --directory "$JAVA_HOME_11" --strip-components 1 --no-same-owner ;

sudo update-alternatives --install /usr/bin/java java ${JAVA_HOME_11}/bin/java 100

sudo R CMD javareconf

java -version

sudo apt install r-cran-rjava

• Other dependencies of DQD

sudo Rscript -e 'install.packages(c("remotes", "shiny", "rJava"))'

• Installing DataQuality Dashboard

remotes::install_github("OHDSI/SqlRender")
remotes::install_github("OHDSI/ParallelLogger")
remotes::install_github("OHDSI/DatabaseConnector")
remotes::install_github("OHDSI/DataQualityDashboard")

Show Results on Shiny App

Rscript -e 'DataQualityDashboard::viewDqDashboard(file.path(getwd(), "./output/pasar-20241106094026.json"))'

Run the script

cd scripts && Rscript dqd.sql.R