Update database outside SAP

[Former Member]

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

[Former Member]

middleware?

check this link

http://www.sap2win.com

Regards,

Joris

[Former Member]

Hi,

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

Regards,

Renjith Michael.

[Former Member]

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

[Former Member]

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

[Former Member]

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

[mnicolai_77]

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