Connecting to a Microsoft SQL Server Database from Windows
Connecting to a Microsoft SQL Server Database from Windows
On Informatica 10.0, you can connect to Microsoft SQL Server database through the ODBC provider type by default.
You can also connect to Microsoft SQL Server database using the OLEDB provider type, but the OLEDB provider type is deprecated. Support for the OLEDB provider type will be dropped in a future release.