Skip to Content
0

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

Jul 06, 2017 at 06:45 AM

37

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Dirk Venken
Jul 06, 2017 at 07:57 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded