DSXchange

I need to move server jobs from DS 7.5.1 without PX(EE) on Windows to DS 8.01 with PX on Linux.
We are using a lot of environment variables. In the past I used environment transport program, but that was between DS 7.5 projects.
Is there anything similar for the conversion that I am doing now?
I can't just copy DSParams file because old installation did not have PX and the new one does.
Thanks.

Just copy those rows from DSParams that you need in the new project, and make sure that they are emplaced in the correct section in that project's DSParams file.

Ideally preserve alphabetical order. This is not essential, it just makes the drop-down lists cleaner when adding environment variables to job designs.

Hello Gurus,

I created a New Project and would like to copy User defined Environment Variable from other project.
As Ray said i copied last lines in DSParams file and past in New Project.
It did not work for me.

ray.wurlod wrote:Just copy those rows from DSParams that you need in the new project, and make sure that they are emplaced in the correct section in that project's DSParams file.

Ideally preserve alphabetical order ...

DO we need to restart the server? or do i need to do anything else

Appreciate your Help

lenny wrote:Hello Gurus,

I created a New Project and would like to copy User defined Environment Variable from other project.
As Ray said i copied last lines in DSParams file and past in New Project.
It did not work for me.

DO we need to restart the server? or do i need to do anything else

Appreciate your Help

It worked for me, even thought I do not like this solution and would prefer to have a utility.
But I did not copy the whole file from one project to another. I copied and pasted the sections of this file.
To make it work you have to realize that there are 2 sections to be copied:
One starts with:
[EnvVarDefns]
Be careful, there may be more entries in this session then you need. Copy and paste only user defined variables. And do not override whatever already exists in this section of the new file.
Second section starts with
[EnvVarValues]
Same caution needs to be taken.

And you do not need to restart engine.

Thanks for your quick reply

I got it now

Previously I did not copy from [EnvVarDefns] part in the file.

Just curious to know if there is any other way to copy Environment variable from Project to project

Thank you

None of which I am aware.

Wouldn't be surprised if there was something in 8.1 in the new deployment tool.

Wouldn't be surprised if there was something in 8.1 in the new deployment tool.

Would you be surprised if there isn't?

Hi

we are also facing same kind of problem. where should i find the DSParams file.

Thanks for your help.

The "DSParams" is found in the project directory for each project.

Thanks to every one for your valuable suggestions

Hi everybody,

In the Redbook "Infosphere DataStage: Parallel FrameworkStandard practises" on pages 60 and 68 a so called "Environment variable transporter"developed by CEDI ("Center of Exellence in Data Integration")
is mentioned, which should do exactly what is requeted here.

Problem is, the Redbook does not mention a download location and it does not provide any details who or what exactly CEDI is and how it can be contacted. Does anyone know more about this?

leomauer wrote:

lenny wrote:Hello Gurus,

I created a New Project and would like to copy User defined Environment Variable from other project.
As Ray said i copied last lines in DSParams file and past in New Project.
It did not work for me.

DO we need to restart the server? or do i need to do anything else

Appreciate your Help

It worked for me, even thought I do not like this solution and would prefer to have a utility.
But I did not copy the whole file from one project to another. I copied and pasted the sections of this file.
To make it work you have to realize that there are 2 sections to be copied:
One starts with:
[EnvVarDefns]
Be careful, there may be more entries in this session then you need. Copy and paste only user defined variables. And do not override whatever already exists in this section of the new file.
Second section starts with
[EnvVarValues]
Same caution needs to be taken.

And you do not need to restart engine.

The new migration tool, initially supplied through the Concierge service but now generally available, also picks up environment variables.