Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

how to store field BLOB (oracle) in amazon S3

Hi How can I store a field Blob (in my oracle table) in my amazon Bucket.

I created a pipeline : origin => jdbc query consumer and it is selecting my Blob field destination => amazon S3

I am able to copy the file in S3, but i think something is wrong because i can't visualise my pdf file

how to store field BLOB (oracle) in amazon S3

Hi How can I store a field Blob (in my oracle table) in my amazon Bucket.

I created a pipeline : origin => jdbc query consumer and it is selecting my Blob field destination => amazon S3

I am able to copy the file in S3, but i think something is wrong because i can't visualise my pdf file

thanks

how to store field BLOB (oracle) in amazon S3

Hi How can I store a field Blob (in my oracle table) in my amazon Bucket.

I created a pipeline : :

  • origin => jdbc query consumer and it is selecting my Blob field field
  • destination => amazon S3

I am able to copy the file in S3, but i think something is wrong because i can't visualise my pdf file

thanksI configured for amazon S3 :

  • tab "DATA FORMAT" = SDC RECORD

I tried all of them and it is the only one working, also it copied files in S3 but it is Json, it looks like that

�{"header":{"stageCreator":"JDBCQueryConsumer_01","sourceId":"SELECT BIN_CONTENUFROM ERM.DOCUMENT_E::rowCount:0","stagesPath":"JDBCQueryConsumer_01","trackingId":"SELECT BIN_CONTENUFROM ERM.DOCUMENT_E::rowCount:0::JDBCQueryConsumer_01","previousTrackingId":null,"raw":null,"rawMimeType":null,"errorDataCollectorId":null,"errorPipelineName":null,"errorStage":null,"errorStageLabel":null,"errorCode":null,"errorMessage":null,"errorTimestamp":0,"errorStackTrace":null,"errorJobId":null,"values":{"jdbc.tables":"","jdbc.BIN_CONTENU.jdbcType":"2004"}},"value":{"type":"LIST_MAP","value":[{"type":"BYTE_ARRAY","value":"JVBERi0xLjMKJZKgoooKNCAwIG9iago8PC9UeXBlL1hPYmplY3QKL1N1YnR5cGUvSW1hZ2UKL1dpZHRoIDE2NjQKL0hlaWdodCAyMzM5Ci9CaXRzUGVyQ29tcG9uZW50IDEKL0NvbG9yU3BhY2UvRGV2aWNlR3JheQovRmlsdGVyWy9DQ0lUVEZheERlY29kZV0KL0RlY29kZVBhcm1zWzw8L0NvbHVtbnMgMTY2NCAvUm93cyAyMzM5Pj5dCi9MZW5ndGggMjgyMDMKPj4Kc3RyZWFtCgACwagAsGoALBqACwagAsGoALBqACwagAsGoALBqACwagAsGoALBqACwagAsGoALBqACwagAsGoALBqACwagAsGoALBqACwagAsGoALBqACwagAsGoALBqACwagAsGoALBqACwagAsGoALBqACwagAsGoALBqACwagAsGoALBqACwagAsGoALBqACwagAsGoALBqACwagAsGoALBqACwagAsGoALBqACwagAsGoALBqACwagAsGoALBqACwagAsGoALBqACwagAsGoALBqACwagAsGoALBqACwagAsGoALBqAC11hMkwAWDUAFg1ABYNQAWDUAFg1ABYNQAWDUAFg1ABYNQAWDUAFg1ABYNQAWDUAFg1ABYNQAWDUAFg1ABYNQAWDUAFg1ABYNQAWDUAFg1ABQ==","attributes":{"sdp.classified":"true"},"sqpath":"/BIN_CONTENU","dqpath":"/BIN_CONTENU"}],"sqpath":"","dqpath":""}}

.image description