RFC to Oracle database

[Former Member]

Hello,

I want to implement scenario from RFC to table in Oracle database.

I want to know how I need to configure the JDBC receiver adapter?

Is it possible to update data in the table and not insert all the time?

Thanking you in advance

Elad

[Former Member · Accepted solution]

Hi

You can update the Oracle table instead of inserting new row each time.

http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

JDBC structure for Update

/people/alessandro.berta/blog/2005/10/04/save-time-with-generalized-jdbc-datatypes

1. Create a RFC in the R/3 system

2. Configure the SM59 and Sender Communication channle as given in the Michal's blog. Also test if it is succesful.

/people/michal.krawczyk2/blog/2005/03/29/configuring-the-sender-rfc-adapter--step-by-step

3. Import the RFC in XI

4. Do the mapping to the target strucutre

5. Configure the JDBC receiver adapter

/people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn

6. You can trigger the RFC from R/3 sytem by using

For Async Call of RFC

CALL Function "RFC Name" IN BACKGROUND TASK destination <sm59 destination>

COMMIT WORK.

Sync Call of RFC

CALL Function "RFC Name" destination <sm59 destination>

Refer

step by step RFC to JDBC scenario

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/step%2bby%2bstep%2brfc%2bto%2bjdbc%2bscenario

you need to call the RFC from the R3

/people/michal.krawczyk2/blog/2005/03/29/configuring-the-sender-rfc-adapter--step-by-step

map the RFC to the JDBC format (insert)

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

and configure the jdbc adapter

Thanks

Swarup

Edited by: Swarup Sawant on Feb 26, 2008 7:26 AM

[Former Member]

Hi Elag,

As your error states that it is not able to connect to the database because of missing driver.

So first of all check that drivers are deployed correctly.

Follow the steps for checking the drivers:

Go to Visual admin:

1) chose table cluster->server->libraries->com.sap.aii.af.jmsproviderlib

2) Check in window jar container,if JMS/JDBC libraries are uploaded correctly

3) Look ar jars contained

3) look at \usr\sap\<sysID>\JCOO\j2ee\cluster\server-\bin

Also check the deployment in Visual Admin

1) choose tab cluster->server->service->classloader viewer

2) Look tab in runtime component-> libraries-> com.sap.aii.af.jmsproviderlib for JDBC/JMS lib.

Check that drivers are properly deployed.

And Secondly, that you can try:

Connection url:

Format is --> jdbc:oracle:thin:@hostname:port:SID

Here in this connection url replace : @hostname: port: SID with the TNSNAMES file content.

You will find this file in Oracle folder.

C:\Program Files\oracle\ora92\network\admin

For e.g. -

jdbc: oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ntbomsap13)(PORT = 1527)) ) (CONNECT_DATA = (SID = XI3) (SERVER = DEDICATED) ) )

Hope it solves your query,

Please reward points if it solves your query.

[Former Member]

Hi

Q1.I want to know how I need to configure the JDBC receiver adapter?

ANS.yes

look this link for configuring receiver jdbc adapter

http://help.sap.com/saphelp_nw04/helpdata/en/14/80243b4a66ae0ce10000000a11402f/frameset.htm

Q2.Is it possible to update data in the table and not insert all the time?

yes

[Former Member]

Hello,

Now I implement the scenario and in RWB I have this error:

Error during database connection to the database URL 'jdbc:oracle:thin:@dev-portal1:1527:SPD' using the JDBC driver 'jdbc.odbc.JdbcOdbcDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:oracle:thin:@dev-portal1:1527:SPD': SAPClassNotFoundException: jdbc.odbc.JdbcOdbcDriver'

Any idea how to solve this issue?

Elad

[nisarkhan_n]

DriverName: "oracle.jdbc.driver.OracleDriver"

Connection : "jdbc:oracle:thin:@<HOSTNAME>:1521:<DBHOST>"

Login to the DB check you are able to connect to the DBHOST Name which you are mentionein in the URL above...it should exist in the ORA file on the DB...else you can use the Default DBName like ORACLEDB

For Ex:

jdbc:oracle:thin:@gscts01.com:1521:ORACLEDB

make sure you have deployed the driver "ojdbc14.jar" fiel deoployed....

[Former Member]

Hi,

Check witht the Drivers.

Check witht the User name and Pwd

check this

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/70ffd890-0201-0010-708f-d5dad2df...

Regards

Seshagiri

[rodrigoalejandro_pertierr]

hi

see this

hope it helps

[Former Member]

hi

go through this link it might helpfull

thanks

kunaal

[Former Member]

Hi,

You can check with this File----JDBC for Receiver Structure

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

While RFC is the sender means check with these

/people/swaroopa.vishwanath/blog/2006/12/28/send-rfc-to-sap-xi-150-asynchronous

/people/michal.krawczyk2/blog/2005/03/29/configuring-the-sender-rfc-adapter--step-by-step

/people/shabarish.vijayakumar/blog/2008/01/08/troubleshooting--rfc-and-soap-scenarios-updated-on-20042009

Regards

Seshagiri

[Former Member]

Hi Elad,

To get the details of the config of Receiver Adapter check help.sap.com It contains all the required info related to XI .

And yes you can update the database without inserting everytime.

Regards.

Amit