Automated analysis/migration of Cognos Data Manager jobs
Posted: Thu Nov 24, 2016 7:53 am
Hi All,
Disclaimer: I am aware of Cognos Data Manager migration assistant that helps in the migration of Data Manager jobs to Datastage. For certain reasons we do not have access to this tool at our site. Also, the IBM Data Manager Migration assistant will only migrate jobs to Datastage and not to other tools (understandably) like Talend, SSIS, Informatica etc., Plus it has limitations for automation, job analysis etc.,
I have been entrusted with the task of automating the migration of Cognos Data Manager catalogs/jobs to Datastage. I have started the automated migration in small steps by analyzing Cognos Data Manager jobs using parsing tools and pre-generated Datastage job templates. Had some good success for simple Data Manager jobs and now moving on to automated analysis of complex Cognos Data Manager jobs.
I would be interested in hearing from this community about their experiences in analyzing/migrating/automation of Cognos Data Manager jobs, tools & techniques, strategies, pitfalls etc., to enhance my understanding of migration and automation.
Any thoughts, comments, pointers appreciated.
Thanks
Disclaimer: I am aware of Cognos Data Manager migration assistant that helps in the migration of Data Manager jobs to Datastage. For certain reasons we do not have access to this tool at our site. Also, the IBM Data Manager Migration assistant will only migrate jobs to Datastage and not to other tools (understandably) like Talend, SSIS, Informatica etc., Plus it has limitations for automation, job analysis etc.,
I have been entrusted with the task of automating the migration of Cognos Data Manager catalogs/jobs to Datastage. I have started the automated migration in small steps by analyzing Cognos Data Manager jobs using parsing tools and pre-generated Datastage job templates. Had some good success for simple Data Manager jobs and now moving on to automated analysis of complex Cognos Data Manager jobs.
I would be interested in hearing from this community about their experiences in analyzing/migrating/automation of Cognos Data Manager jobs, tools & techniques, strategies, pitfalls etc., to enhance my understanding of migration and automation.
Any thoughts, comments, pointers appreciated.
Thanks