REST APIs as a SQL Data Source for SAP BOBJ, Cognos or OBIEE

REST APIs as a SQL Data Source for SAP BOBJ, Cognos or OBIEE

August 17, 2017 0 Comments
REST APIs as a SQL Data Source for SAP BOBJ, Cognos or OBIEE_870x220
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.

My recent conversations with IT architects from financial services, healthcare and other industries revealed that enterprises are looking for ways to integrate their internal API layer into various core business intelligence tools such as SAP BusinessObjects, IBM Cognos, Tableau, Qlik, OBIEE, SAS, Informatica and others. So, we're hosting a webinar to help you learn how to use Progress DataDirect OpenAccess SDK to quickly deploy SQL clients—ODBC, JDBC, ADO.NET or SSIS—for your enterprise APIs.


Enterprise API Layer


Gartner featured our technology as a leader in Data Virtualization for databases and APIs, and we have worked with a number of organizations to deliver SQL clients for enterprise APIs. The DataDirect OpenAccess SDK connector architecture provides these data clients for BI tools while leveraging centralized API infrastructure capabilities such as:

  • Access to real-time data and business logic or financial calculations
  • Monitoring of data access for unauthorized usage or external attacks
  • Enforcement of existing access controls across teams and organizations
  • Detailed data lineage to provide end-to-end audit trails
  • Authentication using access control and identity management products (CA Siteminder, Oracle Access Manager, Entrust Get Access, RSA Access Manager, etc.)

Build a Custom ODBC, JDBC, ADO.NET or OLE-DB Driver in Weeks!

Whether your data source is a proprietary file format or a web services API, OpenAccess SDK can be used to make it SQL-accessible. Up to 99% of the required code to implement a standards-based driver, with full SQL support, is included in the SDK. You can either leverage our REST IP Generator or implement 12 high level functions in the programming language of your choice that take care of exposing the schema and accessing data.

Here are some of the top features:

  • Supports interfacing to data sources using C/C++, Java, or .NET
  • Over 100 enterprises have used OpenAccess SDK to create SQL clients for their data sources or APIs
  • Supports a large portion of SQL 92 including complex syntax such as joins, unions, nested query or stored procedures
  • Broad platform support for business applications across Windows, Linux, AIX or Solaris
  • Unparalleled compatibility with popular analytics and data management infrastructure

Learn More from the Founder of DataDirect OpenAccess SDK

Since we realize that this is an industry-wide problem, we are offering you a unique webinar with the founder of the OpenAccess SDK technology, Dipak Patel, where he speaks about:

  • Use cases for enabling SQL access to enterprise APIs
  • How enterprises are doing it
  • How you can do it in under 20 days using OpenAccess SDK (demo included)
  • Best practices for building a SQL access layer

Next Steps

If you can relate to any of the following, we highly recommend that you register for this webinar:

  • Your users are demanding SQL access to your enterprise API layer / data access layer
  • You need to enable SQL access to the business logic layer from third-party BI and analytics tools
  • You want to learn more about virtualizing/modernizing one or more file-based data stores such as C-ISAM, COBOL, BTree, CTree, XML, JSON, EDI message, Log files, REST or SOAP
Register for the Webinar Now


Get Started with OpenAccess SDK

Sumit Sakar

Sumit Sarkar

Sumit Sarkar is a Chief Data Evangelist at Progress, with over 10 years experience working in the data connectivity field. The world's leading consultant on open data standards connectivity with cloud data, Sumit's interests include performance tuning of the data access layer for which he has developed a patent pending technology for its analysis; business intelligence and data warehousing for SaaS platforms; and data connectivity for aPaaS environments, with a focus on standards such as ODBC, JDBC, ADO.NET and ODATA. He is an IBM Certified Consultant for IBM Cognos Business Intelligence and TDWI member. He has presented sessions on data connectivity at various conferences including Dreamforce, Oracle OpenWorld, Strata Hadoop, MongoDB World and SAP Analytics and Business Objects Conference, among many others. 

Comments
Comments are disabled in preview mode.
Topics
 
 
 
Latest Stories in
Your Inbox
Subscribe
More From Progress
thumbnail
2017 Data Connectivity Outlook Survey
Download Whitepaper
 
Cognitive Apps
Progress Accelerates Cognitive Apps Strategy
Download Whitepaper
 
lp_header_image_cropped
Strategy Update with CEO Yogesh Gupta
Watch Webinar