Comprehensive solution for crafting and managing sophisticated digital experiences
Build engaging websites with intuitive web content management
Leverage a complete UI toolbox for web, mobile and desktop development
Build, protect and deploy apps across any platform and mobile device
Build mobile apps for iOS, Android and Windows Phone
Rapidly develop, manage and deploy business apps, delivered as SaaS in the cloud
Automate UI, load and performance testing for web, desktop and mobile
Host, deploy and scale Node.js, Java and .NET Core apps on premise or in the cloud
Optimize data integration with high-performance connectivity
Automate decision processes with a no-code business rules engine
Transform your businesses in order to survive in a completely digitized and connected world driven by software innovation.
Globally scale websites with innovative content management and infrastructure approaches
Content-focused web and mobile solution for empowering marketers
Faster, tailored mobile experiences for any device and data source
UX and app modernization to powerfully navigate today's digital landscape
Fuel agility with ever-ready applications, built in the cloud
Idaliz Baez demonstrates how to use the Progress DataDirect driver for SparkSQL for real-time analytics and BI with SparkSQL.
Back in May, I hosted a webinar focused on driving real-time analytics with SparkSQL and our new Progress® DataDirect® for SparkSQL driver. As a part of my presentation, I demonstrated just how easily our SparkSQL driver can execute complicated queries for fast BI analytics.
The demo went over really well, but if you’re anything like me, I know you won’t be satisfied just watching it—you'll want to get your hands dirty. I figured our readers might like to take a crack at recreating the demo themselves, so this week, I am detailing the steps I took so you can follow along.
The first step is to watch and follow Gordon Crenshaw’s video on setting up your Hortonworks Hadoop environment. This video will guide you through how to download, install, create a database and upload data.
The Star Wars survey data I used in my demo can be found at github for you to use, but you could run this demo with just about any data you may have laying around.
Next, you’ll need to get Spark and SparkSQL up and running on the Hortonworks Hadoop environment you set up in the previous step. The following video will guide you through the process:
You can now choose to watch the ODBC or JDBC installation and configuration video depending on which kind of connector you want to use to access your data.
I used the Progress® DataDirect® ODBC driver in order to connect to Tableau, but you can feel free to use a JDBC connector or a different BI tool if that is what you prefer. At the end of both of these videos, Gordon will lead you through how to establish a connection to SparkSQL.
Finally, all you have to do is point your BI tool to the SparkSQL data source you configured in the previous steps. For Tableau, this is as simple as: opening the application, choosing “Other Databases (ODBC)” from the menu on the left side of the screen and selecting the DSN you created in the earlier steps. Then just click “connect” and log in!
Select the DSN you configured in previous steps.
At this point, you shouldn’t have any questions about how to access your Big Data sources for BI and analytics. If you still do, though, don’t worry! You can always reach out to us or leave a comment below and we will do everything we can to help!
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.
Copyright © 2016, Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.
Progress, Telerik, 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 or appropriate markings.