ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum IndexWebSphere Message Broker SupportIIB with MongoDB

Post new topicReply to topic
IIB with MongoDB View previous topic :: View next topic
Author Message
AJAYGURELLA
PostPosted: Wed Nov 25, 2015 7:12 am Post subject: IIB with MongoDB Reply with quote

Newbie

Joined: 16 Oct 2015
Posts: 7

Hi all,

Does anybody knows that whether it is possible to make connection with
MongoDB using Database nodes available in IIB.

I am able to insert data into MongoDB using external java call in IIB.
But not from other nodes.

Thanks in advance.
Back to top
View user's profile Send private message
mqjeff
PostPosted: Wed Nov 25, 2015 7:14 am Post subject: Reply with quote

Grand Master

Joined: 25 Jun 2008
Posts: 17448

The Database nodes - well, the ESQL database statements and the plain Database node itself - use ODBC.

The DatabaseRetrieve, DatabaseRoute, and Mapping nodes use JDBC.
_________________
chmod -R ugo-wx /
Back to top
View user's profile Send private message
AJAYGURELLA
PostPosted: Wed Nov 25, 2015 7:18 am Post subject: Reply with quote

Newbie

Joined: 16 Oct 2015
Posts: 7

You are correct. I have created DSN for ODBC and Configurable Service for
JDBC both are not working.

So I was wondering whether it's possible or not because Mongodb uses totally different approach of storing the data(document instead of tables).
Back to top
View user's profile Send private message
mqjeff
PostPosted: Wed Nov 25, 2015 7:22 am Post subject: Reply with quote

Grand Master

Joined: 25 Jun 2008
Posts: 17448

If your java compute node works with JDBC...
_________________
chmod -R ugo-wx /
Back to top
View user's profile Send private message
AJAYGURELLA
PostPosted: Wed Nov 25, 2015 7:30 am Post subject: Reply with quote

Newbie

Joined: 16 Oct 2015
Posts: 7

JDBC connection(using configurable service name) with JCN is not working.

also if i try to create database defination file there is no option for mongoDB.

Back to top
View user's profile Send private message
whiting
PostPosted: Tue Dec 01, 2015 6:51 am Post subject: JCN only Reply with quote

Acolyte

Joined: 26 Mar 2002
Posts: 63
Location: Greenville, SC

mongoDb will only be accessible from a JCN using mongoDb java classes. MongoDb doesn't support either ODBC or JDBC (because it's a NoSQL database).
Back to top
View user's profile Send private message Send e-mail
sleepyjamie
PostPosted: Tue Dec 01, 2015 6:21 pm Post subject: Re: JCN only Reply with quote

Centurion

Joined: 29 Apr 2015
Posts: 135

IIRC Mongo DB has a REST API. This is one option.

Probably more powerful to use a JavaCompute node.
Back to top
View user's profile Send private message
new_to_wmb8
PostPosted: Tue Dec 01, 2015 10:25 pm Post subject: Reply with quote

Centurion

Joined: 28 May 2013
Posts: 127
Location: Hyderabad, India

You have to use JCN to access the java compute node. This is the simplest way to access it. ESQL is not able to access the JDBC for mongo.
Back to top
View user's profile Send private message
mqxplorer
PostPosted: Fri Nov 03, 2017 8:55 am Post subject: Reply with quote

Master

Joined: 22 Jun 2009
Posts: 206

new_to_wmb8 wrote:
You have to use JCN to access the java compute node. This is the simplest way to access it. ESQL is not able to access the JDBC for mongo.


I am not sure, if we can use JDBC driver to connect to MongoDB. Can we use JDBC driver to connect to MongoDB?

We are using Java Driver for MongoDB and I did not try out the configurable service creation etc., ... Is there a way we can create the datasource for MongoDB in IIB?

Thanks
mqxplorer
Back to top
View user's profile Send private message
Vitor
PostPosted: Fri Nov 03, 2017 10:03 am Post subject: Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 24614
Location: Ohio, USA

mqxplorer wrote:
I am not sure, if we can use JDBC driver to connect to MongoDB. Can we use JDBC driver to connect to MongoDB?


whiting wrote:
mongoDb will only be accessible from a JCN using mongoDb java classes. MongoDb doesn't support either ODBC or JDBC (because it's a NoSQL database).



_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
mqxplorer
PostPosted: Fri Nov 03, 2017 10:42 am Post subject: Reply with quote

Master

Joined: 22 Jun 2009
Posts: 206

Vitor wrote:
mqxplorer wrote:
I am not sure, if we can use JDBC driver to connect to MongoDB. Can we use JDBC driver to connect to MongoDB?


whiting wrote:
mongoDb will only be accessible from a JCN using mongoDb java classes. MongoDb doesn't support either ODBC or JDBC (because it's a NoSQL database).




Sorry, I was lazy enough not to read through all the comments .. carried away with the first two and last comments ...

Thanks
mqxplorer
Back to top
View user's profile Send private message
mqxplorer
PostPosted: Fri Nov 03, 2017 11:04 am Post subject: Reply with quote

Master

Joined: 22 Jun 2009
Posts: 206

I developed my flow with MongoDB classes and achieved what is required in terms of functional behavior, however, I am stuck with a new requirement. While accessing MongoDB, we need to send the credentials using mongoclient(uri) string. Requirement is we need to have the encrypted credentials in a property file and at run time the credentials need to be decrypted using a specific algorithm and key. For Webspehere application server, admins set up JVM arguments with the algorithm and key so that the decrypt can happen at run time. What arguments of JVM of an EG can be used to do something similar what was done in WAS?

Thanks
mqxplorer
Back to top
View user's profile Send private message
Display posts from previous:
Post new topicReply to topic Page 1 of 1

MQSeries.net Forum IndexWebSphere Message Broker SupportIIB with MongoDB
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


Theme by Dustin Baccetti
Powered by phpBB 2001, 2002 phpBB Group

Copyright MQSeries.net. All rights reserved.