Attaching MongoDB Atlas Database in DVServer 2.4

Userlevel 5
  • Community Manager
  • 21 replies

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 record should be tested.

0 replies

Be the first to reply!