IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.


#Sterling
#Supplychain
 View Only

  • 1.  database adapter issue:

    Posted 08/20/08 10:30 AM

    Originally posted by: malag


    I have huge data and database adapter is unable to load into the table.Is there any other way to load or extract data other than using a database adapter.
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 2.  Re: database adapter issue:

    Posted 08/20/08 12:37 PM

    Originally posted by: paul.brett


    You could use the SHELL adapter to drop out to the OS, and call the bulk data load tools supplied with the database software. I wuoldn't recommend it for situations where transactional integrity is important.

    Paul.
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender


  • 3.  Re: database adapter issue:

    Posted 08/20/08 12:52 PM

    Originally posted by: malag


    This seems interesting.Can you please explain how to do it or suggest me the refence to learn about it.
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


  • 4.  Re: database adapter issue:

    Posted 08/23/08 01:15 PM

    Originally posted by: janhess


    There's an example of using the Oracle bulk loader in the examples folder.
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 5.  Re: database adapter issue:

    Posted 08/26/08 10:40 AM

    Originally posted by: jvanboga


    curious, what is the failure message you get in the dbl log?
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 6.  Re: database adapter issue:

    Posted 08/26/08 11:02 AM

    Originally posted by: malag


    The message in .dbl file is "Adapter is unable to load data".
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 7.  Re: database adapter issue:

    Posted 08/26/08 11:24 AM

    Originally posted by: jvanboga


    Is your DB oracle? What version of the tool are you using and what version DB + adapter?

    For example, older versions of TX may not be compatable with more recent versions of Oracle (TX 6.n and Oracle 10.g were never supported, as far as I know)
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 8.  Re: database adapter issue:

    Posted 08/26/08 11:28 AM

    Originally posted by: malag


    I am using wtx8.1 and oracle 9i.I got the same problem with oracle 10G
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 9.  Re: database adapter issue:

    Posted 08/26/08 12:14 PM

    Originally posted by: jvanboga


    8.1 is 9i compatable ( I think it's also 10g compatable )

    Try using janhes's rec using sqlloader. I didn't have the problem you are having but for my large files sqlloaded worked best.
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 10.  Re: database adapter issue:

    Posted 08/27/08 03:24 AM

    Originally posted by: janhess


    Could this be a problem with Oracle rollback files? Try using burst mode for your load data (pick a suitable number of records to process per burst) and use commit by burst in the output card.
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


Related Content