Teiid - SSIS Integration

[humourmind]

Can Teiid be integrated with SSIS?

Today we are replicating data between 2 MS SQL data bases through SSIS, but there is a need to connect to one of the MS SQL source through Teiid layer, so that the replication from source MS has to go via Teiid to the target MS SQL data source using SSIS

[van.halbert]

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.

[van.halbert]

Please let us know what option you used for your solution.

Thanks.

Van

[humourmind]

Yes, that's the only option, but thought of finding out on affirmative answers from someone who had already done such kind of integration.

Thanks!