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.  WTX connection to SQL 2012

    Posted 06/15/16 03:27 AM

    Originally posted by: al88ch


    Dears,

     

    i have a scenario to build a map from csv to SQL DB, WTX is installed on AIX 7.1 and im getting an error Target Not Available when trying to execute the map on AIX, while on windows its working fine, (i have an mdq file) i believe i should define the SQL ODBC or JDBC on WTX AIX but i dont know how to do it, can anyone guide me to do it.

     

    Thanks


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


  • 2.  Re: WTX connection to SQL 2012

    Posted 06/15/16 10:20 AM

    Originally posted by: Ejay


    Hello,

    We just received a PMR for this, did you  open one ?


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


  • 3.  Re: WTX connection to SQL 2012

    Posted 06/19/16 03:09 AM

    Originally posted by: al88ch


    Hi,

     

    yes i did i solved the Connectivity issue, but when im trying to run the BP that include WTX map the output file is being written to a file instead of being written to DB directly.


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


  • 4.  Re: WTX connection to SQL 2012

    Posted 06/28/16 08:46 AM

    Originally posted by: paul.brett


    Either your BP contains an override to make the Target use the FILE adapter, or perhaps the compiled-in setting is FILE, and you forgot to change it before compiling the map for the target platform and deploying it.

    Thank-you

    Paul

    Follow me on Twitter


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