Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Fetching data into SAP from external Database Oracle

Former Member

‎2006 Nov 23 7:39 AM

0 Likes
386

Hi,

I want to conenct to an external database from SAP.

I tried using Native SQL.

But I'm not very familiar about the DBCO Transaction and tnsnames.ora file.

Can you help me on this?

Can you suggest other ways of connecting to external database from SAP.

Regards

Nancy

2 REPLIES 2
Read only

Former Member

‎2006 Nov 23 7:41 AM

0 Likes
360

hi Nancy,

Check these out

Regards,

Santosh

Read only

Former Member

‎2006 Nov 23 7:52 AM

0 Likes
360

Thanks Santosh for your immediate response.

But I'm not having problems from the coding side.

I'm facing problems in getting connected to the oracle server via DBCO Transaction.

I don't understand what exactly has to be done in tnsnames.ora file.

I'm not able to locate this file? Where does this file reside and what exactly has to be done and what entry should be made in connection information field in DBCO transaction.

Kindly Help.