Try our new research platform with insights from 80,000+ expert users

SSIS vs Teradata comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Oct 6, 2024
 

Categories and Ranking

SSIS
Ranking in Data Integration
4th
Average Rating
7.8
Number of Reviews
71
Ranking in other categories
No ranking in other categories
Teradata
Ranking in Data Integration
17th
Average Rating
8.2
Number of Reviews
74
Ranking in other categories
Customer Experience Management (3rd), Backup and Recovery (20th), Relational Databases Tools (7th), Data Warehouse (3rd), BI (Business Intelligence) Tools (10th), Marketing Management (6th), Cloud Data Warehouse (6th)
 

Featured Reviews

Sakiru Dosumu - PeerSpot reviewer
Mar 1, 2024
Its ability to transform and transport data is extremely valuable
We use SSIS for data extraction, transformation, and loading processes. This includes extracting data from various sources like Oracle and SQL Server, and then transforming it for use in reporting tools like Power BI dashboards. While we haven't directly migrated data between databases using SSIS…
SurjitChoudhury - PeerSpot reviewer
Feb 20, 2024
Offers seamless integration capabilities and performance optimization features, including extensive indexing and advanced tuning capabilities
We created and constructed the warehouse. We used multiple loading processes like MultiLoad, FastLoad, and Teradata Pump. But those are loading processes, and Teradata is a powerful tool because if we consider older technologies, its architecture with nodes, virtual processes, and nodes is a unique concept. Later, other technologies like Informatica also adopted the concept of nodes from Informatica PowerCenter version 7.x. Previously, it was a client-server architecture, but later, it changed to the nodes concept. Like, we can have the database available 24/7, 365 days. If one node fails, other nodes can take care of it. Informatica adopted all those concepts when it changed its architecture. Even Oracle databases have since adapted their architecture to them. However, this particular Teradata company initially started with its own different type of architecture, which major companies later adopted. It has grown now, but initially, whatever query we sent it would be mapped into a particular component. After that, it goes to the virtual processor and down to the disk, where the actual physical data is loaded. So, in between, there's a map, which acts like a data dictionary. It also holds information about each piece of data, where it's loaded, and on which particular virtual processor or node the data resides. Because Teradata comes with a four-node architecture, or however many nodes we choose, the cost is determined by that initially. So, what type of data does each and every node hold? It's a shared-no architecture. So, whatever task is given to a virtual processor it will be processed. If there's a failure, then it will be taken care of by another virtual processor. Moreover, this solution has impacted the query time and data performance. In Teradata, there's a lot of joining, partitioning, and indexing of records. There are primary and secondary indexes, hash indexing, and other indexing processes. To improve query performance, we first analyze the query and tune it. If a join needs a secondary index, which plays a major role in filtering records, we might reconstruct that particular table with the secondary index. This tuning involves partitioning and indexing. We use these tools and technologies to fine-tune performance. When it comes to integration, tools like Informatica seamlessly connect with Teradata. We ensure the Teradata database is configured correctly in Informatica, including the proper hostname and properties for the load process. We didn't find any major complexity or issues with integration. But, these technologies are quite old now. With newer big data technologies, we've worked with a four-layer architecture, pulling data from Hadoop Lake to Teradata. We configure Teradata with the appropriate hostname and credentials, and use BTEQ queries to load data. Previously, we converted the data warehouse to a CLD model as per Teradata's standardized procedures, moving from an ETL to an EMT process. This allowed us to perform gap analysis on missing entities based on the model and retrieve them from the source system again. We found Teradata integration straightforward and compatible with other tools.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The most important features are it works well and provides self-service BI."
"It's saved time using visualization descriptions."
"The debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline."
"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."
"Data Flows are the main component we use. These can range from a simple source to sink ETL, to many source to many sink dataflows."
"There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information."
"The technical support is very good."
"The simplicity of the solution is great. The solution also offers excellent integration."
"The performance is great, we are able to query our data in one operation."
"The ease of deployment is useful so clients are up and running quickly in comparison to other products."
"I found all parts --loading, transformation, processing & querying work in parallel, and end-to-end-- to be valuable."
"There are several features of Teradata that I like. One of the most basic is the indexes. I also like that it provides lower TCO. It also has the optimizer feature which is a good feature and isn't found in other legacy systems. Parallelism is also another feature I like in Teradata because when you are running or hosting on multiple systems, you have this shared-nothing architecture that helps. Loading and unloading in Teradata are also really helpful compared to other systems."
"Teradata can be easily used in ETL mode transformations, so there is no need for expensive and inconvenient ETL tools"
"It has massive parallel processing ability to do large amounts of concurrent querying."
"Teradata's pretty fast."
"Teradata's most valuable feature is that it's easy to use."
 

Cons

