New sources: Alteryx ODBC connectors for data objects from SaaS apps

New sources: Alteryx ODBC connectors for data objects from SaaS apps

May 19, 2014 0 Comments

I am hearing more about Alteryx as a means for organizations to supplement a big data Hadoop platform with key dimensions from business applications.  With the migration of several business operations to SaaS applications, DataDirect Cloud is providing unlimited potential to Alteryx data objects for analysis.

DataDirect Cloud supports the ODBC standard that Alteryx uses for  input data to sources for instant access by data artisans.  The growing list of available connectors include those to the latest APIs for Salesforce, Eloqua Marketo, Hubspot, Force.com, Rollbase, as well as connecting ODBC over HTTPS to RDBMS systems such as SQL Server, Oracle, or DB2 that reside in a public cloud or behind a firewall.  These ODBC SaaS connectors expose data in real-time through an ANSI SQL interface, similar to SQL Server or Oracle, so you can import data in a standard way from Alteryx via tables, Visual Query Builder or SQL Editor.

Getting started with Alteryx and its new SaaS connectors from DataDirect Cloud

1. Sign up and log-in to your DataDirect Cloud account.

2. From DataDirect Cloud, select a data source.  In this case, I am selecting Eloqua since I have a production account.

3. From DataDirectCloud, configure your connection information to Eloqua.  My Eloqua admin setup an account and I received an e-mail from support@eloqua.com with the connection information.

eloqua1

4. Download the DataDirect Cloud ODBC client to the Alteryx system and configure the local ODBC data source to connect to Eloqua.

5. Launch Alteryx Designer

6. Select In/Out tab and drag “Input Data” icon to the designer pane

7. Select “Input Data” and create “New ODBC Connection”

alteryx-new-odbc-connx

8. Select the System ODBC data source we created for Eloqua using the DataDirect Cloud ODBC client available in both 32-bit and 64-bit versions.  Use your Progress ID to authenticate with DataDirect Cloud.

alteryx-new-datadirect-cloud-connx

9. Select the table object to import data, construct a query, or write a SQL statement similar to any relational data source.  It's pretty cool when you execute SQL statements against SaaS applications complete with joins, aggregation, and scalar functions.

alteryx-eloqua-objects

10. Drag a browse icon into the pane to view the data; and draw an arrow connecting them.

11. Select the “Preparation” menu and drag the “select” icon in between to inspect the data type mappings.

alteryx-data-types-eloqua

12. Click the green arrow to execute the job and output data can be stored in target ODBC databases, as well as a number of popular formats.

alteryx-output-data

13. Now that Alteryx is connected to new and exciting data sources, I will defer to the data artisans to do really cool stuff.

Get started loading unlimited data into Alteryx

Start a trial of the DataDirect Cloud Connectivity Service to load data from any ODBC source into Alteryx or call 1-800-876-3101 to speak with a systems engineer on ODBC data connectivity to SaaS, Big Data, SQL, NoSQL, and more.

Sumit Sakar

Sumit Sarkar

Technology researcher, thought leader and speaker working to enable enterprises to rapidly adopt new technologies that are adaptive, connected and cognitive. Sumit has been working in the data access infrastructure field for over 10 years servicing web/mobile developers, data engineers and data scientists. His primary areas of focus include cross platform app development, serverless architectures, and hybrid enterprise data management that supports open standards such as ODBC, JDBC, ADO.NET, GraphQL, OData/REST. He has presented dozens of technology sessions at conferences such as Dreamforce, Oracle OpenWorld, Strata Hadoop World, API World, Microstrategy World, MongoDB World, etc.

Comments
Comments are disabled in preview mode.
Topics
Latest Stories
in Your Inbox

Subscribe to get all the news, info and tutorials you need to build better business apps and sites

More From Progress
232x131_resourceimage
Getting Ahead of the Hybrid Data Curve
Read More
 
570x321__Top 7 Considerations Before Choosing a Chatbot for Your Enterprise
Top 7 Considerations Before Choosing a Chatbot for Your Enterprise
Read More
 
232-132_How to Simplify Application Usage & Deployment with Microapps
How to Simplify Application Usage & Deployment with Microapps
Read More