OHDSI Home | Forums | Wiki | Github

Unable to run Achilles on MySQL database


(Sooraj Lankala) #1

Hi,

Am trying to run Achilles R package on MySQL database CDM instance but I get below error. Could anyone confirm if Achilles SQL Render supports MySQL

Error in .jcall(“RJavaTools”, “Ljava/lang/Object;”, “invokeMethod”, cl, : **
** java.lang.RuntimeException: Don’t know how to translate from sql server to mysql. Valid target dialects are sql server

Thanks
Sooraj


(Sooraj Lankala) #2

@Ajit_Londhe @Chris_Knoll

Could you please help me with this error. Thanks


Sooraj


(Chris Knoll) #3

Hi.
Our analysis queries are written in a native dialect of SQLServer, and then are tranlated over to other dialects (oracle, redshift, sqlerrver, pdw, implala,postgresql, etc). MySql is not a supported dialect.

-Chris


(Sooraj Lankala) #4

Thanks @Chris_Knoll for the update.

Sooraj


t