Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

Migrating data from MongoDB to SQL

rohitkummah
5 - Atom

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

4 REPLIES 4
carlosteixeira
15 - Aurora
15 - Aurora

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

Carlos A Teixeira
rohitkummah
5 - Atom

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
15 - Aurora
15 - Aurora

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

Carlos A Teixeira
apathetichell
18 - Pollux

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?