SAS and ETL tools

[stg]

Does anyone with a SAS datawarehouse or data marts have any experience (hands-on or through investigating)with ETL tools ? Any recommendations, warnings or advice ?

We have some SAS and ORACLE datamarts already in production and are looking for an ETL tool that might possibly work with both types. Is this a reasonable option?

 

[Guest_imported]

Why don't you use sas as the etl tool? I assume you are using the SAS warehouse administrator version2.

 

[stg]

Thanks for the response.
We're working with SIGMA, an OLAP tool that works with SAS, not the Warehouse Administrator.

We checked out the SAS ETL tool but have two major problems with it : a) the cost, b) it assumes that there is a centrally-administered datawarehouse. As we understand, the tool is not designed to handle our separate datamarts that are individually and independently administered.

We realize there is a problem using the same ETL tool for both Oracle and SAS datamarts, and are aware that we may have to compromise on a partial solution for SAS. Nevertheless, we're still hoping to find a way to integrate one ETL tool into both types of systems.
Is it feasible (and is there a point?) to use the tool to extract source data to flat files or even to Oracle before loading to SAS, or alternately, to load the prepared SAS files to Oracle so that we can work toward central metadata and eventually a central datawarehouse? To further complicate the question, I'd like to add that our SAS datamarts are quite large and already functioning on home-made ETL.

Any advice?? [sig][/sig]