Software ETL question

Hello Experts,

Which of these three different software’s extract, transfer and load data (Terabyte data) the quickest?  This data resides in Oracle.
      
1      ESSBASE  - Hyperion
2      Informatica
3      SQL - TOAD

Currently, using MS Access queries have proven very sluggish and slow, and we are wondering if SQL in Toad might be a potential solution.

What are your thoughts regarding whether or not ESSBASE, Informatica or creating Hyperion cubes would be an option of being faster with ETL?  

Thanks
LVL 1
CFMIFinancial Systems AnalystAsked:
Who is Participating?
 
Jim HornConnect With a Mentor Microsoft SQL Server Developer, Architect, and AuthorCommented:
Informatica, and other ETL tools such as IBM DataStage and Microsoft SSIS, are the tools to transfer data from a source to a destination.  

They are not data containers within themselves that store data.

>(Terabyte data)
>MS Access queries have proven very sluggish and slow
The file size limitation of an Access database is 2 Gb's, so if we're talking Teradata than that is well beyond Access' capabilities.
0
 
sventhanConnect With a Mentor Commented:
I'd choose like this

1) informatica
2) ESSBASE
0
 
CFMIFinancial Systems AnalystAuthor Commented:
My last two questions, can you explain why and does Informatica load data into SQL Server for Users to extract or does it stay within itself?
0
 
CFMIFinancial Systems AnalystAuthor Commented:
Thank you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.