Need for DS TX
Need for DS TX
I had worked in DS server and parallel jobs.
I want to know what is the need for DS TX and how it is different from DS PX.
I want to know what is the need for DS TX and how it is different from DS PX.
TX is an advanced transformation engine that can handle complex data types with ease. It can also connect to a variety of messaging programs, databases and other apllications. It can be used with Event Server, to be time and or event driven with coordination between time & event, or even multiple events.
It is also a very fast transformation engine.
It is also a very fast transformation engine.
Re: Need for DS TX
DataStage PX is designed more from ETL point of view, while TX is mainly for converting data. Although, TX has interfaces setup for various systems, it cannot take care of data partitioning as effeciently as in PX, and not sure if TX can take care of bulk loads into databases too. PX is designed to work around the more fashionable ways of working on Datawarehouses, while in TX you have to make it work that way explicitly through your maps and message flows.
Usually you might put TX in front of PX\Server jobs to translate very complex data into more simpler forms for DS (ETL) to take care of.
- Sachin
Usually you might put TX in front of PX\Server jobs to translate very complex data into more simpler forms for DS (ETL) to take care of.
- Sachin
Ravindar wrote:I had worked in DS server and parallel jobs.
I want to know what is the need for DS TX and how it is different from DS PX.
Hello Forum,
I have no experience with TX, but based on comparisons given here between PX and TX, it looks as though they are competing products with significant overlap.
Doesn't the RTI/Soa extension to PX offer similar messaging capabilities to TX? I hear that it can handle complicated datatypes. Exactly what type of data types or file structures can TX handle that PX cannot?
My client is getting a sales pitch to use TX. Is it a wise decision to start using this product in 2006? Do people see it's functionality eventually merged with Enterprise Edition?
Thanks,
Greg
I have no experience with TX, but based on comparisons given here between PX and TX, it looks as though they are competing products with significant overlap.
Doesn't the RTI/Soa extension to PX offer similar messaging capabilities to TX? I hear that it can handle complicated datatypes. Exactly what type of data types or file structures can TX handle that PX cannot?
My client is getting a sales pitch to use TX. Is it a wise decision to start using this product in 2006? Do people see it's functionality eventually merged with Enterprise Edition?
Thanks,
Greg
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
DataStage EE and Server are mainly used to handle relational data. If they have a complex data source such as a complex flat file or XML they usually have to convert it to flat relational records in order to transform them. TX is better with complex data such as Electronic Data
Interchange (EDI), Health Insurance Portability and Accountability Act
(HIPAA), Financial Services (SWIFT). It is better at handling complex data as sources and targets. It has better connectivity to EAI where these complex transactions often appear.
Interchange (EDI), Health Insurance Portability and Accountability Act
(HIPAA), Financial Services (SWIFT). It is better at handling complex data as sources and targets. It has better connectivity to EAI where these complex transactions often appear.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Thanks for your response vmcburney.
1. Could you elaborate on what XML processing functionality (parsing/transformation) I would be able to achieve with TX that I would not be able to achieve with the XML Input, XML Ouput and XML Transformer Stages from the Soa Extension package for EE?
2. Could you elaborate on what EAI connectivity I can use in TX that cannot be achieved in Soa Extension package for EE?
Thanks in advance,
Greg
My client is not interested in EDI, HIPAA, or SWIFT. They will be processing some XML.vmcburney wrote:DataStage EE and Server are mainly used to handle relational data. If they have a complex data source such as a complex flat file or XML they usually have to convert it to flat relational records in order to transform them. TX is better with complex data such as Electronic Data
Interchange (EDI), Health Insurance Portability and Accountability Act
(HIPAA), Financial Services (SWIFT). It is better at handling complex data as sources and targets. It has better connectivity to EAI where these complex transactions often appear.
1. Could you elaborate on what XML processing functionality (parsing/transformation) I would be able to achieve with TX that I would not be able to achieve with the XML Input, XML Ouput and XML Transformer Stages from the Soa Extension package for EE?
2. Could you elaborate on what EAI connectivity I can use in TX that cannot be achieved in Soa Extension package for EE?
Thanks in advance,
Greg
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
When Ascential bought Mercator and turned it into TX it came with a very large number of adaptors and connectors including some EAI queues that DataStage did not have. Couldn't tell you the exact list, it used to be listed on the Ascential web site but in recent times they have made this type of information very hard to find and most of the TX PDF library links are broken or contain very little useful information. You will have to contact Ascential directly.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn