Home Services Partners Company
OpenAccess 7.2 - Things Just Got Better

OpenAccess 7.2 - Things Just Got Better

October 18, 2013 0 Comments

If you subscribe to the DataDirect blog, you have probably already seen Sumit Sarkar’s April blog post about how to use OpenAccess to get real-time access for Cognos to custom data. Or maybe you’ve seen Paul Griffin’s March blog post on how OpenAccess saves lives. Yes, OpenAccess has been helping users connect to custom data sources for quite some time already, but with the new release things are now better than ever!

Why do companies such as Netsuite, HP, ANZ or UZ Leuven rely on OpenAccess?

With 99% of the code provided, the developer only needs to implement 12 functions, which means the typical implementation last under 90 days. OpenAccess is scalable to support big data sets, and it enables security features such as Kerberos, SSL or IP Blocking. You also have the freedom of developing in C/C++, Java or .NET.

DataDirect

What’s new in 7.2?

Everyone is talking about big data. The latest release of OpenAccess supports even larger data sets via bulk load and disk based nester query processing. This speeds things up significantly.

Our developers also focused on precise number crunching, which means supporting DECIMAL datatypes, 127 digit NUMERIC precision, and Standard Deviation and Variance Functions.

While the main advantage of OpenAccess is easy SQL access to custom data sources, it now also supports:

  • Expressions in INSERT values
  • Table functions in FROM
  • TOP and ORDER BY in Sub Queries
  • CASE expression in GROUP BY, HAVING, ORDER BY

And the best part? OpenAccess can connect you to DataDirect Cloud so you can get access to Cloud data sources as well.

Intrigued? You can try OpenAccess here or visit the product page.

Any questions? Contact us here or on Twitter @DataDirect_News. We are always happy to help you.

Zlata Palkovicova

View all posts from Zlata Palkovicova on the Progress blog. Connect with us about all things application development and deployment, data integration and digital business.

Read next SAS ODBC Access to Salesforce, SQL Server and Marketo
Comments
Comments are disabled in preview mode.