| Connecting to Sql Server [message #158639] |
Mon, 13 February 2006 13:04  |
jabs12
Messages: 5
Registered: February 2006
Location: Cleveland |
Junior Member |
|
|
Hello -
Has anyone successfully connected to Sql Server as a source with OWB 10G? I'm having some trouble, as explained in an earlier forum query, and I want to make sure that there are successes out there already.
Thanks in advance,
Joe.
|
|
|
| Re: Connecting to Sql Server [message #158725 is a reply to message #158639] |
Tue, 14 February 2006 01:50  |
 |
Maaher
Messages: 6802
Registered: December 2001 |
Senior Member |
|
|
Isn't SQL Server natively supported? If not, you could add a System DSN (ODBC data source) on the OWB machine and create a HS service. That's how we connect to Progress and Sybase here. It has its limits but seems to work.
Do it as follows:
- Create a system ODBC data link to the SQL Server
- Create an entry in the TNSNAMES.ORA
- Create an entry in the LISTENER.ORA
- Create an INITyourODBCSID.ORA in the HS directory of your Oracle Home.
Afterwards, you can create a database link in OWB.
MHE
[Updated on: Tue, 14 February 2006 01:57]
|
|
|
| Re: Connecting to Sql Server [message #421636 is a reply to message #158639] |
Wed, 09 September 2009 10:17 |
palazzi
Messages: 5
Registered: June 2009
Location: Toluca |
Junior Member |
|
|
Hi.
In fact there is a complete Oracle's guide.
Please read from page 9-6 of the Oracle Warehouse Builder User's Guide 11g release 1, "Using SQL Server as a Source".
This is for 11g.
You can download this PDF from oracle's site.
|
|
|
] 
Members
Search
Help
Register
Login
Home
