I've set up a secure connection between unixODBC driver manager / MySql ODBC driver on solaris (where we run informatica) and mySql on Windows using ssh tunnel. It works, but the problem is, that whereas getting informatica to pull data (select) from MySql is reasonably fast, uploading data (inserts) are painfully slow. In fact, inserts via the ssh tunnel are 100 times slower than 'unsecured' inserts (connecting without the tunnel). When we do download/selects we hardly see any difference between using the tunnel and not using the tunnel.
Anyone have any ideas?