XML to JDBC

[Former Member]

Hi ,

My scenario is to update an XML Document to SQL Database. Where SQL Table has very complex structure (Say 150 Fields ) .

Can any one tell me which is the best approach to Export all the field structure from SQL Table and to importing them in XI.

-Rama

[Former Member · Accepted solution]

Hey

Please check the following blog

Thanx

Aamir

[former_member181962 · Accepted solution]

NIce blog Aamir..:)

@Ram: Please check the blog given by aamir. Thats the way to do it.

Regards,

Ravi

[Former Member · Accepted solution]

Hi Aamir ,

Thank you It is very useful Blog .. I have tried the same what was given in it and it is working now ...

Thank you .

-Rama

[former_member181962]

I do not know much about the SQL structures, but is there a possibility to get a XSD structure from SQL Database?

If yes, you can import the XSD into the XI IR using External definitions.

If you have a XML data file, you can generate a XSD for the XML using tool like COOKTOP, XML SPY, ALTOVA etc.

Regards,

Ravi

[Former Member]

Hi Ravi,

I have already loaded the XSD of the XML structure and Updated a Table in Database with only 10 fields ( In XI I have Manually created Data type with 10 rows ) .

But, My Problem or my Question is whether I need to create all 150 fields manually or whether there is any other way is there to export the structure from SQL and importing them to XI ?

-Rama