Quickly Build a Custom Driver for Any Data Source or API with OpenAccess SDK
Develop
Build standards-based connectivity (ODBC, JDBC, ADO.NET) for underlying data that is compatible with the most popular analytical and data integration tools.
Compliance
Ability to ensure privacy and security compliance by intercepting and inspecting SQL statements, as well as altering database result set content to include 3rd party encrypting and decrypting.
Accelerate
OpenAccess SDK is a tool developers can use to handle 99% of the code required to produce a standards-based driver with SQL support.
OpenAccess Use Cases
Open Up Some Data Without Needlessly Exposing All of It
Personally identifiable information that shouldn’t be seen by all users can be hidden or exposed only on a need-to-know basis per user with row-level and column-level security. This creates safeguards around the data, helping enterprises stay compliant with privacy and security regulations.
Elevate the Security of Existing JDBC and ODBC Drivers
Quickly build a wrapper around any ODBC or JDBC connection to enhance security. This allows for custom authentication and the interception and inspection of SQL statements. Additionally, you can alter the database result set content to support privacy and security compliance, hiding or exposing personally identifiable information on a need-to-know, per-user basis.
ODBC, JDBC, OLE DB Access to SCADA and Data Historian Systems
If ODBC or JDBC connectivity is needed where none is available, OpenAccess SDK can easily bridge the technology gap between the analytics and data integration tools and the available connectivity solution, even when the backend datastore has full SQL, partial SQL or no SQL support.
Access Object-Oriented Data from ODBC, OLE DB or JDBC
As a low-code and easy to implement solution, OpenAccess SDK helps enterprises reach the goals of their business without needing to specialize in data connectivity. DataDirect can provide the tools needed for the SDK as well as offer award-winning support.
Open Up Some Data Without Needlessly Exposing All of It
Personally identifiable information that shouldn’t be seen by all users can be hidden or exposed only on a need-to-know basis per user with row-level and column-level security. This creates safeguards around the data, helping enterprises stay compliant with privacy and security regulations.
Elevate the Security of Existing JDBC and ODBC Drivers
Quickly build a wrapper around any ODBC or JDBC connection to enhance security. This allows for custom authentication and the interception and inspection of SQL statements. Additionally, you can alter the database result set content to support privacy and security compliance, hiding or exposing personally identifiable information on a need-to-know, per-user basis.
ODBC, JDBC, OLE DB Access to SCADA and Data Historian Systems
If ODBC or JDBC connectivity is needed where none is available, OpenAccess SDK can easily bridge the technology gap between the analytics and data integration tools and the available connectivity solution, even when the backend datastore has full SQL, partial SQL or no SQL support.
Access Object-Oriented Data from ODBC OLE DB OR JDBC
As a low-code and easy to implement solution, OpenAccess SDK helps enterprises reach the goals of their business without needing to specialize in data connectivity. DataDirect can provide the tools needed for the SDK as well as offer award-winning support.
The Progress DataDirect Dedication to Security:
Progress DataDirect has defined a stringent set of policies and practices around product development and distribution. This ensures there is transparency with regard to third party dependencies, proactive policies, and practices to meet the highest security standards when releasing products. In addition, Progress DataDirect is dedicated to finding a timely and effective resolution to any serious security concerns that arise.
Features
OpenAccess SDK lets you quickly create a standards based, ASNI-SQL compliant ODBC, JDBC or ADO.NET driver for your unique requirements without the domain expertise and heavy lift of full code development.
Rapid
Quickly generate a custom driver using our prebuilt addons or develop directly against SDK interfaces
Ease of Use
Provides the fastest way to make your application compatible with data-centric tools, such as BI and analytics, ETL and more
Single Interface
Enables implementation of a single interface for data access from all standards-based APIs
Broad Coverage
Broadens data connection and application platform options while expanding developer knowledge
Enterprise-class Performance
Improve efficiency and speed with optimized query execution completed by an OpenAccess SQL Engine
Extensive SQL Support
Optimizes CRUD operations with the OpenAccess SQL engine to reduce coding and improve usability
Data Security
Keep the data secure during transit with latest security protocols like TLS v1.3, also use the SDK to support data encryption at rest by integrating with custom data encryption and business rules providers
Testimonials
We have used the OpenAccess SDK for many years, to provide SQL access to a proprietary database. Before that, we tried — and failed — to provide similar functionality using a homebrew solution. It was too expensive and didn’t support our customers’ requirements, so we were very happy to find a third-party solution like Progress DataDirect.
— Architect Professional, Global 500 Electronics Company
I have worked with the OpenAccess SDK for almost 20 years. The product delivers exactly what is promised, and the support is excellent.
— Architect Professional, Global 500 Electronics Company
Learning & Support
Blogs
Dennis Bennett
James Goodfellow
Success Stories
Tutorials
Webinars