"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."
"SSIS is cumbersome despite its drag-and-drop functionality. For example, let's say I have 50 tables with 30 columns. You need to set a data type for each column and table. That's around 1,500 objects. It gets unwieldy adding validation for every column. Previously, SSIS automatically detected the data type, but I think they removed this feature. It would automatically detect if it's an integer, primary key, or foreign key column. You had fewer problems building the model."
"The high prices attached to the product can be an area of concern where improvements are required."
"We're in the process of switching to Informatica, and we need to work out data lineage and data profiling and to improve the quality of our data. SSIS, however, is not that compatible with Informatica. We managed to connect it to Informatica Metadata Manager, but we don't get good lineage, so we have to redo all our ETLs using the Informatica process in order to accept the proper data lineage."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
"This solution needs full support for real-time processing."
"Sometimes, there are compatibility issues with some features. From time to time, I also face issues when trying to migrate. If I misconfigure things when I use Snapshot, the migration will fail.It can take a long time to migrate huge amounts of data, so it would be nice if that could be faster."
"Generic processes should be used instead of custom code for each table."
"Data ingestion is done via external utilities and not by the query language itself. It would be more convenient to have that functionality within its SQL dialect."
"They should add more connectors to different platforms."
"Teradata is an old data warehouse, and they're not improving in terms of new, innovative features."
"​I think the UI is not there yet. It could be improved by being more user-friendly.​"
"​The initial setup was complex as we had to rewrite a lot of the code.​"
"We tried to use case Teradata for a data warehouse system, but we had some problems in relation to the Teradata system, CDC tools, and source databases. We were unable to transfer data from HPE Integrity mainframe to Teradata."
"Limited interest and success in some areas make us hesitate about upgrading."
"Azure Synapse SQL has evolved from a solely dedicated support tool to a data lake. It can store data from multiple systems, not just traditional database management systems. On the other hand, Teradata has limitations in loading flat files or unstructured data directly into its warehouse. In Azure Synapse SQL, we can implement machine learning using Python scripts. Additionally, Azure Synapse SQL offers advanced analytical capabilities compared to Teradata. Teradata is also expensive."
 

Pricing and Cost Advice

"The solution comes free of cost."
"t's incredibly cost effective, easy to learn the basics quickly (although like all ETL tools requires the traditional learning curve to get good at) and has an immense user base."
"It would be beneficial if the solution had a less costly cloud offering."
"We have an enterprise license for this solution."
"People have to opt for a perpetual-based licensing model."
"SSIS is a cheaper option compared to the cost of other ETL tools."
"Based on my experience and understanding, Talend comes out to be a little bit expensive as compared to SSIS. The average cost of having Talend with Talend Management Console is around 72K per region, which is much higher than SSIS. SSIS works very well with Microsoft technologies, and if you have Microsoft technologies, it is not really expensive to have SSIS. If you have SQL Server, SSIS is free."
"I'm not involved in licensing details, but SSIS provides value to our organization by simplifying data management tasks."
"Teradata used to be expensive, but they have been lowering their prices."
"It's a very expensive product."
"The price needs to be more competitive as Hadoop, Redshift, Snowflake, etc are constantly making way into EDW space."
"The cost is significantly high."
"The price of Teradata is expensive. However, what they deliver they are outstanding. If you're looking for an inexpensive solution to run a database, this isn't your tool. It's the Ferrari of databases for data warehousing."
"The price of Teradata could be less expensive."
"I rate the product price a nine on a scale of one to ten, where one is cheap and ten is expensive."
"The price of Teradata is on the higher side, and I think that it where they lose out on some of their business."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
813,418 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
Feb 20, 2014
Informatica PowerCenter vs. Microsoft SSIS - each technology has its advantages but also have similarities
Technology has made it easier for businesses to organize and manipulate data to get a clearer picture of what’s going on with their business. Notably, ETL tools have made managing huge amounts of data significantly easier and faster, boosting many organizations’ business intelligence operations…
 

Top Industries

By visitors reading reviews
Financial Services Firm
17%
Computer Software Company
13%
Government
8%
Manufacturing Company
6%
Financial Services Firm
25%
Computer Software Company
11%
Manufacturing Company
8%
Healthcare Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

Which is better - SSIS or Informatica PowerCenter?
SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called SSIS. The collection helps organizations boost productivity with code-free compo...
What do you like most about SSIS?
The product's deployment phase is easy.
Comparing Teradata and Oracle Database, which product do you think is better and why?
I have spoken to my colleagues about this comparison and in our collective opinion, the reason why some people may declare Teradata better than Oracle is the pricing. Both solutions are quite simi...
Which companies use Teradata and who is it most suitable for?
Before my organization implemented this solution, we researched which big brands were using Teradata, so we knew if it would be compatible with our field. According to the product's site, the comp...
Is Teradata a difficult solution to work with?
Teradata is not a difficult product to work with, especially since they offer you technical support at all levels if you just ask. There are some features that may cause difficulties - for example,...
 

Comparisons

 

Also Known As

SQL Server Integration Services
IntelliFlex, Aster Data Map Reduce, , QueryGrid, Customer Interaction Manager, Digital Marketing Center, Data Mover, Data Stream Architecture
 

Overview

 

Sample Customers

1. Amazon.com 2. Bank of America 3. Capital One 4. Coca-Cola 5. Dell 6. E*TRADE 7. FedEx 8. Ford Motor Company 9. Google 10. Home Depot 11. IBM 12. Intel 13. JPMorgan Chase 14. Kraft Foods 15. Lockheed Martin 16. McDonald's 17. Microsoft 18. Morgan Stanley 19. Nike 20. Oracle 21. PepsiCo 22. Procter & Gamble 23. Prudential Financial 24. RBC Capital Markets 25. SAP 26. Siemens 27. Sony 28. Toyota 29. UnitedHealth Group 30. Visa 31. Walmart 32. Wells Fargo
Netflix
Find out what your peers are saying about Microsoft, Informatica, Talend and others in Data Integration. Updated: October 2024.
813,418 professionals have used our research since 2012.