Looking to easily integrate all your cloud data sources into Alteryx? Learn how in this simple tutorial using Progress DataDirect.
Alteryx allows organizations to easily prepare, blend, and analyze data. In order to make the most out of this application’s capabilities you will want to be able to connect Alteryx to all of your SaaS applications.
DataDirect Cloud provides the perfect tool for Alteryx data objects for analysis. It supports the ODBC standard used by Alteryx to input data sources for instant access by data artisans. The user can expose data in real time through an ANSO SQL interface, similar to that of SQL Server or Oracle, due to the growing list of ODBC SaaS connectors—including APIs for Salesforce, Eloqua, Marketo, Hubspot, Force.com and Rollbase. They can then import data in a standard way from Alteryx via tables, Visual Query Builder, or SQL Editor.
Update: Note that this is an update to Sumit's original tutorial. Some users had run into an error which we address in step 8 (they had used their DataDirect Cloud user name in the ODBC DSN and gotten an error in Alteryx because they didn't leave the user name blank when connecting).
Try a free trial of DataDirect Cloud and load data from any ODBC source into Alteryx. Contact sales to speak to one of our systems engineers about ODBC data connectivity to SaaS, big data SQL, NoSQL and more.
Idaliz is a Sales Engineer with Progress. After receiving her undergraduate degree from Duke University in Civil and Environmental Engineering, Idaliz Baez spent a year at NASA Goddard Space Flight Center gaining on-the-job experience before returning to Duke in pursuit of her Masters of Engineering Management degree.
Subscribe to get all the news, info and tutorials you need to build better business apps and sites
Copyright © 2019 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.
Progress, Telerik, Ipswitch, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.