Compare Informatica PowerCenter and Microsoft SQL Server 
At a Glance
Market Segments
Enterprise (78.2% of reviews)
Enterprise (45.5% of reviews)
Entry-Level Pricing
No pricing available
No pricing available
Informatica PowerCenter
Star Rating
(88)4.3 out of 5
Market Segments
Enterprise (78.2% of reviews)
Pros & Cons
Entry-Level Pricing
No pricing available
Learn more about Informatica PowerCenterMicrosoft SQL Server
Star Rating
(2,261)4.4 out of 5
Market Segments
Enterprise (45.5% of reviews)
Pros & Cons
Entry-Level Pricing
No pricing available
Learn more about Microsoft SQL ServerSummary
AI Generated Summary
AI-generated. Powered by real user reviews.
- G2 reviewers report that Microsoft SQL Server excels in user experience, particularly for beginners. Users appreciate its intuitive interface in SQL Server Management Studio (SSMS) and straightforward implementation process, making it easy to navigate and set up.
- According to verified reviews, Microsoft SQL Server stands out for its robust performance and reliability. Users highlight features like the 'Always On' capability, which enhances database durability and application performance by effectively managing read and write operations.
- Users say that Informatica PowerCenter is a strong contender in the ETL space, known for its robustness and scalability. Reviewers commend its ability to handle a wide range of data sources and transformations, making it a versatile tool for data integration tasks.
- Reviewers mention that while Informatica PowerCenter has been a staple in the industry for over 30 years, it faces challenges in user-friendliness compared to Microsoft SQL Server. Some users find it less intuitive, despite its powerful mapping tools and extensive connector options.
- G2 reviewers highlight that Microsoft SQL Server integrates seamlessly with other Microsoft tools, enhancing its overall functionality for users who rely on a Microsoft ecosystem. This integration is a significant advantage for organizations already using Microsoft products.
- According to recent user feedback, while both products receive similar star ratings, Microsoft SQL Server's higher G2 Score reflects greater overall satisfaction among users, particularly in areas like ease of use and setup, which are crucial for day-to-day operations.
Pricing
Entry-Level Pricing
Informatica PowerCenter
No pricing availableMicrosoft SQL Server
No pricing availableFree Trial
Informatica PowerCenter
No trial information availableMicrosoft SQL Server
No trial information availableRatings
Meets Requirements
8.7
68
9.0
1,854
Ease of Use
8.1
68
8.6
1,870
Ease of Setup
7.5
36
8.1
992
Ease of Admin
7.9
33
8.3
950
Quality of Support
8.5
64
8.3
1,649
Has the product been a good partner in doing business?
8.1
32
8.4
900
Product Direction (% positive)
9.1
62
8.4
1,825
Features by Category
Administration
9.0
12
Not enough data
8.2
12
Not enough data
9.2
12
Not enough data
Federation
8.9
12
Not enough data
8.5
11
Not enough data
8.5
10
Not enough data
8.3
11
Not enough data
Transformation
9.2
12
Not enough data
8.8
12
Not enough data
8.8
12
Not enough data
Management
8.9
19
Not enough data
8.6
15
Not enough data
Functionality
9.3
20
Not enough data
9.2
20
Not enough data
9.3
20
Not enough data
8.6
20
Not enough data
8.8
18
Not enough data
Functionality
8.8
10
Not enough data
9.1
13
Not enough data
9.0
13
Not enough data
8.8
13
Not enough data
8.8
12
Not enough data
8.9
12
Not enough data
8.9
11
Not enough data
8.5
11
Not enough data
Management
Not enough data
8.9
153
Not enough data
8.8
153
Not enough data
9.2
158
Not enough data
8.9
153
Not enough data
8.9
156
Maintenance
Not enough data
8.9
154
Not enough data
9.0
159
Not enough data
9.0
154
Security
Not enough data
8.9
153
Not enough data
9.1
155
Management
Not enough data
9.0
149
Not enough data
9.2
151
Not enough data
8.8
137
Not enough data
8.8
142
Support
Not enough data
8.6
145
Not enough data
9.0
149
Not enough data
8.6
144
Not enough data
8.4
151
Security
Not enough data
8.8
148
Not enough data
9.0
148
Not enough data
8.8
145
Not enough data
9.0
149
Performance
Not enough data
8.7
144
Not enough data
8.8
141
Not enough data
8.7
147
Not enough data
8.6
145
Not enough data
8.8
146
Database Features
Not enough data
8.9
1287
Not enough data
9.0
1291
Not enough data
8.9
1299
Not enough data
8.7
1266
Not enough data
8.8
1267
Not enough data
8.8
1271
Not enough data
9.1
1291
Database
Not enough data
8.5
56
Not enough data
8.8
57
Not enough data
8.4
54
Integrations
Not enough data
7.8
45
Not enough data
8.2
45
Platform
Not enough data
8.2
50
Not enough data
8.5
53
Not enough data
8.2
45
Processing
Not enough data
8.5
52
Not enough data
8.5
55
Building Reports
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Platform
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Categories
Categories
Shared Categories
Informatica PowerCenter and Microsoft SQL Server are categorized as On-Premise Data Integration
Unique Categories
Microsoft SQL Server is categorized as Relational Databases, Database Management Systems (DBMS), and Big Data Processing and Distribution
Reviews
Reviewers' Company Size
Informatica PowerCenter
Small-Business(50 or fewer emp.)
Mid-Market(51-1000 emp.)
Enterprise(> 1000 emp.)
Microsoft SQL Server
Small-Business(50 or fewer emp.)
Mid-Market(51-1000 emp.)
Enterprise(> 1000 emp.)
Small-Business
(50 or fewer emp.)
Mid-Market
(51-1000 emp.)
Enterprise
(> 1000 emp.)
Reviewers' Industry
Information Technology and Services
35.9%
Insurance
7.7%
Banking
6.4%
Financial Services
6.4%
Computer Software
5.1%
Other
38.5%
Information Technology and Services
24.1%
Computer Software
13.7%
Hospital & Health Care
5.4%
Financial Services
4.3%
Higher Education
2.9%
Other
49.6%
Alternatives
Discussions
What is Informatica PowerCenter used for?
1 Comment
GS
Informatica PowerCenter is widely used by organizations to integrate and manage data from multiple sources into one central system. It helps transform raw...Read more
Informatica PowerCenter has no more discussions with answers
How could I make much easier the experience with the order of my database?
4 Comments
AF
You can create different tables with your employee information eg employee table, employee roles etc. Then you can create a single view that will pull data...Read more
What is the best way to save your queries?
4 Comments
CA
I recommend that you use the saved querys in plain text or .sql or txt format you can use the same sql server query creator or a notepad +++ tool, they are...Read more
How can I work on the same query if the connection is lost (timeout) and then I reconnect?
4 Comments
JE
When this happens to me in SQL Server Management Studio, I just have to type USE {your database name here} and then select only that statement and execute...Read more
Hunting for software insights?
With over 3 million reviews, we can provide the specific details that help you make an informed software buying decision for your business. Finding the right product is important, let us help.
