Reputation: 10164
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 I have a SQL job to extract data into my SQL DB?
Upvotes: 1
Views: 72
Reputation: 11966
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.
Upvotes: 0
Reputation: 52675
Linked Servers will let you do this.
SSIS can also be used to extract the data
Upvotes: 1