Alteryx

Alteryx has an excellent capacity to utilize multiple data sources. Also, its processing speed is pretty fast. It does not have data connectors for some other software systems, so I do not give 10.

Good integration with a wide variety of data sources, its ease of use in connecting to databases is much to be desired though.

Easy to connect to all sorts of data files and has a large range of file types supported.

has many platforms which are supported with Alteryx. Software like adobe can be linked to Alteryx and BI tools like Tableau can also have the output of the data. simple excel files in any format work great with Alteryx as there is no need to convert them into CSV or xlsx format separately.

Alteryx leverages the built in ODBC capabilities of Windows, which means that it's limited by Microsoft's limitations in Windows. Alteryx isn't cloud-native, and thus offers no hybrid cloud, private cloud, or public cloud support without significant jumping through hoops to make it work. Once you get data into it, it's easy to work with, but it's a heavy lift to get there.

Data source connectivity is really good when you are using a SQL database. Streamlining data directly through your database into the interface is very easy. Data manipulation and storing data with built-in functions makes the process efficient. Merging data files from multiple sources is very easy. Producing reports in real-time is very easy and highly functional. There are internal templates that can be used to produce high-end real-time reports.

Alteryx can connect to any data sources, can merge data together and can write back to databases.

Alteryx has Robust connectors that keep the connectivity really stable.

We have used Aleryx to extract data from an API and it always worked perfectly well. The connection was never an issue and the data was extracted within few seconds.

We have also used Aletryx to extract local files in different shape and format, also in this case we never had any issues.

Unless there's totally different kinds of datasets, it works with any flat file sheets and is very easy to play with data. If you have files in shared folders the run time depends on the size and speed of accessibility as well, but for most part it works really smooth.

As I stated previously, Alteryx is good for merging data from disparate sources and can run a large set of datasets in a quick time. Its a great tool for an analyst as it saves a lot of time spent on coding and allows functions like join,union at the click of a button. It also allows you to create additional fields in your dataset and perform computations. The only area where it lacks is the visualization perspective.

We have been integrating/connecting our SQL data source to Alteryx where we have many numbers of rows and many tables in our data source. Alteryx can easily run a query to the data source and get me part of the data for a sample workflow, and later, when we want it at a big scale it drags the data into its workflow for analysis. It is very easy for merging and blending your data in these platforms. It hardly takes a few steps.

Alteryx can connect to sources from flat files to structured databases. Alteryx has done a great job improving the native connection options such as cloud based data sources.

It connects with the Tableau source, SQL databases, and also the source scripts of Python and R. Output data is also available in multiple formats of data like Excel or CSV.

The tool is very simple and connects ANY data source for input or output. It allows you to simply compile data from multiple sources in multiple ways and ready it for further analysis and/or visualization. We primarily use this as a front-end tool for data visualization in Tableau. I describe it to users as the Excel piece and Tableau as Powerpoint - these 2 work together like peanut butter and jam.

Alteryx can connect to a wide range of data sources like Oracle, DB2, Salesforce, etc. It also has capabilities to extract data from JSON files which makes it very handy. It can also connect to spatial zip files like ESRI shape files, which adds value in the geographical and spatial data analysis as well. The standard formats like Hadoop, Hive, etc are there in the functionalities as well.

Merging data is easiest among any platform I’ve used. The data sources available is broad and I understand Alteryx is constantly adding to the sources of data used by their customers. I particularly like the ability to schedule reports out of Alteryx. This makes it valuable as tool to do research and ad hoc analysis but also reduce the time spent actually running and delivering reports pre-built

Alteryx provides good data connections to most of existing commercial or open source based data sources. Most of the cases it works well based on our experience. It may be needed to provide an enriched knowledge base or online communities to cover troubleshooting and technical solutions from Alteryx. Comparatively, Tableau has very, very strong online resources and active discussions in communities.

Have had no issues connecting to multiple data sources, both Oracle and SQL-based, but do wish that establishing new connections was a little more intuitive...

We had many different sources of data. It was difficult to integrate them. We also had difficulty in cleaning datasets and preparing for the analytics. Alteryx is very powerful in that regards. And it is very easy to use, even for a business user. Not much technical know-how is required. But it is always good to have SQL knowledge.

Alteryx can connect with broad range of data sources and has no hiccups. Connecting with PDF and PPT would be an added feature which should be prioritized

I believe Alteryx's connectivity is second to none. With full ODBC and OleDB support along with a bunch of standard connectors, I don't know of another tool that can connect to as many data sources as Alteryx. Alteryx is fantastic at joins and takes out the mystery of left/inner/right by allowing you to preview the data pre-join and post-join quickly and easily to troubleshoot any issues.

That is the best feature according to me. I could use data from a wide range of sources and it was pretty easy to merge all of them which isn't really an easy thing to do. It makes our life a lot easier when the blending capabilities are so easy to manage. Don't have to worry about having only a specific type of data source.

I love Alteryx where it can merge data from multiple data sources. The output options are amazing and we can analyze the data however we want.