How to eshtablish a connection with MongoDB and fetch a query result through TestComplete

Hi All, I have a scenario where I have to connect to the MongoDB database and verify the records. Has anyone tried eshtablished a connection with MongoDB and fetched the query result? ...

TanyaYatskovska
6 years ago
Hi krkarthik_info,

Have you tried using ADO to get data from the DB? ADO is a standard Microsoft engine that is available from any application. ADO calls the required database provider (e.g. the Oracle provider) depending on the connection string, and it performs all operations with the database. The provider is supplied by the database vendor, and TC just passes the control to this provider. However, please keep in mind that TestComplete can work only with the 32-bit provider (see the Working With Databases article).

krkarthik_info

Frequent Contributor

6 years ago

Hi All,

Does anybody has inputs/suggestions on how to eshtablish connection with MongoDB?

Thanks in advance.

Thanks,

Karthik K R

cunderw
Community Hero
6 years ago
Test complete does not support MongoDB out of the box. You will have to purchases a propiatery ODBC driver and setup up the connection that way.

https://docs.mongodb.com/bi-connector/master/reference/odbc-driver/
- AlexKaras
  Champion Level 3
  6 years ago
  In addition to what was said by Carson:
  
  I might remember it wrong, but I seem to read that MongoDB is essentially a local database. Which means it cannot be accessed over the network. This may be a problem if you need to access a database located, say, on mobile device.
  
  Update: Well... It looks like it is possible, but requires some setup. For example: https://ianlondon.github.io/blog/mongodb-auth/, https://medium.com/founding-ithaka/setting-up-and-connecting-to-a-remote-mongodb-database-5df754a4da89
  - TanyaYatskovska
    SmartBear Alumni (Retired)
    6 years ago
    Hi krkarthik_info,
    
    Have you tried using ADO to get data from the DB? ADO is a standard Microsoft engine that is available from any application. ADO calls the required database provider (e.g. the Oracle provider) depending on the connection string, and it performs all operations with the database. The provider is supplied by the database vendor, and TC just passes the control to this provider. However, please keep in mind that TestComplete can work only with the 32-bit provider (see the Working With Databases article).
- Kay25
  Occasional Visitor
  6 years ago
  Agreed...Having a separate ODBC driver is strongly recommended here.If u go for anything else it will just increase complications for you mypascoconnect
  - krkarthik_info
    Frequent Contributor
    6 years ago
    Thanks all for your suggestions/inputs.
    
    Even I preferred to have a seperate ODBC driver to eshtablish a connection. I expected TestComplete would support direct connection eshtablishment with MongoDB, but unfortunately it doesn't.
    
    Also ADO is not supported for MongoDB.
    
    Thanks,
    
    Karthik K R