sender JDBC

[Former Member]

Hello Friends,

I need to work an Sender DataBase scenario....Here how to get data from the Database automatically...

1)I heard we can use stored procedure at Database side will be executed .How to do this.

2)How to poll this activity.

In one of my interfaces in Prod Systems...After getting the data from database it is again converting it to the soap data and then passing it to file...why is it so?

[former_member183906]

Hii

Stored Procedure can be surely executed.

Stored procedures are similar to user-defined functions (UDFs). The major difference is that UDFs can be used like any other expression within SQL statements, whereas stored procedures must be invoked using the CALL statement

Stored procedures can return result sets, i.e. the results of a SELECT statement. Such result sets can be processed using cursors by other stored procedures by associating a result set locator, or by applications. Stored procedures may also contain declared variables for processing data and cursors that allow it to loop through multiple rows in a table. The standard Structured Query Language provides IF, WHILE, LOOP, REPEAT, CASE statements, and more. Stored procedures can receive variables, return results or modify variables and return them, depending on how and where the variable is declared.

http://help.sap.com/saphelp_nw04/helpdata/en/1d/756b3c0d592c7fe10000000a11405a/content.htm

One of the usage is to prevent the query to directly write to the database

http://en.wikipedia.org/wiki/Stored_procedure

Check these:

http://help.sap.com/saphelp_nw04s/helpdata/en/b0/676b3c255b1475e10000000a114084/frameset.htm

http://help.sap.com/saphelp_nw04s/helpdata/en/4d/8c103e05df2e4b95cbcc68fed61705/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/45/023c41325fa831e10000000a1550b0/frameset.htm

If stored procedure is not thru by u ,use it

You need to use, Oracle functions as a alternate,

Database (JDBC) Adapter

The JDBC Adapter allows access to any DB that allows a JDBC driver to access the DB. This driver is not supplied with the adapter but must come from the DB provider or a 3rd party. The adapter converts database content to XML and vice versa.

Database content can be read with any SQL statement using a special XML format. This format enables SQL INSERT, UPDATE, SELECT, DELETE or even stored procedures. A message is always processed in one database transaction.

Refer the following links for further assistance

JDBC ADAPTER:

http://help.sap.com/saphelp_nw2004s/helpdata/en/1d/756b3c0d592c7fe10000000a11405a/frameset.htm

http://help.sap.com/saphelp_nw04s/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/frameset.htm

Use thes step by step guidese

https://wiki.sdn.sap.com/wiki/display/XI/JDBCTOJDBC

https://wiki.sdn.sap.com/wiki/display/XI/XMLFile2XMLFile

tutorial

http://help.sap.com/saphelp_nw2004s/helpdata/en/1d/756b3c0d592c7fe10000000a11405a/frameset.htm for sender side JDBC configuration.

Follow this link

JDBC is a technical Adapter provided by SAP.

Configuring the Sender JDBC Adapter

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

http://help.sap.com/saphelp_nw04/helpdata/en/1d/756b3c0d592c7fe10000000a11405a/content.htm

[Former Member]

Hi,

Follow this link

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/1084c536-711e-2b10-e48a-924a6074...

Stored procedure example :

create procedure test_sp

@table_name varchar(30)

as

set nocount on

exec('set transaction isolation level read uncommitted select * from '+@table_name)

Sender JDBC config

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

[Former Member]

Refer this link: [Configuring the Sender JDBC Adapter|http://help.sap.com/saphelp_NW04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm]

Also try to find forums, blogs and articles on this. Lots of documents are available on SDN that will help you to understand how to use JDBC sender adapter and stored procedure.

Thanks

Farooq

[VijayKonam]

Refer to Help.sap.com - PI Documentation - Search for JDBC Sender Adapter. Complete documentation is given with example.

VJ