topic Re: Update database outside SAP in Application Development and Automation Discussions

Update database outside SAP

Former Member — Tue, 15 Jan 2008 13:10:20 GMT

Hi guys, I have the following scenario:

Today, I have an abap program that calls a RFC to update a database outside SAP using Business Connector.

The problem is that I won't be allowed to use Business Conncetor (and can't use XI too) to access the outside database (SQL Server 05).

Is possible to update the SQL Server 05 from an Abap program without a Java based connector? Because my main problem is that I can't use Java...

Thank you in advance

Robert

Re: Update database outside SAP

Former Member — Fri, 18 Jan 2008 13:28:16 GMT

middleware?

check this link

http://www.sap2win.com

Regards,

Joris

Re: Update database outside SAP

Former Member — Fri, 18 Jan 2008 14:03:47 GMT

Hi,

I think the only ways to communicate with non-sap systems are rfcs(bapis too), and JCO.

Regards,

Renjith Michael.

Re: Update database outside SAP

Former Member — Fri, 18 Jan 2008 22:44:32 GMT

Hello Roberto,

perhaps this could help you:

http://help.sap.com/erp2005_ehp_03/helpdata/EN/fc/eb3b8b358411d1829f0000e829fbfe/frameset.htm

If you think this could help to solve your issue, than have an additional look at the statements "exec" in ABAP and at transaction DBCO (database table DBCON).

We're using this to update an external oracle DB (not the SAP DB) directly out of a ABAP report.

Best regards

Stephan

Re: Update database outside SAP

Former Member — Sat, 19 Jan 2008 19:58:50 GMT

As far I know, exec can execute sql command in the same db of SAP, but a part that is not managed by the SAP dictionary...

how can I access an outside db using exec? where do I define the db address and comunication protocol?

Thanks again

Re: Update database outside SAP

Former Member — Sun, 20 Jan 2008 12:30:59 GMT

Hello Roberto,

you can use exec sql commands with the SAP db, but you can also connect additional databases to SAP. Therefore you have to define the additional db in database table DBCON (transactio DBCO). In you report you have to connect the db using statements:

EXEC SQL.

connect 'name of db defined in DBCON'.

ENDEXEC.

The connect will set sy-subrc to 0, if the connect has been done successfully. Otherwise the sy-subrc <> 0.

Best regards

Stephan

Re: Update database outside SAP

mnicolai_77 — Sun, 20 Jan 2008 22:22:31 GMT

hi,

you can use the database connection

>exec

> native sql statment

>endexec

check theese links for generating source code in ABAP

[; insert data to external database

[; read data from external database

check theese links for configurating of DBCO (DataBase COnnection)

[/thread/108422 [original link is broken];

[http://help.sap.com/saphelp_nw04/helpdata/en/df/455ec9747111d6b25100508b6b8a93/frameset.htm]

hope that is useful.

Regards

Marco