Extract BLOB-Data with DatabaseExampleSource
Hello,
I want to extract data from an Oracle-Database. It's possible to connect to the database and read all tables. However, for one data-type (BLOB = binary large objects) the table contains only '?'. What I would like to have is to see the data of the field MODUL_DATA as hex-string which I then can convert later ...
<operator name="Root" class="Process" expanded="yes">
<operator name="DatabaseExampleSource (2)" class="DatabaseExampleSource">
<parameter key="database_system" value="Oracle"/>
<parameter key="database_url" value="jdbc:oracle:thin:@nu0xxxxxxxxxxxxxxxx"/>
<parameter key="username" value="XXXX"/>
<parameter key="password" value="XXXX"/>
<parameter key="query" value="SELECT "ID_MM", "MODUL_DATA" FROM "MES_AUMM""/>
</operator>
</operator>
What should I do?
Thanks for your help
Best Regards
VD
I want to extract data from an Oracle-Database. It's possible to connect to the database and read all tables. However, for one data-type (BLOB = binary large objects) the table contains only '?'. What I would like to have is to see the data of the field MODUL_DATA as hex-string which I then can convert later ...
<operator name="Root" class="Process" expanded="yes">
<operator name="DatabaseExampleSource (2)" class="DatabaseExampleSource">
<parameter key="database_system" value="Oracle"/>
<parameter key="database_url" value="jdbc:oracle:thin:@nu0xxxxxxxxxxxxxxxx"/>
<parameter key="username" value="XXXX"/>
<parameter key="password" value="XXXX"/>
<parameter key="query" value="SELECT "ID_MM", "MODUL_DATA" FROM "MES_AUMM""/>
</operator>
</operator>
What should I do?
Thanks for your help
Best Regards
VD