MQSeries.net :: View topic - WMB 6.1-> ODBC over SSL

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » WMB 6.1-> ODBC over SSL

WMB 6.1-> ODBC over SSL

« View previous topic :: View next topic »

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

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.

WMBDEV1

Posted: Tue Aug 04, 2009 7:07 am Post subject:

Sentinel

Joined: 05 Mar 2009
Posts: 888
Location: UK

The Merant Driver says its supported....
http://sandbox.mainframe-connection.com/products/odbc/index.htm

so it should be doable.

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?

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.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » WMB 6.1-> ODBC over SSL

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP