Skip to main content
Documentation
Featured Content
Feature Requests Status Community

Community

Connector Improvement: Support for XML-files in Cloud Storage

Pernille Andresen Klevstuen User

I would like for Fivetrans Cloud Storage Connector to support XML-files so they can be easily ingested into destinations like BigQuery.

 

It would generally be nice if all connectors working with files would support XML-files.

Please sign in to leave a comment.

Comments

5 comments

Date Votes
  • Official comment
    Alison Fivetranner

    Hi Pernille,

    Thank you for taking the time to let us have your feed back. Adding support for XML-files in our file connectors is something we are monitoring at this time. I'd love to know more about which types of XML files you would be interested in us supporting - or to put it another way do you always have a fixed XML file structure or would you expect to also provide the XML file definition file to the connector?

    How many different types of XML files do you need to sync into your Warehouse?

    How are XML files used in your business,

    Thank you 

    Alison

  • Skyler Young User

    I second this. Tragically, I need to import tables from .xlsx. The ability to do this from GCS, for example, would be very handy in our use cases.

  • Solomon Shorser User

    This would be nice. Right now we need to transform all of our XML documents to JSON before Fivetran can ingest them. It would be nice to eliminate the extra processing step.

  • Pernille Andresen Klevstuen User

    Hi Alison,

    XML is very standard in our business, the Retail Industry. Especially ARTS XML is industry standard for transactional data (https://www.omg.org/retail/schema.htm), as a result, it is quite commonly used for all types of documents. 

     

    There is not always a fixed XML file structure.

     

     

     

  • Alison Fivetranner

    Hi Penille,

    Thanks for the additional information and the link to the standard schemas.

    You mention there is not always a fixed schema - in that case how would you want the data structured in your warehouse?
    Many XML docs will be too large to be a value in a single row of a single column.

    Alison

Didn’t find what you need?

Contact support