Comments (1)
CDM R package OMOP CDM v5.4
This package can be downloaded from https://github.com/OHDSI/CommonDataModel/. It functions to dynamically create the OMOP CDM documentation and DDL scripts to instantiate the CDM tables.
Dependencies and prerequisites
This process required R-Studio to be installed as well as DatabaseConnector and SqlRender.
DatabaseConnector - This R package provides function for connecting to various DBMSs. Together with the SqlRender package, the main goal of DatabaseConnector is to provide a uniform interface across database platforms: the same code should run and produce equivalent results, regardless of the database back end.
Features
Create connections to the various database platforms:
MicrosoftSQL Server
Oracle
PostgresSql
Microsoft Parallel Data Warehouse (a.k.a. Analytics Platform System)
Amazon Redshift
Apache Impala
Google BigQuery
IBM Netezza
SQLite
Spark
Statements for executing queries with
Error reporting to file
Progress reporting
Multiple statements per query
Support for fetching data to Andromeda objects
Insert data frame to a database table
Supports the DBI interface, with SQL statements automatically translated to the appropriate dialect.
Supports the dbplyr interface.
Integrates with RStudio's Connections tab
Instead of providing the server name, it is also possible to provide the JDBC connection string if this is more convenient:
conn <- connect(dbms = "postgresql",
connectionString = "jdbc:postgresql://localhost:5432/postgres",
user = "joe",
password = "secret")
-
user = "ohdsi_app_user",
-
password = "??????")
issue / resolution
https://forums.ohdsi.org/t/problem-connecting-to-postgres-database-using-database-connector/604
Using Windows Authentication for SQL Server
In some organizations using Microsoft SQL Server and Windows, it is possible to use Windows Authentication to connect to the server, meaning you won’t have to provide a user name and password, since your Windows credentials will be used. This will require downloading the SQL Server authentication DLL file, and placing it somewhere on your system path. If you don’t have rights to add files to a place on your system path, you can place it anywhere, and set the PATH_TO_AUTH_DLL environmental variable, either using the Sys.setenv(), or by adding it to your .Renviron file. See this webpage or type ?connect for details on where to get the DLL (and what specific version).
SqlRender - This is an R package for rendering parameterized SQL, and translating it to different SQL dialects. SqlRender can also be used as a stand-alone Java library and a command-line executable.
https://github.com/OHDSI/CommonDataModel/
Create DDL, Foreign Keys, Primary Keys, and Indexes from R
First, install the package from GitHub
Typically, new CDM versions and updates are decided by the CDM working group (details to join meetings on homepage). These changes are tracked as issues in the github repo. Once the working group decides which changes make up a version, all the corresponding issues should be tagged with a version number, e.g. v5.4, and added to a project board.
Read from Step 0 onwards at https://github.com/OHDSI/CommonDataModel/?tab=readme-ov-file#step-0
Connecting to a SQLite database
DatabaseConnector also supports SQLite through the RSQLite package, mainly for testing and demonstration purposes. Provide the path to the SQLite file as the server argument when connecting. If no file exists it will be created:
from kids23-team3.
Related Issues (20)
- OHDSI Tool - Data Quality Dashboard
- OHDSI Tool - ATLAS HOT 2
- OHDSI Tool - USAGI
- OHDSI tools - WHITERABBIT and RABBIT-IN-A-HAT
- OHDSI Tool - ATHENA
- OHDSI Tool - HADES (optional) HOT 1
- References - Standardized Data: The OMOP Common Data Model
- Eunomia - Sample data for testing OMOP CDM
- Install HADES (OHDSI Methods Library)
- OMOP CDM v5.4 Specs OVERVIEW
- SqlRender HOT 1
- DatabaseConnector - PostgreSQL JDBC Driver
- devtools::install_github("OHDSI/CommonDataModel")
- VOCAB from ATHENA into OMOP CDM PostgreSQL
- Generate Sickle Cell Disease Patients from Synthea HOT 1
- Identify Synthetic public-use data HOT 1
- Infrastructure set up - PostgreSQL, OHDSI Tools on Azure VM HOT 2
- Import OHDSI Standardized Vocabularies HOT 1
- OHDSI Tools - ACHILLES HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from kids23-team3.