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

Posted on 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

Technology researcher, thought leader and speaker working to enable enterprises to rapidly adopt new technologies that are adaptive, connected and cognitive. Sumit has been working in the data access infrastructure field for over 10 years servicing web/mobile developers, data engineers and data scientists. His primary areas of focus include cross platform app development, serverless architectures, and hybrid enterprise data management that supports open standards such as ODBC, JDBC, ADO.NET, GraphQL, OData/REST. He has presented dozens of technology sessions at conferences such as Dreamforce, Oracle OpenWorld, Strata Hadoop World, API World, Microstrategy World, MongoDB World, etc.

Comments

Comments are disabled in preview mode.
Topics

Sitefinity Training and Certification Now Available.

Let our experts teach you how to use Sitefinity's best-in-class features to deliver compelling digital experiences.

Learn More
Latest Stories
in Your Inbox

Subscribe to get all the news, info and tutorials you need to build better business apps and sites

Loading animation