community
cancel
Showing results for 
Search instead for 
Did you mean: 

Analytics Blog

News, events, thought leadership and more.
Alteryx
Alteryx

SlamData recently joined the Alteryx Technology Partner Program and we are excited to share the benefits that this partnership stands to provide you, our partners in the “thrill of solving.”  To deliver this information, we’ve asked Jeff Carr, CEO and Co-Founder of SlamData, to pen a guest blogpost on our newly formed partnership.  Please see below.

 

SlamData + Alteryx…in Jeff’s Words

 

SlamData REFORM + Alteryx is a solution that:

 

  • simplifies and speeds up workflows that deal with large, complex and nested data
  • prevents data silos
  • automatically keeps workflows up to date with the latest data
  • empowers Alteryx Designer users to easily fulfil their own data requests from APIs, S3, Azure Blob Storage, Data lakes, Operational databases, MongoDB and more
  • connects with your workflows via a simple tool available on the Alteryx Gallery

 

REFORM empowers Alteryx Designer users to build workflows that work with large, complex and nested data (such as JSON) within minutes. Modern data sources like Web APIs, IoT, Marketing, NoSQL and SaaS, provide large amounts of JSON data. REFORM allows data requests from these sources to be fulfilled quickly in a self-service manner. Simply connect to a data source, explore the data, and pick the exact data you need. REFORM automatically transforms the selected data into the table you want and makes it available in Alteryx Designer at hyper-speed. The latest data direct from your data source is just a workflow run away. This makes it easy to keep your workflows up-to-date.

 

REFORM is simple to learn and use and there are no limits on data size or complexity. REFORM works well with JSON objects, line delimited JSON, JSON arrays and CSV, and moreover, it makes it easy to work with directories of millions of such files at once. Users can easily curate the exact tables they need and incorporate these into existing Alteryx Designer workflows to cleanse, blend and augment with other data. For example, you can rapidly clean and join data from API endpoints, MongoDB collections and relational databases.

 

REFORM can crunch massively complex data sets in record time and improve the performance of Designer by 50X or more in many cases.

 

Get started!

 

Start with your free version REFORM Explorer and then upgrade to REFORM Desktop or the scalable REFORM Pro which connect to Alteryx Designer directly, providing access to live data from the sources listed above. REFORM Pro and REFORM Desktop connect to Alteryx Designer via the REFORM macro which is available in the Alteryx Gallery and at https://slamdata.com/alteryx. REFORM Pro is scalable, allowing your team to work with terabytes of data at once.

 

Once installed, the following is an example of how to use REFORM with Alteryx Designer:

 

clipboard_image_0.pngAdding your data source

 

clipboard_image_1.pngBrowsing your data and picking what you’re interested in

 

clipboard_image_2.pngClicking “Results”

 

clipboard_image_3.pngIn the “Reusable access link” section clicking “Generate link” then clicking “Copy link”

 

clipboard_image_4.pngClicking “In/Out” from the tool palette and dragging “REFORM” onto your workflow

 

clipboard_image_5.pngPasting the access link you copied into the “REFORM access link” field

 

clipboard_image_6.pngRunning your workflow

To produce the same results as above without REFORM, the workflow becomes complex and takes many hours to run. With REFORM Desktop, it runs in less than thirty seconds. The data used in this example is available here.

 

Below is an example of using the same dataset with the “Tabulate JSON” macro from the Alteryx Gallery. The workflow runs for 5 minutes before running out of memory on a machine with 32GB of RAM.  Just one example of how adding REFORM adds value and speed to your workflows.

 

clipboard_image_7.png

 

 

Summary

 

Using REFORM with Alteryx Designer provides access new data sources and makes it fast and easy to work with large complex data sources like API’s, JSON data stored in S3, or data from popular NoSQL databases such as MongoDB or DynamoDB. REFORM provides results much faster and makes adding data and adjusting to changes simple and fast. Alteryx Designer is the most popular data prep tool available today and REFORM makes it even better.

 

Contact us directly to learn more at contact@slamdata.com or request your 30 day trial license for REFORM here.

Raman Kaler
Sr. Manager, Alliance Marketing

Raman is responsible for alliance marketing at Alteryx, where she focuses on defining strategy and executing joint marketing programs with key strategic technolog partners. She currently focuses on alliance marketing efforts with, among others, Amazon Web Services, Microsoft, Salesforce, and Tableau. Raman has proven success in creating strategic marketing and business development programs that drive and support pipeline growth.

Raman is responsible for alliance marketing at Alteryx, where she focuses on defining strategy and executing joint marketing programs with key strategic technolog partners. She currently focuses on alliance marketing efforts with, among others, Amazon Web Services, Microsoft, Salesforce, and Tableau. Raman has proven success in creating strategic marketing and business development programs that drive and support pipeline growth.