Connecting Presto with Mongo 4.2

This blog would explain how to connect Presto with Mongo 4.2

Prerequisites:

1. Mongo 4.2
2. Presto 0.226

To create a connection between Presto and Mongo, follow below process:

1. We need to create a mongodb connector in Presto.
2. For that, create a catalog property file i.e. mongodb.properties in presto server

Location : etc/catalog/mongodb.properties

3. Below are the basic contents to be placed in the file

connector.name=mongodb
mongodb.seeds=host:port



4. Restart Presto server

To connect to Mongo which is SSL enabled, below changes are to be made:

1. Add another configuration property in catalog property file

mongodb.ssl.enabled=true

2. Create a separate keystore in server for SSL certificate.
3. Import SSL certificate into the keystore created using below command

keytool -import -file “/home/ec2-user/Mongo_SSL.cer” -alias Mongo_SSL -keystore /home/ec2-user/mongoStore -storepass changeit -noprompt

4. To make Presto access this keystore, we need to add mongostore location in jvm of Presto server.
5. Add below properties in jvm.config file in Presto server.

Location : etc/jvm.config
Djavax.net.ssl.trustStore=/home/ec2-user/mongoStore
Djavax.net.ssl.trustStorePassword=changeit



6. Restart Presto server.

In case if you have any queries please get us at support@helicaltech.com

Thank You
Mounika Pulimamidi
BI Developer
Helical IT Solutions Pvt Ltd

Best Open Source Business Intelligence Software Helical Insight Here

A Business Intelligence Framework

Free
Download

Best Open Source Business Intelligence Software Helical Insight is Here

A Business Intelligence Framework

Free
Download