UniDirect & SSIS

[tjordi]

Does UniDirect support SSIS for Oracle, MySQL and PostgrSQL? Also, I'm assuming that it will work in Visual Studio 2005 much the same way that OraDirect Pro does. Is this true?

[Shalex]

UniDirect .NET doesn't support SSIS for Oracle, MySQL and PostgreSQL, but you can yourself create SSIS project using UniDirect .NET.
UniDirect .NET works in VS 2005 in the same way as OraDirect .NET Standard. If you want to get all Oracle capabilities - use OraDirect .NET, if you want to get only fundamental database server facilities or plan to create applications that work with several databases - make advantage of using UniDirect .NET.

[tjordi]

Thanks for the response, but let me rephrase my question...

Can I use UniDirect in SSIS to connect direct to Oracle, MySQL, and PostgreSQL without having to install Oracle, MySQL, or PostgreSQL native drivers? I'd like to stay away from having to install the native drivers on client machines if I can.

[Shalex]

Yes, you can. Using UniDirect .NET Professional edition you don't have to install native drivers for Oracle, MySQL, and PostgreSQL.
Please note, UniDirect .NET doesn't make special registration for SSIS. You can use and UniDirect .NET only in projects that support the other providers and require no special registration. Also UniDirect .NET doesn't support Analysis Services, Reporting Services.
All other mentioned data providers (OraDirect .NET, MyDirect .NET, PostgreSQLDirect .NET) support Analysis Services, Reporting Services and other SSIS-projects entirely.

[tjordi]

Is there any documentation for working with SSIS? I would like to be able to use OraDirect to connect as source or destination in a data flow task.

[Shalex]

The SSIS documentation can be found in MSDN. OraDirect .NET data provider doesn't make any difficulties when using this technology. If you have any questions in future please feel free to contact us.