JDBC Adapter query

[former_member312853]

Hi Experts,

Can some explain me the difference between the XML SQL format and Native SQL format protocols?

[former_member186851 · Accepted solution]

Hello Bharath,

XML SQL Format

Table values can be inserted, updated, or deleted in one or more tables. In the database, stored procedures can be called using transfer parameters. In the case of synchronous queries, results from database queries or return values of stored procedures can also be transferred.

Native SQL String

An arbitrary SQL statement is expected as the message content. This statement is transferred unaltered to the database for processing

You can refer the below discussion

[iaki_vila]

Hi everyone,

Just to add, SAP recommends to use the XML SQL format, with this format you can do great number of SQL sentences, even you have the possibility of use "SQL_QUERY” or “SQL_DML" formats that lets you to write your sentence SQL as Native SQL. From my point of view, forget Native SQL option and go to practice with XML SQL format.

Regards.

[vicky20691]

Hi Bharath,

If  you want to know difference of this from PI perspective you could have got it in help.sap.com itself.

Still posting the links-

Configuring the Receiver JDBC Adapter - Configuring the JDBC Adapter in the Integration Directory/PC...

Defining XML Documents for Message Protocol Native SQL Format - Configuring the JDBC Adapter in the ...

Defining XML Documents for Message Protocol XML SQL Format - Configuring the JDBC Adapter in the Int...

Above is the visible difference the way we define XML Data Type for JDBC operations.

Regards,

Vikas