OHDSI Home | Forums | Wiki | Github

Use of RSQLite for ETL?

Implementers
#1

Hi all,
I am quite new to OMOP (I have only followed tutorials) and I also have no experience with ETL. Thus my newbie question is whether it will be possible to do ETL by use of R and RSQLite alone without installation of a separate DBMS?
Thanks.

#2

Only if you want to build a very small OMOP CDM (SQLite is only for very small databases). A very small OMOP CDM isn’t useful for anything except learning how to populate a very small OMOP CDM.

#3

Thanks, I will give up that idea then.

t