E

Wednesday, October 26th, 2022 2:55 PM

XML Datatype within SQL database

We are trying to onboard a SQL source to Collibra containing XML datatype. Has anyone had any experience /success with successfully doing this using the Collibra SQL JDB driver?

683 Messages

 • 

15.3K Points

2 years ago

Thank you. yes we have looked at these drivers but the documentation for the sql server JDBC drivers. The question is can read the xml data type contained within the SQL database and extract the metadata contained within the XML.

1.2K Messages

Reading the relational schema and telling you that the field is of type xml should be relatively straightforward.
Giving you the model of the XML on the other hand is mission impossible. Collibra has no built-in support for semi-structured documents (xsd, json-schema, avro…) and the JDBC driver has no functionality for this either.

Thank you Arthur. Unfortunately, this is what I suspected would be the answer, but I was hoping that someone might have tried something and had success. Thanks again!

1.2K Messages

2 years ago

We are trying to onboard a SQL source to Collibra containing XML datatype. Has anyone had any experience /success with successfully doing this using the Collibra SQL JDB driver?

SQL JDB driver

41 Messages

2 years ago

@anupam.sharma @eallen.geico.com Not with a connector, but it’s fairly easy with e.g. python to get the data out of the SQL DB, parse the xml with and use the rest API to import the data into Collibra.

Loading...