🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Extract BLOB-Data with DatabaseExampleSource

User: "VD"
New Altair Community Member
Updated by Jocelyn
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"/&gt;
        <parameter key="username" value="XXXX"/>
        <parameter key="password" value="XXXX"/>
        <parameter key="query" value="SELECT &quot;ID_MM&quot;, &quot;MODUL_DATA&quot; FROM &quot;MES_AUMM&quot;"/>
    </operator>
</operator>

What should I do?

Thanks for your help

Best Regards

VD

Find more posts tagged with