Solved

Software ETL question

Posted on 2013-06-28
4
592 Views
Last Modified: 2016-02-11
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
0
Comment
Question by:CFMI
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 18

Assisted Solution

by:sventhan
sventhan earned 250 total points
ID: 39285139
I'd choose like this

1) informatica
2) ESSBASE
0
 
LVL 1

Author Comment

by:CFMI
ID: 39285431
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
 
LVL 65

Accepted Solution

by:
Jim Horn earned 250 total points
ID: 39285474
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
 
LVL 1

Author Closing Comment

by:CFMI
ID: 39285513
Thank you!
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Help with SQL pivot 11 49
.XSN saves to .XML 3 25
SUBFORM on ACCESS 2013 8 33
MS Access 2016 resize forms 3 8
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question