Standard SAP Program to query external DB

[Former Member]

Hi,

Please let me know if there is any standard SAP program to connect to external DB and run queries on them, just like "RSFTP002" program where we can connect to FTP Server and execute FTP commands.

I tried with RSDB* commands but most of them are related to SAP DB itself.

kindly help.

Regards,

Anand Srinivas

[MichalKrawczyk]

Hi,

you can use "SQL Developer" to run such queries on most of DBs and it has most of the drivers

it's not possible with any standard transaction in SAP

Regards,

Michal Krawczyk

[Former Member]

Hi,

Sorry for not giving you the background !!!

1. I do not have access to SAP PI server.

2. DBs which are within the network, i can access from my system.

3. DB which I need to access is outside SAP (Company) network.

4. Firewalls are open only for SAP PI system.

5. hence i need to connect from SAP only.

having said that..

Will I be able to access DB outside the network thru SQL Developer?

Regards,

Anand Srinivas

[MichalKrawczyk]

Hi,

>>>>Will I be able to access DB outside the network thru SQL Developer?

this those two:

3. DB which I need to access is outside SAP (Company) network.

4. Firewalls are open only for SAP PI system.

I believe you won't be but give it a try - download SQL developer and test it from within the network and from outside the network

maybe someone told you that something is closed but it may be opened...

from PI you can only check if the DB connection is working using link:

http://server:port/ftpjdbc

but you cannot use it to query

Regards,

Michal Krawczyk

[Former Member]

Hi,

checked but not able to log in

I have checked this with other clients before i logged it in SDN and was looking if there are any program in SAP like "RSFTP002" thru which i can access DB, as firewalls will be open only to SAP PI system connected to it via communication channel.

Regards,

Anand Srinivas