2010/06/24

OWB11gR2 - SQL Server Connection

After installing the Oracle11gR2 , started exploring the OWB11gR2. First thing I attempted is to establish a connection SQL Server as it was one of the requirements with my current client.

The steps that I have followed for this is -

1. Downloaded the SQL Server JDBC Driver from
here.
2. Install the ( unzip) the SQL Server JDBC Driver into /owb/lib/ext folder.
3. This will create sqljdbc_2.0 under the above directory.
4. I have manually copied the sqljdbc.jar from /owb/lib/ext/sqljdbc_2.0/enu folder onto /owb/lib/ext. do not ask why I did that? OWB11gR2 started recognising the driver only after I placed the jar file straight under "ext".
5. Shutdown the OWB services by running "ccashut".
6. Start the OWB services by running "ccastart".
7. Started OWB11gR2 client.
8. Created a new SQL Server Module as shown below -
Details
=======
Get the Package
Advanced
=========

Get the Package
Tested the connection successfully! There you go!!!! Bob's your uncle!!!!

No comments:

Post a Comment

File Handling with Python

This little utility is for copying files from source to target directories.  On the way it checks whether a directory exists in the target, ...