Looking at the available connections supported by SSIS (Integration Services (SSIS) Connections), it would appear you would use the ODBC Connection Manager to connect via Teiid ODBC driver. The SSIS supported matrix doesn't list JDBC in general. As you would have to use the Oracle Connection Manager for oracle. So the only option appears to be use ODBC or create a custom Connection Manager.
Please let us know what option you used for your solution.
Yes, that's the only option, but thought of finding out on affirmative answers from someone who had already done such kind of integration.