DI Job Migration from Dev to test

dataservices job design
1

Hi all,
Iam new to data Integrator,I need to Migrate DI Job from Dev to test.
Can You tell me the Procedure.Any help is greatly appreciated.

Environment -BO XIR2,DI XIR2,sql server 2000.

Thanks in Advance.

clickajji (BOB member since 2006-10-21)

2

Hi:

Just EXPORT all the DF/WF/JOBS you need into ATL file…

and then IMPORT that in TEST …Its very easy…

INJOI…

data_guy :us: (BOB member since 2006-08-19)

3

Hi There !!

This looks like a very simple process but actually there are a lot of things you need to verify before the migration is done.

I’ll give you a simple example,

The Datastore Connection information will definetly change between Development and Testing so you need to ensure that even though the DB Connection name is different , the Schema Names should be same in both environments.

DI will start throwing Validation and Execution error in case such checks are not performed.

If you want to discuss in more details , please let me know.

Thanks,
Rahul

rahul.johari :india: (BOB member since 2006-07-04)

4

In the Design help doc, one of the pdf is called
“Data Integrator Advanced Development and Migration Guide” and it outlines the details you need for migration.

I am new to designer.
In the first attempt, I tried direct export from dev repository to production repository. Got some trouble.
Later, I was told by the BO support not to use that.
Definitely not recommended.

The ATL export works better but I have a few issues opened with BO.

Good luck.

itguy (BOB member since 2007-04-25)

5

There’s a number of ways of doing this and it depends upon what your corporate/team/department standards are. Two main approaches are using either export/import or using Central Repository functionality.

Export/Import is probably simplest but doesn’t provide change management capabilities (not a problem if you use a different system for source control).

Central Repository uses inbuilt DI capabilities to provide version control and change manaagement.

Assuming that your dev & test environments are using the same version of DI, then the easiest method is to export the dev job ATL file (include the datastore contents, i.e. tables, but exclude the datastores themselves). Then import the ATL file into your test environment. This approach can be used also for migrating jobs at workflow and dataflow level as well.

Second approach of using Central Repository involves adding objects to the Central Repository when logged in as Dev and then ‘getting’ them or checking them when logged in as ‘Test’. Again, this can be done at job, worflow and daatflow level.

gpn01 :uk: (BOB member since 2004-11-30)

6

https://wiki.sdn.sap.com:443/wiki/pages/viewpage.action?pageId=49414406

Werner Daehn :de: (BOB member since 2004-12-17)

7

Hi,

For any reason I have one Dev. enviroment Data Services (3.0) and other Prod. enviroment Data Services (3.1). I have 22 Dev users, Can I migrate some Dev jobs to Prod enviroment even though they are different releases?

Thank you,

jasdue.

jasdue (BOB member since 2007-02-07)

8

Yes, when you import the older ATL into a newer DI version, that’s okay. The other way around obviously does not work.

Werner Daehn :de: (BOB member since 2004-12-17)

9

Hi,

Thanks for your soon reply!

jasdue.

jasdue (BOB member since 2007-02-07)