OHDSI Home | Forums | Wiki | Github

Atlas Set Up with MySQL workbench

Developers
,
#1

Hi,

I want to know if it is possible to setup Atlas with MySQL workbench. If so then let me know how to do that.

#2

The OHDSI tools only support the following database platforms:

  • Microsoft SQL Server
  • Oracle
  • PostgresSql
  • Microsoft Parallel Data Warehouse (a.k.a. Analytics Platform System)
  • Amazon Redshift
  • Apache Impala
  • Google BigQuery
  • IBM Netezza

We looked at MySQL in the past, but found that it had too many restrictions (e.g. a temp table could only be referenced once in a query). We do not expect to add support for MySQL. I recommend you use another platform like PostgreSQL.

#3

I wonder if opinions have changed since 2018, since MySQL continues to be a popular platform, and there are options to avoid such issued (e.g. WITH clause).

#4

MySQL is still not a supported dialect. Per SqlRender package’s documentation:

  • Has functions for translating SQL from one dialect (Microsoft SQL Server) to other dialects (Oracle, PostgreSQL, Amazon RedShift, Impala, IBM Netezza, Google BigQuery, Microsoft PDW, Snowflake, Azure Synapse, Apache Spark and SQLite)
t