Hi thanks for your help.
I tested this out, however data still wont load. I get this error
The given data source kind is not supported. Data source kind: MongoDBAtlasODBC
I double checked that the gateway server has the correct drivers installed but still no joy.