An attempt to attache MongoDB Atlas Database source in DVServe 2.4 using web UI wizard in Pipes or Mongo DB wizard in DVStudio leads to timeout errors like the following:
Studio version: 2.4.12-SNAPSHOTServer version: 2.4.11Full technical data:com.datavirtuality.dv.gui.admin.backend.BackEndException: org.teiid.jdbc.TeiidSQLException: Message from connection template 'mongodb': Timed out after 30000 ms while waiting to connect. Client view of cluster state is {type=UNKNOWN, servers=[{address=<host name>:27017, type=UNKNOWN, state=CONNECTING, exception={com.mongodb.MongoSocketReadException: Prematurely reached end of stream}}]But it is possible to attach it with the script below:
begin/* Create connection */call SYSADMIN.createConnection(name => 'mongodb', jbossCliTemplateName => 'mongodb', connectionOrResourceAdapterProperties => 'server=<server host name>,port=27017,authSource=<auth source >,database=sample_training,login=<username>,password=<password>,readMode=primary,options="sslEnabled=true"', encryptedProperties => ''); /* Create data source */call SYSADMIN.createDatasource(name => 'mongodb', translator => 'mongodb', modelProperties => 'importer.useFullSchemaName=false', translatorProperties => '', encryptedModelProperties => '', encryptedTranslatorProperties => '');end;;
DVServer external IP addresses must be whitelisted in Atlas. If an error continues to appear, the 0.0.0.0/0 record should be tested.
