Integrating SAP with C++, Java, and Powerbuilder on Sybase and Oracle DBs

Integrating SAP with C++, Java, and Powerbuilder on Sybase and Oracle DBs

My landscape is an SAP ECC 6.0 system. Some legacy applications written in Java, C++, and Powerbuilder using Sybase and Oracle databases. Most of them should read from SAP, and a few should write. I would like to know what tools I can use, some best practices for this instance, and architectural guidelines to make this successful from the beginning.

    Requires Free Membership to View

    Login

    When you register, you will start receiving targeted emails from my award-winning team of editorial writers. Our goal is to keep you informed on the hottest topics and biggest challenges faced by SAP professionals today.

    Hannah Smalltree, Editorial Director

    By submitting your registration information to SearchSAP.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchSAP.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

There is a wealth of information on the Internet regarding connectivity from SAP to external/legacy applications. SearchSAP.com is a good place to start but you may also want to check out SAP's developer network.

From an architecture point of view, one of the current best practice approaches for connecting an SAP to a non-SAP system is called a Services Oriented Architecture. Although SOA can be defined through a number of different technical implementations, at a high level SOA means exposing reusable services through a generic middleware layer. This middleware can be written in any language that is compatible with your application subsystems.

Of course, my background is Java integration for SAP so I would recommend looking at SAP's Java connector, JCo. JCo allows you to tap into any exposed RFC/BAPI interface available within SAP. The major caveat when exposing SAP tables this way is to do so through a published and supported SAP interface. If you attempt direct table updates against a standard SAP table you are almost guaranteed failure. JCo is available through SAP service marketplace as a free download, and sites like SearchSAP.com have a number of helpful articles to get you going.

This was first published in May 2007