Topic
  • 2 replies
  • Latest Post - ‏2014-04-02T11:15:14Z by AnaghaGala
AnaghaGala
AnaghaGala
2 Posts

Pinned topic Migrating from IBM Cognos Data Manager to DataStage

‏2014-03-18T11:04:16Z |

Hi

Our team has an existing application based on Cognos and uses Cognos Data Manager as the ETL tool. We are looking to take up migration of this system to IBM DataStage + Cognos (For reporting) combination, primarily due to Data manager's inability for parallel jobs.

Are there any tools / assets / know-how / best practices etc available for this topic ? Has it been done earlier (I am hoping so !) ?

It would be very helpful if you can share your inputs based on your experience.

thanks

Anagha

Updated on 2014-03-18T12:02:56Z at 2014-03-18T12:02:56Z by AnaghaGala
  • onevedrov
    onevedrov
    7 Posts
    ACCEPTED ANSWER

    Re: Migrating from IBM Cognos Data Manager to DataStage

    ‏2014-03-18T18:05:09Z  

    Hello Anagha, there is not tools, which will migrate DM catalog into DS project. Also, these tools are different. You can only take SQLs from the DM. You can do migration in phases. Migrate only jobs, which will immediately benefit from parallelism. Keeping most if not all dimensions in DM. Good luck.

  • onevedrov
    onevedrov
    7 Posts

    Re: Migrating from IBM Cognos Data Manager to DataStage

    ‏2014-03-18T18:05:09Z  

    Hello Anagha, there is not tools, which will migrate DM catalog into DS project. Also, these tools are different. You can only take SQLs from the DM. You can do migration in phases. Migrate only jobs, which will immediately benefit from parallelism. Keeping most if not all dimensions in DM. Good luck.

  • AnaghaGala
    AnaghaGala
    2 Posts

    Re: Migrating from IBM Cognos Data Manager to DataStage

    ‏2014-04-02T11:15:14Z  
    • onevedrov
    • ‏2014-03-18T18:05:09Z

    Hello Anagha, there is not tools, which will migrate DM catalog into DS project. Also, these tools are different. You can only take SQLs from the DM. You can do migration in phases. Migrate only jobs, which will immediately benefit from parallelism. Keeping most if not all dimensions in DM. Good luck.

    Thanks.