Skip to Content

Mapping between SQL Server VARBINARY data type to Oracle CLOB/BLOB

Hi,

I have source MS SQL server. MS SQL server source contains some VARBINARY fields that contains PDF documents.

I have to load this into target Oracle table that contains blob/clob.

How can I load pdf documents from MS SQL server to Oracle.

Is SAP DS supports or not?

Thanks & Regards,

Ramana.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 06, 2017 at 07:57 AM

    Please RT*M. SAP Data Services Reference Guide, section 4.2.2. Conversion to or from internal data types:

    SQL Server varbinary(max) > DS blob > Oracle blob.

    Add comment
    10|10000 characters needed characters exceeded