Solved

ODBC connection to SAP's Oracle data base

Posted on 2010-11-29
5
1,730 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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Note: You must have administrative privileges in order to create/edit Roles. Salesforce.com (http://www.salesforce.com/) (SFDC) is a cloud-based customer relationship management (CRM) system. It is a database most commonly used by sales and markeā€¦
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

863 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

20 Experts available now in Live!

Get 1:1 Help Now