Unable to see EC2 hosted MongoDB database in ODBC using “Connector for BI” on Windows 10
up vote
0
down vote
favorite
I have a mongodb database on AWS EC2 and I want to connect Power BI to it via ODBC. I installed "Connector for BI" on my local windows PC and provided it DRDL file but I can't see my database in the database drop-down in ODBC while creating DSN. Followed these steps, please help. Thanks a lot.
Step1:
mongodrdl --host xx.xx.xx.xx:27017 --username xxx --password xxx --db dbname --collection collname --out xxx.drdl
Step2:
mongosqld --schema xxx.drdl
Step3:
Create DSN and connect to 127.0.0.1 on port 3307
Problem: Unable to see my database hosted on EC2.
I suspect I am not using Mongosqld with the right parameters - maybe the database access credentials are missing but when I use the --mongo-uri with the URI, I get a message "--mongo-uri may not contain any authentication information".
mongodb amazon-web-services amazon-ec2 odbc
edited Nov 11 at 10:48
halfelf
6,33693045
asked Nov 11 at 6:50
Sohail I.
11
add a comment |
up vote
0
down vote
favorite
I have a mongodb database on AWS EC2 and I want to connect Power BI to it via ODBC. I installed "Connector for BI" on my local windows PC and provided it DRDL file but I can't see my database in the database drop-down in ODBC while creating DSN. Followed these steps, please help. Thanks a lot.
Step1:
mongodrdl --host xx.xx.xx.xx:27017 --username xxx --password xxx --db dbname --collection collname --out xxx.drdl
Step2:
mongosqld --schema xxx.drdl
Step3:
Create DSN and connect to 127.0.0.1 on port 3307
Problem: Unable to see my database hosted on EC2.
I suspect I am not using Mongosqld with the right parameters - maybe the database access credentials are missing but when I use the --mongo-uri with the URI, I get a message "--mongo-uri may not contain any authentication information".
mongodb amazon-web-services amazon-ec2 odbc
edited Nov 11 at 10:48
halfelf
6,33693045
asked Nov 11 at 6:50
Sohail I.
11
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I have a mongodb database on AWS EC2 and I want to connect Power BI to it via ODBC. I installed "Connector for BI" on my local windows PC and provided it DRDL file but I can't see my database in the database drop-down in ODBC while creating DSN. Followed these steps, please help. Thanks a lot.
Step1:
mongodrdl --host xx.xx.xx.xx:27017 --username xxx --password xxx --db dbname --collection collname --out xxx.drdl
Step2:
mongosqld --schema xxx.drdl
Step3:
Create DSN and connect to 127.0.0.1 on port 3307
Problem: Unable to see my database hosted on EC2.
I suspect I am not using Mongosqld with the right parameters - maybe the database access credentials are missing but when I use the --mongo-uri with the URI, I get a message "--mongo-uri may not contain any authentication information".
mongodb amazon-web-services amazon-ec2 odbc
edited Nov 11 at 10:48
halfelf
6,33693045
asked Nov 11 at 6:50
Sohail I.
11
I have a mongodb database on AWS EC2 and I want to connect Power BI to it via ODBC. I installed "Connector for BI" on my local windows PC and provided it DRDL file but I can't see my database in the database drop-down in ODBC while creating DSN. Followed these steps, please help. Thanks a lot.
Step1:
mongodrdl --host xx.xx.xx.xx:27017 --username xxx --password xxx --db dbname --collection collname --out xxx.drdl
Step2:
mongosqld --schema xxx.drdl
Step3:
Create DSN and connect to 127.0.0.1 on port 3307
Problem: Unable to see my database hosted on EC2.
I suspect I am not using Mongosqld with the right parameters - maybe the database access credentials are missing but when I use the --mongo-uri with the URI, I get a message "--mongo-uri may not contain any authentication information".
mongodb amazon-web-services amazon-ec2 odbc
mongodb amazon-web-services amazon-ec2 odbc
edited Nov 11 at 10:48
halfelf
6,33693045
asked Nov 11 at 6:50
Sohail I.
11
edited Nov 11 at 10:48
halfelf
6,33693045
asked Nov 11 at 6:50
Sohail I.
11
edited Nov 11 at 10:48
halfelf
6,33693045
edited Nov 11 at 10:48
halfelf
6,33693045
edited Nov 11 at 10:48
halfelf
6,33693045
6,33693045
asked Nov 11 at 6:50
Sohail I.
11
asked Nov 11 at 6:50
Sohail I.
11
asked Nov 11 at 6:50
Sohail I.
11
11
add a comment |
add a comment |
active
oldest
votes
active
oldest
votes
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f53246491%2funable-to-see-ec2-hosted-mongodb-database-in-odbc-using-connector-for-bi-on-wi%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
