OHDSI Home | Forums | Wiki | Github

Does Achilles work with Netezza?

Developers
#1

Hello,

I have seen and heard some comments that Achilles is supposed to work with Netezza, however I get an error when I try to do so:

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

Is the error above due to “user error” or something else? Does Achilles support Netezza yet or is that functionality something that will be available in the future?

#2

Maybe you put the target dialect as ‘NetezzaSQL’? The proper dialect value for netezza is: ‘netezza’ (no quotes).

#3

It works! I don’t know why you have the error though

#4

Thanks, it turns out it may be case sensitive. I tried Netezza, NetezzaSQL, Netezza SQL, but not "netezza’. Oops!

#5

Yes, I had the dialect wrong… I had tried ‘Netezza’ in an earlier attempt, which also failed. I would guess it’s case sensitive. :slight_smile:

t