Connecting to MongoDB

[ichanjasper]

Hi,

I am trying to use Teiid embedded version 8.6 to connect to MongoDB.  And I have database name, "test", and collection, "grades".

And I have created a connection factory using the following code:

    public Object getConnectionFactory() throws Exception {
        MongoDBManagedConnectionFactory mongoDBManagedConnectionFactory = new MongoDBManagedConnectionFactory();
        mongoDBManagedConnectionFactory.setRemoteServerList(remoteServerList);
        mongoDBManagedConnectionFactory.setUsername(username);
        mongoDBManagedConnectionFactory.setPassword(password);
        mongoDBManagedConnectionFactory.setDatabase("test");
        return mongoDBManagedConnectionFactory.createConnectionFactory();
    }

However, I got this exception when I try to delpoy the VDB.

Caused by: org.teiid.deployers.VirtualDatabaseException: TEIID40095 TEIID31070 Empty model;There are no tables, procedures or functions defined in this model mongoDBDS

Do I have to pass the collection to the model using import properties?  If so, what is the import property name?

Thanks,

Ivan

[rareddy]

Teiid MongoDB translator does not have any import facilities that can import MongoDB document model into Teiid relational models.  So, you have to define the schema for MongoDB model in your VDB. See MongoDB Translator

[ichanjasper]

Thanks a lot.  It works after I setup a schema.

[rareddy]

Ivan,

Great!  I am really interested in your feedback on this subject as this is one of Teiid's latest translators. Things you like, do not like, or can use improvements etc.

Can you write a blog about this once you have your usecase working?

Thank You

Ramesh..

[ichanjasper]

Sure.  It will be my pleasure to share my experience of Teiid.  I am going to test on Cassandra and OLAP next.