Create and deliver personalized experiences across digital properties at scale
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
Optimize data integration with high-performance connectivity
Automate decision processes with a no-code business rules engine
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
People like fast. Fast cars, fast commutes, fast Internet speeds. What about fast connections to SaaS apps? While this may not seem quite as exciting, being able to quickly connect to your data sources is critical when making business decisions. One way to establish fast connections is through the DataDirect OpenAccess solution, which makes SaaS application data and Cloud data accessible through standards-based APIs. This means that data sources can be accessed through either ODBC, JDBC, and ADO.NET drivers.
Rather than replicating data, OpenAccess exposes a real-time SQL view into the actual SaaS data. The SaaS application is not modified. This means that third-party tools can access the data as if they were accessing a relational database, such as Oracle or SQL Server. You have the ability to use all the features of these tools because the tools think they are connecting to a SQL database. Even a 10 year-old application can then connect to the newest data sources available in the Cloud.
In terms of performance, one of the objectives with this type of connectivity is to reduce how many rows have to be transferred over the Internet. These changes can reduce query times for certain queries from minutes to mere seconds since update and delete operations can be performed in batches. This leads to 30x improvements when updating 100 or more records.
The bottom-line: OpenAccess enables SaaS and Cloud applications to look like a SQL database, supporting standards-based APIs like ODBC, JDBC, and ADO.NET. To learn more check out our resource page: http://ow.ly/lKrj3.
Stay tuned next week for the third installment of this series (see part one here: http://ow.ly/lKrGV) where we’ll address yet another data access issue!
View all posts from Jeff Reser on the Progress blog. Connect with us about all things application development and deployment, data integration and digital business.
Copyright © 2017, 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.