Alteryx used with other software

[mokawner]

I've been studying Alteryx in school and have really enjoyed how innovative it is. I've also learned about other software like UiPath and Python and was interested in knowing of any real-world business situations that would require the use of multiple software interacting with one another. Any insight is appreciated! 

[mbarone]

Hi @mokawner !

Here's a (very simplified) common use case . . . your company has information on it's customers stored in 2 different databases.  Say an Oracle database that stores customer profile information (name, address, things like that).  A MS SQL Server database with their purchase history.

Since Alteryx can bring all the data in from both databases in one spot, you use Alteryx to bring in all your data and do various "alteryx-y" things to it (transform, formulas, etc., etc.).  Once you have your data "shaped" like you need it, you want to run an advanced deep learning algorithm on it to determine which customers are more likely to buy your next product.  And you used Python to write the algorithm.  You can connect your Python code within Alteryx and have the results of the algorithm still in Alteryx.  Now you need to "deploy" your results.  But your sales division uses Salesforce.com to get all information to the sales reps.  So you now push your algorithm results to the Salesforce.com instance (database) your company has in the cloud.

Summary:

Step 1:  Get your data from your 2 different databases and pull it into Alteryx.

Step 2:  Shape your data and run your Python created algorithm on that data in Alteryx.

Step 3:  Push your results from the algorithm out of Alteryx and into your Saleforce.com instance in the cloud.

Hope that helps!

[TheOC]

hey @mokawner 

We've sometimes had to help build bespoke python solutions for Alteryx users, whether that be for predictive analytics, web scraping, or very edge case analytics. To be perfectly honest, its a fairly rare occurrence, as Alteryx does a good job of covering 99% of data use-cases.

Where the platform potentially doesn't, we can easily bring in R, Python, or otherwise through the integrated tools, wrap them in a macro, and have them fit into a workflow like any other tool.

Hope this helps,
TheOC

[TheOC]

hey @mokawner 

We've sometimes had to help build bespoke python solutions for Alteryx users, whether that be for predictive analytics, web scraping, or very edge case analytics. To be perfectly honest, its a fairly rare occurrence, as Alteryx does a good job of covering 99% of data use-cases.

Where the platform potentially doesn't, we can easily bring in R, Python, or otherwise through the integrated tools, wrap them in a macro, and have them fit into a workflow like any other tool.

Hope this helps,
TheOC