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

connecting to external data base

vijy_mukunthan
Active Contributor

‎2007 Dec 28 5:23 AM

0 Likes
717

hi sap gurus

v r using ECC6 . how to connect to external data base like oracle,SQL server or MS-ACCESS.In dotnet u can connect just giving the server name in tools-->connect to database .like that is there any configuration or writing code in ABAP. If code as to be written how to code. If configuration has to done how to do the configuration. help me

Regards

vijay

hi sap gurus

v r using ECC6 . how to connect to external data base like oracle,SQL server or MS-ACCESS.In dotnet u can connect just giving the server name in tools-->connect to database .like that is there any configuration or writing code in ABAP. If code as to be written how to code. If configuration has to done how to do the configuration. help me

Regards

vijay

Reply
5 REPLIES 5
Read only

Former Member

‎2007 Dec 28 7:57 AM

0 Likes
697

Hello Vijay,

If ur data is not in sap itself than only u can access the data by using abap. U need to load ur data in sap by writing abap programs/ executing standard programs. After that only u can access data by abap.

Regs,

Saurabh

Read only

Former Member

‎2007 Dec 28 8:04 AM

0 Likes
697

hi,

if you have to use data from the external data base u will have to import the data to the sap system

u can use the function modules gui_upload and gui_download for the transafer of data to ur system

Read only

Former Member

‎2007 Dec 28 8:08 AM

0 Likes
697

what type of data base are u trying to connect to

Read only

vijy_mukunthan
Active Contributor
In response to Former Member

‎2007 Dec 28 8:59 AM

0 Likes
697

hi friend

i need to connect both sql server and oracle(different from build in database)

Regards

vijay