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?
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.
Thanks, I will give up that idea then.