postgre and mongoDB Integration using JDV

[sagarika1in]

Hi All,

I am trying to integrate Postgresql table with MongoDB collection through JDV 6.3 but while previewing the data I am getting following error:

java.lang.RuntimeException: Remote org.teiid.core.TeiidProcessingException: TEIID31099 VDB PREVIEW-4741242c-2c49-441a-815b-84db075c0d64.1[cst_mongo{}, cstintg{}, postgresql_intg{postgresql_intg=postgresql_intg, postgresql, java:/postgresql_intg}, mongo_mdl{mongo_mdl=mongo_mdl, mongodb, java:/mongo_twitter}] is not active, but FAILED.  If loading you can resubmit your query after loading has completed or after the errors have been corrected.

Please find the screenshot,model and VDB as attached herewith. Could you kindly advise how to preview integrated data of PostgreSQL and MongoDB through a single view.

Regards,

Sagarika Singh

[rareddy]

Sagarika,

You need to take look at the "server.log" file in the JDV server in "standalone/logs" directory to see why the deployment is failing, that should give a better clue.

Ramesh..

[sagarika1in]

Dear Ramesh,

Thanks a lot for all your guidance so far.

Please find the document with detailed steps for creating integrated view

for PostgreSQL and MongoDB. Kindly let me know if the steps are correct or

not.

I understand we need to have an active VDB for MongoDB to preview the

data. So wanted to understand how can we create integrated VDB file for

multiple databases.

Please find the log files for reference.

Regards

Sagarika Singh

Tata Consultancy Services

Mailto: [e-mail]

Website: http://www.tcs.com

[rareddy]

From the logs I see

Caused by: javax.resource.spi.InvalidPropertyException: No database name specified for mongodb connection

So, when you defined the connection details for the Mongo, you did not specify the "database" property for the Mongo, thus they fail to activate error. So, questions is

1) How did you create the connection? Using the Designer or editing the Standalone.xml file?

either case, you can edit the standalone.xml file in the JDV installation in "JDV/standalone/configuration" directory, and find "resource-adapters" subsystem, in there you will find your incomplete definition of the Mongo connection, edit to correct then once done save and restart the server. Then connect back from Designer and retest. A sample Mongo connection definition file can be found in "JDV/docs/teiid/datasources/mongodb/mongodb.xml" file.

Ramesh..

[sagarika1in]

Hi Ramesh,

I have created the model using teiid desginer and reusing the same model

for view creation.

I can see the data through OData connectivity for the model.I am creating

the model though teiid desginer only using MongoDb translator.

Regards

Sagarika Singh

Tata Consultancy Services

Mailto: [e-mail]

Website: http://www.tcs.com

[rareddy]

Ok, as long as you do the edits I suggested above you should be able to go past the error you are seeing.