OHDSI Home | Forums | Wiki | Github

How to connect Broadsea/Atlas to Redshift CDM database

Hello! I am trying to set up an instance of Broadsea to connect to a Redshift instance with a CDM database. I have the WebAPI sources set up the way I want them (WebAPI/source/sources looks good and I’ve verified that the connection strings look good in the webapi.source table). I am concerned that webapi is not using the correct database driver. The redshift jdbc is in my Broadsea directory ~/Broadsea/redshift-jdbc42- . Is there anything else I need to do to tell WebAPI to use this driver? Do I need to configure something in .env?

I do not have Atlas security set up so I cannot use the Atlas configure GUI to set up the CDM connection.

Thank you in advance for your help.