Date:         Thu, 1 Jun 2006 10:51:23 -0700
Reply-To:     sharadnc@GMAIL.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         sharadnc@GMAIL.COM
Organization: http://groups.google.com
Subject:      ETL Studio - Setting up DEV TEST and PROD environments
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset="iso-8859-1"

Hi There,

We have been using Base SAS for our ETL process till now. Now, we are
thinking to move to ETL Studio process. I am NOT clear as to how one
would setup DEV Test & PROD environments at the Repository level.

Or let me put it this way...

How do we create DEV Test & PROD environments with each of them
pointing to different source Databases and schemas (for eg. we pull
data from CDWD (DBinstance on DB2 DBMS with a proj schema ) while in
development, CDWU while in TESTING, CDWP while in Production ).

I gathered some views on the Internet saying that PROD should be custom
repository, DEV and TEST should be project repositories with a
dependency on the PROD custom repository. Is this the way?
( Source -
http://groups.google.com/group/comp.soft-sys.sas/browse_thread/thread/c7fe2472339bba06/8ca1f0ff965bdfec?lnk=st&q=ETL+studio&rnum=16&hl=en#8ca1f0ff965bdfec).
Don't we point to the same datasource in this setting? My guess is that
in ALL the environments the Source table's Metadata is using the same
SAS/ACCESS Libname statement to extract the data from a DB.

In an another post
source-http://businessintelligence.ittoolbox.com/groups/technical-functional/sas-l/test-environment-setup-sas-etl-studio-997830#

the author mentions that they would Export the metadata/Jobs and then
import them in the new environment. Don't we point to the same
datasource in this setting too?

How would my scenario work in this case i.e. pointing to different DB
instances and schemas in different environments?

Any help in this regard would be highly appreciated.