This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'm new to Alteryx and have recently got an Alteryx Server license and I was reading the documentation when I learned that it comes pre-packaged with MongoDB & SQLite for data storage/persistence options. However, I believe I have different needs to address when it comes to choosing a database. Below are few of my needs:
1. I have both types of data - flat (relational) as well as JSON format.
2. Need to have a Tableau native connection. Currently, Tableau does not have a native connection to MongoDB (it is via the MongoDB BI connector, but I cant use it as of now)
3. Dataset size would be about 2 billion rows currently, and growing at about 20mn rows per month.
4. Updating a particular datapoint will be very less; once the data is prepared and stored, it will be mostly querying and joining with other datasets.
5. Preferably opensource.
I shortlisted PostGreSQL after reading several forums; but I am not sure if its possible or the right one. I want to know if I can use a different database for my Alteryx Server needs (and not use MongoDB/SQLite)? Can I expect the same level of performance with other databases as I would expect with MongoDB/SQLite.
Thanks Mark - I went through good number of knowledge base articles/comment threads and MongoDB seems to be a good bet.
If you can help me with one unrelated question - that would be great:
I have Alteryx Desktop Designer v10.6; and Alteryx Server v11.0.5 - will they be compatible with each other? I cannot use Alteryx Designer 11.0 as of now since it is still not available in my firm's software respository.