Jump to content

TDV getting data from SQL server XML field


Merijn Manders

Recommended Posts

Hi,

Our ESB stores xml encoded messages in a SQL server 2014 table.

Each record in the table contains 1 message (over 5000 messages in total)

The table contains some metadata columns and an XML Type column in which the message (in xml) itself is stored.

The xml in each message contains a message id, message received date/time and message subject.

In TDV we would like to expose this data from the xml in a table like format with those colums (id, date, subject).

However I don't know how you would do that, because the xml is stored in a database and not on a file share in separate xml files.

Any ideas

Thanks!

Link to comment
Share on other sites

Hello,

Look at the TDV XML functions available to parse out the elements, attributes from the DB column.

For more information on the 'TDV Supported XML Functions ',refer to the 'TIBCOData Virtualization Reference Guide'.

Here is the link to access the documentation:

https://docs.tibco.com/pub/tdv/8.2.0/doc/pdf/TIB_tdv_8.2.0_ReferenceGuide.pdfid=3

You can also find that in your TDV_Install_Directory/Docs folder.

Regards,

Chandrika

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...