Blog Feed Post

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

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.

Deliver Secure SQL Access for Enterprise APIs

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

Read the original blog entry...

More Stories By Progress Blog

Progress offers the leading platform for developing and deploying mission-critical, cognitive-first business applications powered by machine learning and predictive analytics.

Latest Stories
As you move to the cloud, your network should be efficient, secure, and easy to manage. An enterprise adopting a hybrid or public cloud needs systems and tools that provide: Agility: ability to deliver applications and services faster, even in complex hybrid environments Easier manageability: enable reliable connectivity with complete oversight as the data center network evolves Greater efficiency: eliminate wasted effort while reducing errors and optimize asset utilization Security: implemen...
DXWordEXPO New York 2018, colocated with CloudEXPO New York 2018 will be held November 11-13, 2018, in New York City and will bring together Cloud Computing, FinTech and Blockchain, Digital Transformation, Big Data, Internet of Things, DevOps, AI, Machine Learning and WebRTC to one location.
DXWorldEXPO LLC announced today that ICOHOLDER named "Media Sponsor" of Miami Blockchain Event by FinTechEXPO. ICOHOLDER give you detailed information and help the community to invest in the trusty projects. Miami Blockchain Event by FinTechEXPO has opened its Call for Papers. The two-day event will present 20 top Blockchain experts. All speaking inquiries which covers the following information can be submitted by email to [email protected] Miami Blockchain Event by FinTechEXPO also offers s...
DXWorldEXPO | CloudEXPO are the world's most influential, independent events where Cloud Computing was coined and where technology buyers and vendors meet to experience and discuss the big picture of Digital Transformation and all of the strategies, tactics, and tools they need to realize their goals. Sponsors of DXWorldEXPO | CloudEXPO benefit from unmatched branding, profile building and lead generation opportunities.
@DevOpsSummit New York 2018, colocated with CloudEXPO | DXWorldEXPO New York 2018 will be held November 11-13, 2018, in New York City. From showcase success stories from early adopters and web-scale businesses, DevOps is expanding to organizations of all sizes, including the world's largest enterprises - and delivering real results.
Dion Hinchcliffe is an internationally recognized digital expert, bestselling book author, frequent keynote speaker, analyst, futurist, and transformation expert based in Washington, DC. He is currently Chief Strategy Officer at the industry-leading digital strategy and online community solutions firm, 7Summits.
DXWorldEXPO LLC announced today that Dez Blanchfield joined the faculty of CloudEXPO's "10-Year Anniversary Event" which will take place on November 11-13, 2018 in New York City. Dez is a strategic leader in business and digital transformation with 25 years of experience in the IT and telecommunications industries developing strategies and implementing business initiatives. He has a breadth of expertise spanning technologies such as cloud computing, big data and analytics, cognitive computing, m...
Digital Transformation and Disruption, Amazon Style - What You Can Learn. Chris Kocher is a co-founder of Grey Heron, a management and strategic marketing consulting firm. He has 25+ years in both strategic and hands-on operating experience helping executives and investors build revenues and shareholder value. He has consulted with over 130 companies on innovating with new business models, product strategies and monetization. Chris has held management positions at HP and Symantec in addition to ...
Cloud-enabled transformation has evolved from cost saving measure to business innovation strategy -- one that combines the cloud with cognitive capabilities to drive market disruption. Learn how you can achieve the insight and agility you need to gain a competitive advantage. Industry-acclaimed CTO and cloud expert, Shankar Kalyana presents. Only the most exceptional IBMers are appointed with the rare distinction of IBM Fellow, the highest technical honor in the company. Shankar has also receive...
DXWorldEXPO LLC announced today that Kevin Jackson joined the faculty of CloudEXPO's "10-Year Anniversary Event" which will take place on November 11-13, 2018 in New York City. Kevin L. Jackson is a globally recognized cloud computing expert and Founder/Author of the award winning "Cloud Musings" blog. Mr. Jackson has also been recognized as a "Top 100 Cybersecurity Influencer and Brand" by Onalytica (2015), a Huffington Post "Top 100 Cloud Computing Experts on Twitter" (2013) and a "Top 50 C...
There is a huge demand for responsive, real-time mobile and web experiences, but current architectural patterns do not easily accommodate applications that respond to events in real time. Common solutions using message queues or HTTP long-polling quickly lead to resiliency, scalability and development velocity challenges. In his session at 21st Cloud Expo, Ryland Degnan, a Senior Software Engineer on the Netflix Edge Platform team, will discuss how by leveraging a reactive stream-based protocol,...
Enterprises have taken advantage of IoT to achieve important revenue and cost advantages. What is less apparent is how incumbent enterprises operating at scale have, following success with IoT, built analytic, operations management and software development capabilities - ranging from autonomous vehicles to manageable robotics installations. They have embraced these capabilities as if they were Silicon Valley startups.
Daniel Jones is CTO of EngineerBetter, helping enterprises deliver value faster. Previously he was an IT consultant, indie video games developer, head of web development in the finance sector, and an award-winning martial artist. Continuous Delivery makes it possible to exploit findings of cognitive psychology and neuroscience to increase the productivity and happiness of our teams.
Poor data quality and analytics drive down business value. In fact, Gartner estimated that the average financial impact of poor data quality on organizations is $9.7 million per year. But bad data is much more than a cost center. By eroding trust in information, analytics and the business decisions based on these, it is a serious impediment to digital transformation.
The standardization of container runtimes and images has sparked the creation of an almost overwhelming number of new open source projects that build on and otherwise work with these specifications. Of course, there's Kubernetes, which orchestrates and manages collections of containers. It was one of the first and best-known examples of projects that make containers truly useful for production use. However, more recently, the container ecosystem has truly exploded. A service mesh like Istio addr...