Query Oracle DB from SQL 2005?

I have some ODBC connection information for an Oracle database, and I wanted to know if it is possible to query this database from SQL Server 2005?

Also, can开发者_JAVA百科 I have a SQL job to extract data into my SQL DB?

---

Linked Servers will let you do this.

SSIS can also be used to extract the data

---

I think you have enough information to set up a linked server. My practical experience showed some limitations, when it came to querying CLOB columns, but that seems to be a basic limitation of other tools based on OLEDB too. For special cases I use PowerShell scripts to extract data, which I do not get with the usual tools.