For one of our application we need a middleware which would translate the Teradata queries to MySQL compatible format.
We got to know about the SwissSQL API java Edition 5.0 , however to test the usefulness, we did some evaluation on SwissSQL Console 5.5.
Below are the results:
1. It supported the ANSI-Standard Teradata SQLs to be converted to MySQL standard (Though, actually the SQLs were already compatible and there was no change in queries. By support I mean, there was no parsing error)
2. However, It did not support the non-ANSI Teradata extension SQLs. Some of the keywords include QUALIFY, CSUM, MSUM, MAVG, RANK etc.
Now, we are looking for some help for the 2nd observation above. Does it support non-ANSI Teradata SQL ?