We are thinking about replication to Teradata database using SAP Replication Server.
We want to check replication as:
ASE -> RS -> ECDA for ODBC -> Teradata ODBC -> Teradata Server
I am afraid of performance issues of such solution and if SQL syntax will readable for teradata odbc.
Maybe there will be need of using RS function strings.
Is there anyone that has experience in such replication?
Or maybe I should think about:
ASE -> RS -> ASE (staging database) -> Flat File -> Teradata
My knowledge about Teradata is very poor.
Thanks for any help