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!!!!

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, ...