topic Re: connecting to external data base in Application Development and Automation Discussions

connecting to external data base

vijy_mukunthan — Fri, 28 Dec 2007 05:23:00 GMT

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

Re: connecting to external data base

Former Member — Fri, 28 Dec 2007 07:57:36 GMT

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

Re: connecting to external data base

Former Member — Fri, 28 Dec 2007 08:04:24 GMT

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

Re: connecting to external data base

Former Member — Fri, 28 Dec 2007 08:08:50 GMT

what type of data base are u trying to connect to

Re: connecting to external data base

vijy_mukunthan — Fri, 28 Dec 2007 08:59:30 GMT

hi friend

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

Regards

vijay

Re: connecting to external data base

Former Member — Fri, 28 Dec 2007 10:45:30 GMT

try this link

hope this helps u

http://sap.ittoolbox.com/groups/technical-functional/sap-dev/connecting-to-external-database-857467

http://sap.ittoolbox.com/groups/technical-functional/sap-dev/connecting-to-external-database-858057