Converting data from XML format to SQL Format

[Former Member]

Hi All

This may sound very basic but i need help with the following :

I have a BLS transaction which has to read data from ECC using JCO connections and then store it in a SQL database.

Can some body please tell me how can i convert the data that i obtain from JCO in the form of XML into a form which can be inserted into the SQL database.

Please help.

Regards

Shweta

[former_member204240 · Accepted solution]

Hi Shwetha,

Your flow in BLS Trx goes like this.

JCO action Block

Condition Block(To check if JCO call is success)

Repeater(To get each row of the Jco output)

Insert Qry Call( Your insert query to insert into SQL db).

Just pass each column value((whatever you need) of repeater to the insert query params.

So it just maps all rows values as you are using repeater which is nothing but a loop.

Hope this helps.

Regards,

Rao