Connect mongodb to pentaho pdi

Hello everyone, do you happen to have a tutorial that can assist me in reading mongodb atlas data via pentaho pdi, on the internet there are only examples of local connection

Please help. I am trying to connect to mongodb atlas vlusing pentaho over the internet. I have a org VPN and the IPs are whitelisted at both ends. Have set up a load balancer at atlas with 3 sub nodes behind it. Trying to connect to the load balancer but failing.

From my understanding, pentaho needs an IP that is to be resolved to connect. Howver atlas doesn’t have a dns resolving ips
When we tried connecting using visual studio code using the domain name directly, i was able to connect to atlas database

I would like to have it too, pls