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
Progress DataDirect for Amazon Redshift and the OData service of DataDirect Cloud enable rapid BI and analytics with Microsoft PowerBI.
Power BI is Microsoft’s cloud-hosted, self-service business intelligence (BI) solution. Like Tableau, which I’ve talked about a lot in the past, Power BI gives business users and analysts the ability to visualize their data in order to gain deep insight into their customers, operations and processes.
One of the great things about Power BI is the wealth of data sources and connectivity options it supports, including ODBC and OData. No matter what method you choose, Progress has a high-performance solution for you.
In the past, we’ve touted our Progress DataDirect Amazon Redshift ODBC driver for its blazing fast performance when loading data into Redshift, but it’s just as powerful when pulling data out. So, to follow up Dennis Bennett’s awesome demo and recap of Sumit Sarkar’s “Million Row Challenge,” I thought I’d show off some of the capabilities of our Redshift driver when the data is flowing in the opposite direction. Check out this short video I put together demonstrating DataDirect connectivity to Redshift from Power BI.
OData is a standardized protocol for creating and consuming data APIs. In other words, it’s a standard for providing access to data over the Internet in real-time.
OData builds on core protocols like HTTP/s and commonly accepted methodologies like REST, and allows mobile and web applications to query data sources much more easily than force fitting SQL to them.
Progress® DataDirect Cloud® accepts OData query requests, translates them to SQL, and forwards that SQL to your data source to be executed. Applications can then invoke the OData service and consume this OData using any of the common clients that provide HTTP or web service access.
Though the most common use case we’ve seen for this service so far has been providing access to external data through Salesforce Lightning Connect, it is also useful for connecting to Power BI for real-time analytics. In the following video, I demonstrate this connectivity from Power BI to Amazon Redshift through our DataDirect Cloud service.
Whether you are loading data into or pulling data out, DataDirect offers connectivity to Amazon Redshift that blows the competition away. Grab a free trial of our Amazon Redshift ODBC driver or sign up to evaluate DataDirect Cloud and start getting the most out of your Redshift data today.
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.