SMP 3.0 with Mongo DB

[rakshit_doshi]

Dear All,

Is it possible to connect SAP Integration gateway to mongo db. I know mongo db is a no sql server but is there a way to connect using custom script and referencing and connecting to mongo db and reading the data.

Thanks,

Rakshit Doshi

[midhun_vp]

Hi Rakshit,

If mongoDB can give data in any of these format you can use integration gateway: SOAP, REST, JPA,JDBC,ODC.

It doesn't matter what is the type of backend or how the data is stored in the backend.

Regards, Midhun

SAP Technology RIG

[rakshit_doshi]

Dear Midhun,

Can we include third party connectors within SMP for database as well?

[nageshcaparthy]

Hi Rakshit,

SMP does not allow any 3rd party connectors, we use Integration Gateway to consume data.

As said by Midhun, if you are looking to consume data from any 3rd party data source, it should be in the SOAP, REST, JPA,JDBC,ODC.

Regards,

Nagesh

[rakshit_doshi]

Dear Nagesh,

There are jdbc drivers available for connecting to MongoDB and on creating the destination i am able to test connection to mongodb server successfully. When i deployed it to Gateway Server and try to utilize the service, i am not able to and its giving an error unable to find table reference with the entity set.

MongoDB is a non sql database, so there are no tables within it, its based on documents.

So i dont know if SMP (Integration Gateway) can support non sql database.

Any insights??

Thanks,

[Jitendra_Kansal]

I am not much sure on this.