SQL List function not showing Mongo DB profile connections

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

We have a use case, where we need to connect to MongoDB host1, go to a database, and get a document based on filter criteria from a collection. Connect to the MongoDB host2 and connect to another database and go to collection and filter the data and get few key/value combinations and append to first collected document as additional key value pairs.  We would like to use the SQL List function in the TDM Portal Data Generator, but the SQL List function doesn't show any of our MongoDB connection profiles.

Approach : 

1. Create a Master JSON Template with all required keys/pair.
2. Register the template as JSON.
3. Create a generator.
4. Using filter query, get each key data, fill the values, and generate final document.

The main requirement is to fetch reference data from a MongoDB database using SQL as part of the data generator. Is this supported in TDM Portal? We would like the ability to leverage the MongoDB Connector for BI which provides ODBC and JDBC drivers to query MongoDB connections using SQL.

Environment

TDM Portal 4.10.x and 4.11.x

Cause

The MongoDB solution in TDM Portal does not support SQL queries at this time.

Resolution

There is an enhancement request (US1034647) opened to leverage the MongoDB Connector for BI, which provides ODBC and JDBC drivers, to allow SQL queries against MongoDB databases. This will be for an undetermined future release of TDM Portal.