execute: Execute OHDSI Study 2

Description Usage Arguments Details Value

Description

Execute OHDSI Study 2

Usage

1
2
execute(dbms, user, password, server, port = NULL, cdmSchema, resultsSchema,
  minCellCount = 1, sourceName = "source_name", folder = getwd())

Arguments

dbms

The type of DBMS running on the server. Valid values are

  • "mysql" for MySQL

  • "oracle" for Oracle

  • "postgresql" for PostgreSQL

  • "redshift" for Amazon Redshift

  • "sql server" for Microsoft SQL Server

user

The user name used to access the server.

password

The password for that user

server

The name of the server

port

(optional) The port on the server to connect to

cdmSchema

Schema name where your patient-level data in OMOP CDM format resides

resultsSchema

Schema where you'd like the results tables to be created (requires user to have create/write access)

minCellCount

The smallest allowable cell count, 1 means all counts are allowed

sourceName

Short name that will be appeneded to results table name

folder

The name of the local folder to place results; make sure to use forward slashes (/)

Details

This function executes OHDSI Study 2 – Treatment Pathways Study Protocol 12 months. This is a study of treatment pathways in hypertension, diabetes and depression during the first 12 months after diagnosis. Detailed information and protocol are available on the OHDSI Wiki.

Value

Study results are placed in CSV format files in specified local folder.


OHDSI/OhdsiStudy2 documentation built on May 7, 2019, 8:27 p.m.