Home » Developer & Programmer » Data Integration » Oracel 11.0.6 and Sql server 2005
Oracel 11.0.6 and Sql server 2005 [message #495648] Mon, 21 February 2011 10:06
Messages: 2
Registered: February 2011
Junior Member

We are using OWB 64bit on Windows 2003 Server 64bit R2

We have to pull data from a SQl Server database SQL SERVER 2005 64 bit on Windows 2008 R2 64 bit

WE followed the procedures given in Oracle documentation
1. creating a ODBC DSN connection
2. creating a init ora file for that connection
3. creating a listener

We tried with both HSODBC and DG4ODBC... We can connect to SQL server through OWB...the connection is successful but I cannot import the tables into OWB. It simply hangs forever. (in the init ora file we have put the HS_FDS_SUPPORT_STATISTICS=FALSE) We have to pull data from SQL server on an ongoing basis. However we found a workaround we can create a remote link to the SQL server database by creating an entry in the tnsnames. However this connection is very slow we have to pull thousands of records on daily basis. IT takes quite some time to do this. We have tried different combinations after Goodling.

Could you shed some light on this? Is it a bug in OWB 11.1 that we cannot connect to SQL Serer or are we missing something? Will it be ok if we go for 11.2?

Previous Topic: Thread: -1 Error In OWB
Next Topic: Creating Data
Goto Forum:

Current Time: Tue Sep 21 09:02:56 CDT 2021