Migration from Abinitio to Datastage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 145
- Joined: Fri May 02, 2003 9:59 am
- Location: Seattle, Washington. USA
Re: Migration from Abinitio to Datastage
There is the idea of runtime column propagation that does the same thing that you are describing.
Shawn Ramsey
"It is a mistake to think you can solve any major problems just with potatoes."
-- Douglas Adams
"It is a mistake to think you can solve any major problems just with potatoes."
-- Douglas Adams
Re: Migration from Abinitio to Datastage
Do you mean that it automatically maps input columns to output columns ?
Thank you.
Thank you.
ps
Re: Migration from Abinitio to Datastage
In Enterprise edition the two features that come close to the dynamic metadata supported by abinito are schema files and runtime column propogation. There are quite a few restrictions to this though e.g. it is one way i.e. you can't use schema files like you can use dml files on the output side. RCP is also very very sensitive to data types i.e. it is just not column names that need to match but also types and that too exactly.
There are lots of other differences.
There are lots of other differences.
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
I wouldn't be surprised if there was a single tool that had a conversion engine and had various adaptors for Informatica, DataStage server jobs and Ab Initio. In theory they could build a converter for any ETL tool if the demand was there.
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
For the functionality of in.* of Abinitio to be placed in Datastage to make the columns propagartion easy I have enabled the RCP 3 ways.
Once in the Administrator, and once within the Job Proprties and once within the stages.
When I do this, the columns get mapped by themselves and I dont have to do anything in the transformer.
Thanks to everyone.
Once in the Administrator, and once within the Job Proprties and once within the stages.
When I do this, the columns get mapped by themselves and I dont have to do anything in the transformer.
Thanks to everyone.
ps
-
- Participant
- Posts: 136
- Joined: Wed Sep 29, 2004 5:56 am
- Location: Chennai
- Contact:
Ab Initio to DS Convertion
Hi Duke/Ray,kduke wrote:I was told IBM/Ascential had a tool to automate this conversion as well as converting from Informatica. It does not convert everything but supposed to convert most. Ask them. Ray may know.
Do we have such tool for convertion from one tool to another bulit by IBM?
Regards
Rajeev Prabhu
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Indeed, such tools are jealouly guarded by IBM, and only available as services (that is, you never get to see the tools and they're never deployed to your hardware).
As to whether they've developed one for Ab Initio, I have no idea. Why not ask IBM, specifically the Center of Excellence for Data Integration (CEDI)?
As to whether they've developed one for Ab Initio, I have no idea. Why not ask IBM, specifically the Center of Excellence for Data Integration (CEDI)?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
The "tool" is called DS Migrator and is managed by IBM CEDI Professional Services as an offering. Much of the migration must take place overseas due to legal issues with Informatica. The tool addresses converting Informatica Maps (or even DS Server to DS Parallel)....This was all initiated when DS replaced Informatics in the Peoplesoft EPM ETL offering and Peoplesoft wanted some automated way. AbInitio is not part of this conversion offering.
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
I sat in on an IBM CEDI presentation last week at IOD on re-usable DataStage parallel job flows. They used DataStage jobs with column propagation, parallel stages such as modify and sort that received instructions via job parameters with all the metadata defined in external schema files. In one project they spent eight weeks building four re-usable DataStage jobs that could handle hundreds of different interfaces. The tricky part is managing all the schema files as they cannot be created through import wizards. Most DataStage projects go for hard coded column metadata because it's easier to manage.
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