IBM Optim

IBM Optim

Enable Data Operations with Optim for AI and Cloud - accelerating innovation, reducing costs, ensuring data sovereignty


#Dataintegration
#Databases
#InfoSphereOptim
#Analyticstools
 View Only

  • 1.  Handling Oracle ORDIMAGE Datatype using Optim

    Posted 01/29/20 02:49 PM
    Hello Team,

    I have an Oracle DB with a column defined as ORDIMAGE type. My Optim extract itself is failing because of this. 

    Has anyone faced this issue before and can suggest of an alternate solution to handle this ? 

    Thank You,
    Sam

    ------------------------------
    Sam
    ------------------------------

    #InfoSphereOptim
    #Optim


  • 2.  RE: Handling Oracle ORDIMAGE Datatype using Optim

    Posted 01/29/20 05:29 PM
    Yes, we've run into this one and various other data types like BLOB, CLOB, IMAGE, MEDIA, etc.. from various databases. We have often found that the actual data  inside one of the fields is not supported by the source database and would also throw errors if you try to query it directly from a DB client. 

    Can you query this table/column/row using SQL Developer or SQL client? Does it return all results or fail? If you cannot query the data directly from a SQL client then you need to transform it or fix it in the source database. If you can query it from a DB client without errors, then I would start making sure that the Oracle version is fully supported. 

    Watch the Optim Temp logs to catch the Stored Procedure that it's failing on. The you can steal the Optim SP sql code to try and isolate where the failure is occurring. 

    That's my two cents. Tell us what you find if you solve it.

    ------------------------------
    Danny Lankford
    3M - IT Manager
    ------------------------------



  • 3.  RE: Handling Oracle ORDIMAGE Datatype using Optim

    Posted 01/29/20 08:38 PM
    Thanks for your thoughts. I'm able to query the table successfully using sql developer and the Oracle version used is supported by Optim.

    ------------------------------
    Sam
    ------------------------------

    Original Message


  • 4.  RE: Handling Oracle ORDIMAGE Datatype using Optim

    Posted 01/30/20 02:35 PM
    Hello Sam,

    There are some data types, Optim doesn't support. If you encounter unsupported data types, create a view and remove the unsupported data type column in tour select clause of the view and add the view in your AD to archive/extract the data. 

    Support data types are as below,



    Thanks and regards,
    Vishwas Balakrishna
    C: +1 818 309 0972
    E: vishwas.balakrishna@estuate.com
    Estuate, Inc. Princeton, NJ


    This email contains confidential material prepared for the intended addressees only and it may contain intellectual property of Estuate, Inc, its affiliates or a third party. This material may not be suitable for, and we accept no responsibility for, use in any context or for any purpose other than for the intended context and purpose. If you are not the intended recipient or if we did not authorize your receipt of this material, any use, distribution or copying of this material is strictly prohibited and may be unlawful. If you have received this communication in error, please return it to the original sender with the subject heading "Received in error," then delete any copies.


    ------Original Message------

    Thanks for your thoughts. I'm able to query the table successfully using sql developer and the Oracle version used is supported by Optim.

    ------------------------------
    Sam
    ------------------------------

    #InfoSphereOptim
    #Optim


  • 5.  RE: Handling Oracle ORDIMAGE Datatype using Optim

    Posted 01/31/20 11:48 AM
    Thanks Vishwas. Will try that out. 

    Thank You,
    Sam

    ------------------------------
    Sam
    ------------------------------

    Original Message


Related Content