Date: Thu, 1 Jun 2006 10:51:23 -0700
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
Subject: ETL Studio - Setting up DEV TEST and PROD environments
Content-Type: text/plain; charset="iso-8859-1"
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 -
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
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.