How to connect to DocumentDB

[gilbertendaya]

Hi,

I would like to ask for assistance on how to connect to DocumentDB.

I have here sample URL:

mongodb://sample-user;:password@Sample-cluster.node.us-east-1.docdb.amazonaws.com:27017/sample-database?readPreference=secondaryPreferred&replicaSet=rs0

How to connect using the GetData options.

Please advise.

Thank you.

[bindhuk]

I am sharing what I tried to get the documentdb data to powerbi. Configured the connection to documentdb using python and loaded one of collection as dataframe. From powerbi when you select GetData you have the option to configure python script, using that ran the python script and the dataframe was loaded to powerbi. Next you can transform data using power query as needed or I am assuming you could make the necessary changes in the python script itself and load the final dataframe.

Read the limitations of using python script:

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-python-scripts

Referred the below link for establishing connection to documentdb

https://stackoverflow.com/questions/64828294/python-ssh-tunnel-into-ec2-and-connect-to-documentdb

[amitchandak]

@gilbertendaya , refer if these can help

https://www.mongodb.com/blog/post/using-power-bi-to-gain-insight-into-your-mongodb-data
https://docs.mongodb.com/bi-connector/master/connect/powerbi/
https://docs.atlas.mongodb.com/tutorial/connect-bic-powerbi/

[gilbertendaya]

@amitchandak  thank you for the links.

Is the BI connector from the URL that you sent, free for use?

[pranit828]

Hi @gilbertendaya 

Please check the below link for steps.

https://www.progress.com/blogs/mongodb-odbc-driver-for-data-integration-with-power-bi

[gilbertendaya]

Hi @pranit828 thank you for the response.  I'm new on MongoDB.

Is this driver a freeware?

[pranit828]

HI @gilbertendaya 

It is not, You have to download it from mongodb site.

Hopefully the below link will help.

https://docs.mongodb.com/bi-connector/master/reference/odbc-driver/

[gilbertendaya]

@pranit828 sorry. What I mean was that once I downloaded it in the URL that you have provided:

1. It is free to download

2. I can use it for a long time and it will not expire?

[pranit828]

Hi @gilbertendaya 

The registered versions will ask for a key.

You may download and install as it is mentioned in the MongoDB url link.

[gilbertendaya]

@pranit828 thank you for the continuous responses.

Where can I get this key?

[pranit828]

HI @gilbertendaya 

Is it asking you for a key when you install? Hopefully not.

Or does it go smoothly?

[gilbertendaya]

@pranit828 I haven't tried it yet. I just want to make sure that this is free to use 🙂