Query Oracle DB from SQL 2005?

Question

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?

CAN SOME ONE POINT ME TO SPECIFIC SAMPLES OF HOW TO SET THIS UP AND USE SQL TO PULL DATA? — kacalapy
– kacalapy, Commented Dec 13, 2010 at 21:45

Conrad Frix · Accepted Answer · 2010-12-13 20:34:24Z

1

Linked Servers will let you do this.

SSIS can also be used to extract the data

answered Dec 13, 2010 at 20:34

Conrad Frix

52.8k13 gold badges100 silver badges158 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

bernd_k · Accepted Answer · 2010-12-13 20:38:26Z

0

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.

answered Dec 13, 2010 at 20:38

bernd_k

12.1k7 gold badges50 silver badges64 bronze badges

Collectives™ on Stack Overflow

Query Oracle DB from SQL 2005?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related