Build standards-based connectivity (ODBC, JDBC, ADO.NET) for underlying data that is compatible with the most popular analytical and data integration tools.
Personally identifiable information that shouldn’t be seen by all users can be hidden or exposed only on a need-to-know basis.
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 SDK
Quickly generate a custom driver using our prebuilt addons or develop directly against SDK interfaces
Provides the fastest way to make your application compatible with data-centric tools, such as BI and analytics, ETL and more
Enables implementation of a single interface for data access from all standards-based APIs
Broadens data connection and application platform options while expanding developer knowledge
Improve efficiency and speed with optimized query execution completed by an OpenAccess SQL Engine
Optimizes CRUD operations with the OpenAccess SQL engine to reduce coding and improve usability
Need to access RESTful data when your database or BI platform can’t speak the language? Progress DataDirect makes it easy to translate your business-critical data.
How can you integrate your internal API layer into various BI tools? We answer this and show how to enable SQL access to enterprise APIs in our latest webinar.
Video
Watch this quick demo video to learn how to connect from Tableau with SQL ODBC access to your REST APIs and security policies.
Success Story
NetSuite needed application data connectivity demanded by existing customers and by the market at large. To solve this problem they leveraged the OpenAccess™ SDK for data connectivity supporting an extensive breadth of standards and implementations.
The Resource Network, which helps organizations develop business initiatives, needed to tie together diverse data from multiple on-premise or cloud-based applications. Leveraging DataDirect OpenAccess for Salesforce, any ODBC-compliant application was enabled to access data sources at Salesforce.com in real time using SQL as the language.
Webinar
Register for this webinar to hear why Sotero chose DataDirect OpenAccess SDK and the benefits they've been able to provide their customers.
Companies typically build numerous internal applications and complex APIs for enterprise data access. These APIs are often engineered for application developers and based on protocols such as REST or SOAP with payloads in XML or JSON.
However, enterprise data teams need to access this data for analytics, which requires standard query capabilities and the ability to surface metadata. As enterprises adopt new analytical and data management tools, a SQL access layer for this data becomes imperative. Many industries such as financial services, healthcare and technology rely on Progress® DataDirect® OpenAccess™ SDK to build a custom ODBC, JDBC, ADO.NET or OLE DB layer on top of their internal APIs and hosted multi-tenant databases.
Watch this on-demand webinar to learn about:
Plus—don’t miss our live demo using OpenAccess SDK to provide SQL access for a REST API.
Paper
IT needs a fast way to SQL-enable their internal API layer for business intelligence.
Organizations are investing heavily in API layers to control authentication and data access from one place. However, enterprise data teams can’t access this data from their favorite BI tools such as IBM Cognos, OBIEE, TIBCO or MicroStrategy without complex custom coding.
As companies adopt multiple analytical and data management tools, SQL access to the enterprise API layer (or data access layer) is crucial. The ideal solution enables you to quickly build real-time access to your API layer from popular BI tools, while taking advantage of centralized API management capabilities.
Download the whitepaper to learn:
Read about industry trends, product use cases, technical tips and more
Watch getting started tutorials and how-to videos
How industries tackle their toughest challenges with Progress
Training and hands-on tutorials
Watch webinars about DataDirect on demand
Read whitepapers from Progress DataDirect and industry experts
UZ Leuven, one of Belgium’s largest hospitals, needed a efficient complex data migration from multiple sources to be shared across 200 applications and multiple facilities. Using Progress® DataDirect® OpenAccess their IT team was able to create a database emulation layer that made it possible to pre-configure and test database integration with DB2 on all 200 applications.
Unisys Global Media embeds DataDirect Technologies’ wire protocol ODBC driver for Oracle within Hermes, its news content manager. As a result, Unisys customers have fast-to-the-wire access to Oracle databases and seamless integration between Unisys' editorial solutions and their existing databases and software packages.
DataDirect Connectors
Contact Us
Copyright © 2021 Progress Software Corporation and/or its subsidiaries or affiliates.All Rights Reserved.
Progress, Telerik, Ipswitch, Chef 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 for appropriate markings.