OHDSI Home | Forums | Wiki | Github

Atlas (WebAPI) using BigQuery

(Javier Gracia-Tabuenca) #1

Is it possible to use Atlas (or actually WebAPI) with BigQuery ??

(I think that the CDM can be in BigQuery and the R scripts also can comunicate with it, but WebAPI is on java, not sure if it is possible)

(Gregory Klebanov) #2

dear @Javier - yes, it is possible. ATLAS now supports BigQuery as one of the databases. Not sure I understand your comment about Java - could you please clarify?

(Javier Gracia-Tabuenca) #3

Thanks gregk, never mind about the java question,

Ok, i checked better the documentation and found this

" Note: WebAPI’s database can only be installed using PostgreSQL, SQL Server or Oracle. The CDM database may exist on different database infrastructure (i.e. RedShift, SQL Server PDW, Google BigQuery, Impala, etc) " [source]

So WebAPI must work on PostgreSQL ?? or now can work also in BigQuery ??

(Gregory Klebanov) #4

Ah, i understand your question.

For ATLAS internal database - PostgreS, SQL Server or Oracle only. I would recommend sticking with PostgreS

(Javier Gracia-Tabuenca) #5

Yeap, thanks a lot, all clear now
sorry for the confision