Common Connector Migration Tool login problem

bluezed28 · Post by **bluezed28** » Mon Feb 08, 2010 4:03 pm

Has anyone tried to use the Common Connector migration tool, CCMigration.exe.

When I try to loging by specifying the domain , user, password and project name it receive the error

Failed to connect to the project: Node for DataStage server with name [servername] is not found in the repository.

My ETL and Services layers on differnt boxes. I wonder if the migration tool assumes that they are both on the same server. I have opened a PMR but wondering if anyone has has similar issues.

ray.wurlod · Post by **ray.wurlod** » Mon Feb 08, 2010 4:06 pm

Have not (yet) used CCMigration.exe so can not advise.

chulett · Post by **chulett** » Mon Feb 08, 2010 4:12 pm

Not wanting to derail the thread but what exactly is this tool?

bluezed28 · Post by **bluezed28** » Tue Feb 09, 2010 9:17 am

DataStage 8.1 provides a new DB connectivity stage, Common Connector.
It supports Oracle, Terra Data and DB2 (maybe a few more). It's supposed to be alot easier to configure than the enterprise stages, and I assume you don't need to pay for the additional Datastage licenses if you are running an MPP environment. It also has a number of properties not in the enterprise stages.

Anyways, it comes with a migration tool to replace all the enterprise stages in your jobs with the Common Connector Stage. I have over 200 stages to replace so this would be a huge timesaver.

The tool is located on the PC in the clients directory.

chulett · Post by **chulett** » Wed Feb 10, 2010 7:14 am

Sounds like a connector version of the DRS stage.

seanc217 · Post by **seanc217** » Tue Mar 09, 2010 11:33 am

Did you get a resolution to this yet?
I have a PMR open too.

I will update if I get any answers.

Thanks.