Copy CLOB/BLOB Data from Informix Source

Keshavi Patel 1 Reputation point
2022-07-19T15:28:00.613+00:00

Does Azure Data Factory support copying CLOB/BLOB data from an Informix host?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,053 questions
{count} votes

1 answer

Sort by: Most helpful
  1. KranthiPakala-MSFT 46,402 Reputation points Microsoft Employee
    2022-07-28T21:07:09.5+00:00

    Hi @Keshavi Patel ,

    As per the discussion with internal team, AD uses 3rd party Informix driver to source data. It should support all data types supported by Informix available with sdk.

    Best option is to query table with clob/blob column and see if that source table columns are copied to sink.

    You can try to source CLOB by using CAST(column AS VARCHAR(n)), it is also possible to source BLOB (Informix BYTE data type) using ODBC linked service.

    Hope this info helps. Do let us know if you have further questions.

    Thank you