Migrating data from MongoDB to SQL

[rohitkummah]

Could anyone help me on how to migrate data from MongoDB to SQL via Alteryx

[carlosteixeira]

Hi @rohitkummah Why do you need to do this?

MongoDB is one NOSQL database-oriented to documents

SQL is a different database - relational database

Could you explain better what you wanna do?

Thanks

[rohitkummah]

Hi @carlosteixeira 

Actually I need to connect the data source to Tableau , this why client need it to convert the data from MongoDB to SQL.

[carlosteixeira]

Hi @rohitkummah 

Ok, I got it. So, you can use MongoDB input to read your MongoDB database.

You will need to get the address that your MongoDB and port, and password.

You can get it on the system settings admin.

Then you can make your necessary changes and save on the sql using one output tool directly.

Take a look on this link to see how configure it.

https://www.theinformationlab.co.uk/2019/06/19/connecting-to-your-alteryx-server-mongodb/

I hope this helps

[apathetichell]

are you outputting from Alteryx directly to SQL or to Tableau? The thing is - Alteryx basically follows SQL formatting for SQL like types. So assuming you don't have any non-SQL types in your data (Blobs/Spatial/etc) you should be able to create a table in your SQL db or output directly to Tableau. Alot of the the "SQL db" specifics are specific to what DB you are using and how you are connecting.

Is this in Server or Designer?