How to connect MongoDB hosted on EC2 to Tableau
I have a EC2 instance setup, containing the manually installed mongodb free edition.
- A user has been added with
usernameandpasswordwithreadWriteaccess
Changes made to
/etc/mongod.conf
a. Added
bindIp: 0.0.0.0
b. Added
security:
authorization: 'enabled'
Currently, it's running on port: 27017
Now, I'm able to access mongodb the usual way but not through the Tableau software. I get this error message
An error occurred while communicating with MongoDB BI Connector.
The connection to the data source might have been lost.
[MySQL][ODBC 5.3(w) Driver]Lost connection to MySQL server at 'waiting for initial communication packet', system error: 10060
Unable to connect to the MongoDB BI Connector server "EC2 public IP". Check that the server is running and that you have access privileges to the requested database.
In the MongoDb BI Connector, I'm adding the following details to connect to my EC2 mongodb
Server: EC2 public IP
Port: 27017
User/pass: The one added in mongodb shell, username/password
Am I missing something? Why am I not able to connect?
My tableau is hosted on a different EC2 instance, not sure if that's the problem
mongodb amazon-web-services amazon-ec2 tableau
asked Nov 13 '18 at 11:05
Jaskaran Singh PuriJaskaran Singh Puri
302416
add a comment |
I have a EC2 instance setup, containing the manually installed mongodb free edition.
- A user has been added with
usernameandpasswordwithreadWriteaccess
Changes made to
/etc/mongod.conf
a. Added
bindIp: 0.0.0.0
b. Added
security:
authorization: 'enabled'
Currently, it's running on port: 27017
Now, I'm able to access mongodb the usual way but not through the Tableau software. I get this error message
An error occurred while communicating with MongoDB BI Connector.
The connection to the data source might have been lost.
[MySQL][ODBC 5.3(w) Driver]Lost connection to MySQL server at 'waiting for initial communication packet', system error: 10060
Unable to connect to the MongoDB BI Connector server "EC2 public IP". Check that the server is running and that you have access privileges to the requested database.
In the MongoDb BI Connector, I'm adding the following details to connect to my EC2 mongodb
Server: EC2 public IP
Port: 27017
User/pass: The one added in mongodb shell, username/password
Am I missing something? Why am I not able to connect?
My tableau is hosted on a different EC2 instance, not sure if that's the problem
mongodb amazon-web-services amazon-ec2 tableau
asked Nov 13 '18 at 11:05
Jaskaran Singh PuriJaskaran Singh Puri
302416
add a comment |
I have a EC2 instance setup, containing the manually installed mongodb free edition.
- A user has been added with
usernameandpasswordwithreadWriteaccess
Changes made to
/etc/mongod.conf
a. Added
bindIp: 0.0.0.0
b. Added
security:
authorization: 'enabled'
Currently, it's running on port: 27017
Now, I'm able to access mongodb the usual way but not through the Tableau software. I get this error message
An error occurred while communicating with MongoDB BI Connector.
The connection to the data source might have been lost.
[MySQL][ODBC 5.3(w) Driver]Lost connection to MySQL server at 'waiting for initial communication packet', system error: 10060
Unable to connect to the MongoDB BI Connector server "EC2 public IP". Check that the server is running and that you have access privileges to the requested database.
In the MongoDb BI Connector, I'm adding the following details to connect to my EC2 mongodb
Server: EC2 public IP
Port: 27017
User/pass: The one added in mongodb shell, username/password
Am I missing something? Why am I not able to connect?
My tableau is hosted on a different EC2 instance, not sure if that's the problem
mongodb amazon-web-services amazon-ec2 tableau
asked Nov 13 '18 at 11:05
Jaskaran Singh PuriJaskaran Singh Puri
302416
I have a EC2 instance setup, containing the manually installed mongodb free edition.
- A user has been added with
usernameandpasswordwithreadWriteaccess
Changes made to
/etc/mongod.conf
a. Added
bindIp: 0.0.0.0
b. Added
security:
authorization: 'enabled'
Currently, it's running on port: 27017
Now, I'm able to access mongodb the usual way but not through the Tableau software. I get this error message
An error occurred while communicating with MongoDB BI Connector.
The connection to the data source might have been lost.
[MySQL][ODBC 5.3(w) Driver]Lost connection to MySQL server at 'waiting for initial communication packet', system error: 10060
Unable to connect to the MongoDB BI Connector server "EC2 public IP". Check that the server is running and that you have access privileges to the requested database.
In the MongoDb BI Connector, I'm adding the following details to connect to my EC2 mongodb
Server: EC2 public IP
Port: 27017
User/pass: The one added in mongodb shell, username/password
Am I missing something? Why am I not able to connect?
My tableau is hosted on a different EC2 instance, not sure if that's the problem
mongodb amazon-web-services amazon-ec2 tableau
mongodb amazon-web-services amazon-ec2 tableau
asked Nov 13 '18 at 11:05
Jaskaran Singh PuriJaskaran Singh Puri
302416
asked Nov 13 '18 at 11:05
Jaskaran Singh PuriJaskaran Singh Puri
302416
asked Nov 13 '18 at 11:05
Jaskaran Singh PuriJaskaran Singh Puri
302416
asked Nov 13 '18 at 11:05
Jaskaran Singh PuriJaskaran Singh Puri
302416
asked Nov 13 '18 at 11:05
Jaskaran Singh PuriJaskaran Singh Puri
302416
302416
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53279645%2fhow-to-connect-mongodb-hosted-on-ec2-to-tableau%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53279645%2fhow-to-connect-mongodb-hosted-on-ec2-to-tableau%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
