Solved

ODBC connection to SAP's Oracle data base

Posted on 2010-11-29
5
1,716 Views
Last Modified: 2013-12-08
Does anyone use odbc connectivity to SAP's Oracle tables for reporting and bolt on application development?
0
Comment
Question by:George Kerestes
  • 3
  • 2
5 Comments
 
LVL 6

Assisted Solution

by:Twisteddk
Twisteddk earned 500 total points
ID: 34233908
Rarely. While it's tempting to do so, You have to remember that You've only got a two user license on that Oracle base if it's the one that came with SAP.
Also, for reasons of portability, it's normally more practical to develop your application in/for the application layer (SAP) than the database layer. And if you screw things up, SAP support will likely hit you with a "You screwed it up, You fix it" if something goes wrong, and you accidentally mess up things for the application, like dataloss, performance, licensing issues, connection problems, security etc.
Developing for the application also makes auditing a lot easier. And when it comes right down to it..... The ABAP language in SAP is frightningly similar to Open SQL, so I rarely find the need to do much development in unsupported tools.

What exactly were You considering doing/building ?
0
 

Author Comment

by:George Kerestes
ID: 34234725
We have some very specific documents such as our production order shop packets, simplified production order shop floor reporting (which we would use the SAP SOA objects) and the like. We also may want to tap the database for information which we might want to feed to other non-SAP applications (read only from SAP). I also have learned more from the data base layer than I can normally get straight from the application layer. I have no desire to do anything other than read only.
0
 
LVL 6

Accepted Solution

by:
Twisteddk earned 500 total points
ID: 34241300
Depending on the data you want to transfer, SAP has some specific tools for this. If you need integration into other systems, it's always a good idea to use established APIs. For most systems you can register a program in the SAP gateway, and have it talk syncronously to your program, if async is ok, then simple CSV or EDI/IDOC format and a FTP transfer. This is normally a lot easier to handle than ODBC, also easier for the purposes of performance, security, traceability, monitoring and depending on the experience of your basis/interface guy, also debugging.

If the document you want to transfer is defined as an IDOC, this is pretty much as good as gold when it comes to external processing. but creating new outbound documents can be a pain, so for simple reporting purposes, a CSV file would likely be easier. An ODBC seems excessive, both in terms of cost (new Oracle license, monitoring on a remote subsystem etc.) and risk and is normally not needed. Keep in mind that if YOU develop the integration, then YOU have to support it, which makes buying a 3rd party piece of software a nice choice when it comes to vacation time, night calls, support, upgrades etc.

I'd suggest that you look at the BW/BI or even BO modules and ask if any of these cant be used to satisfy your output needs and/or customized to do so. Unless you need to export the entire database, I'd go with reporting or CSV output, and even in case of an entire database, I'd prefer a data dump over an ODBC. If what you're connecting to has the ability, then use IDOCS or registered server programmes, or if you have it already, then use your SAP XI/PI or Websphere MQ system to exchange (and convert) the data you need between the system(s). This is the "default" way to go, and I've yet to see it fail.

What you have to keep in mind is that a LOT of people before You have had to come to terms with getting data out of the database under the SAP system, and they've spent thousands if not millions of hours developing integration and tools for these purposes. So be "the lazy admin", dont develop that which You can buy (or even get for free in many cases) while also pawning off support on someone else ;)
0
 

Author Comment

by:George Kerestes
ID: 34269124
I received an email saying it was still open. I also wanted to meake sure I acknowledge both experts  for their helpful responses.
0
 
LVL 6

Expert Comment

by:Twisteddk
ID: 34269475
Everything is fine thanx. And feel free to ask away in this or new threads.
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Suggested Solutions

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
I showed you how to use console view (HERE (http://www.experts-exchange.com/articles/18379/Getting-Started-and-Using-the-Salesforce-com-Console.html)) -– but how do you set it up on the admin side of Salesforce? Note that you have to have Admin leve…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now