| Author |
Message
|
| broker_new |
 Posted: Tue Aug 04, 2009 5:28 am Post subject: WMB 6.1-> ODBC over SSL |
 |
|
Yatiri
Joined: 30 Nov 2006
Posts: 614
Location: Washington DC
|
Hi Guys,
I have an interesting question, we happened to transfer sensitive information to database in the form of calling stored procs or directly executing the DDL's from broker. We are thinking of encrypting these calls by setting up the SSL. Is it possible or should we use JDBC for fulfilling the requirement?..
 |
|
| Back to top |
|
 |
| smdavies99 |
| Posted: Tue Aug 04, 2009 6:34 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
IMHO, the way I would do this would be to setup an encrypted VPN tunnel between the two systems.
Much easier to setup AFAIK.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| WMBDEV1 |
| Posted: Tue Aug 04, 2009 7:07 am Post subject: |
|
|
Sentinel
Joined: 05 Mar 2009
Posts: 888
Location: UK
|
|
| Back to top |
|
|
| broker_new |
| Posted: Tue Aug 04, 2009 9:16 am Post subject: |
|
|
Yatiri
Joined: 30 Nov 2006
Posts: 614
Location: Washington DC
|
Actually we happened to look at the same document and install Data Direct 64 bit drivers. In the sample odbc.ini file there are parameters to set up the SSL connectivity.
[Oracle Wire Protocol]
Driver=/opt/Connect64forODBC60/lib/ddora24.so
KeyPassword=
KeyStore=
KeyStorePassword
The next question is will the Oracle driver provided by Broker will support SSL? |
|
| Back to top |
|
|
| WMBDEV1 |
| Posted: Tue Aug 04, 2009 2:12 pm Post subject: |
|
|
Sentinel
Joined: 05 Mar 2009
Posts: 888
Location: UK
|
| broker_new wrote: |
The next question is will the Oracle driver provided by Broker will support SSL? |
As I said before, its the merant driver under the covers so I dont see why not. Why dont you try your paramaters to a datasource to find out? If you encounter issues post the error or raise a PMR for help from IBM. |
|
| Back to top |
|
|
|
|
