Originally posted by: SystemAdmin

Hi,

We have a requirement for an interface to SQL Database through Websphere TX.

Now we are using SQL query analyzer for database changes.

But now business wants a GUI through which we can incorporate the table changes..

Could any one please suggest the best way for this.

Thanks,
Deepthi Murali
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: NancyR

Not entirely sure I understand your question. Are you asking if a WTX map can create data and post it directly to a database table? If so, the answer is yes. You create a link to your database instance and a type tree to represent the data in the WTX Database Interface Designer. Then use Database as the Target in your output card.

If that wasn't the question, could you rephrase?
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: cemeinz

If I understood Murali right, they have the requirement or would like to develop an application, which based on WTX or has WTX embedded as "THE UNIQUE TRANSFORMATION ENGINE" ;-) in their logical / program layer between the gui and the persistent layer.

Well, it should be possible. But it affords some work.

Kind regards.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange