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.
Let our experts teach you how to use Sitefinity's best-in-class features to deliver compelling digital experiences.
Learn MoreSubscribe to get all the news, info and tutorials you need to build better business apps and sites
Progress collects the Personal Information set out in our Privacy Policy and the Supplemental Privacy notice for residents of California and other US States and uses it for the purposes stated in that policy.
You can also ask us not to share your Personal Information to third parties here: Do Not Sell or Share My Info
We see that you have already chosen to receive marketing materials from us. If you wish to change this at any time you may do so by clicking here.
Thank you for your continued interest in Progress. Based on either your previous activity on our websites or our ongoing relationship, we will keep you updated on our products, solutions, services, company news and events. If you decide that you want to be removed from our mailing lists at any time, you can change your contact preferences by clicking here.