Load Ingest Data
Results 1 to 2 of 2

Thread: XML parsing?

  1. #1
    anwark is offline Junior Member
    Join Date
    May 2015
    Posts
    3
    Rep Power
    0

    XML parsing?

    Hello,

    I am wondering if Attunity CloudBeam is capable to read and parse an XML record from within a SQL Table?

    The goal is to read, parse and extract some of the XML parameters and values stored in SQL Server table and map them to an Amazon Redshift db as simple field values. Since Redshift does not support the XML data type, I need to parse XML values and transfer them to a Redshift as db.table.field.

    This is a basic ETL functionality but I am not able to figure out how to do this. Please advise.

    Thank you,
    Anwar

  2. #2
    stevenguyen is offline Senior Member
    Join Date
    May 2014
    Posts
    301
    Rep Power
    6
    Hello Anwar,

    We support the XML data type as NCLOB, will need to have PK.

    However, Redshift target does not support XML data type.

    We do not have a method to parse the XML and update dynamic db.table.field targets.

    This would need to be done in a second step with a different tool.

    Thanks,
    Steve

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •