5 Replies Latest reply on Apr 24, 2018 11:50 AM by Ramesh Reddy

    postgre and mongoDB Integration using JDV

    Sagarika Singh Newbie

      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