Optim - Test Data Management and Archiving

Optim Connect Studio vs Attunity Connect Studio automatic conversion of Oracle Number Datatype

  • 1.  Optim Connect Studio vs Attunity Connect Studio automatic conversion of Oracle Number Datatype

    Posted 3 days ago
      |   view attached

    optim 11.3.0.8  optim connect studio 5.3.3 Oracle 19c


    When defining any datasources on archives containing Oracle tables data, all the fields defined as number in Oracle, became automaticaly decimal(43,5) in the table  definition in connect studio !

    So, when process/read  via an ODBC connect driver 3.5 definition , with a third part tool for example, Rapid SQL, the number is really represented in numéric (43,5) !       So   number 23 for example , became 23.00000  !

    Is there a way to define a datasource in Connect studio related to an Oracle table without this automatic conversion of NUMBER datatype with  a scale ?

    Note : in attunity connect studio, Oracle Number datatype (without precision and scale) where represented in numeric(15) (no scale) , and it was fine.

    Thanks in advance...       yves.michaud@saq.qc.ca







    ------------------------------
    yves michaud
    Optim developer
    SAQ
    Montreal QC
    514 254 6000 #5023
    ------------------------------

    Attachment(s)

    docx
    preuveNum43_5.docx   152 KB 1 version