SSIS Scalability
It is a scalable solution. I have around 800-900 users of the solution in our organization.
View full review »It can be very scalable both by adding memory or cores, and by running the SSIS on a farm of servers.
View full review »
It is scalable, although there may be some performance issues with very large volumes of data. In my department, around ten users utilize SSIS, but across the organization, it's used by various departments, including those handling webinars, data migration, and communication systems like Avaya.
View full review »Buyer's Guide
SSIS
March 2024
Learn what your peers think about SSIS. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,386 professionals have used our research since 2012.
There are six teams using the solution in our company.
View full review »It is scalable, and we haven't faced many issues. Sometimes, there are storage issues, but it is more of a DBA problem. We have a team in India and France and four people from the Eurofins team using this solution.
We have found this to be an easily scalable solution.
View full review »I'd rate the scalability four out of ten. The solution does not handle large amounts of data well. Azure Data Factory is much, much more scalable.
View full review »The scalability is pretty good. I'd rate the ability to expand at a seven out of ten.
There are only three of us using the solution at this time.
View full review »HÖ
reviewer2305518
Business Intelligence Architect at a financial services firm with 5,001-10,000 employees
I would recommend SSIS for both smaller and larger companies. We operate as a small to medium-sized enterprise with a considerable volume of data, around 30 to 40 terabytes in our data warehouse. Despite being an SME, SSIS has proven effective in handling our ETL processes seamlessly. If an organization has a similar data size, around the 30 to 40-terabyte range, SSIS can be a suitable and reliable choice for managing their data integration needs.
View full review »This solution is good for small-scale developments. We have approximately 80 people using the solution.
View full review »This is a very scalable product. You can expand easily.
We have 200 people using the solution. They are developers.
View full review »SSIS is not that scalable. You can scale it vertically to handle a high load, but it lacks horizontal scalability.
DM
Dominic Mackenzie
Data Architect at AMP Capital
SSIS scales well
View full review »VS
Vineth Suresh
Senior Associate at PwC Acceleration Centers
SSIS has proven itself in scalability for datasets.
We have more than 500 people using this solution in my organization.
View full review »The current scalability is ok and we have around seven to eight hundred users.
View full review »SR
Sérgio Rita
IT Manager at European University
The scalability is good.
We do not have a lot of users. The processes we do have run at night.
It's not about how many users use the solution, it's about how many people benefit from it. There are many that benefit from the output.
View full review »The scalability of SSIS is good.
We have approximately 10 users using this solution in my company.
View full review »AS
Azeezulla Sheriff
General Manager IT at a manufacturing company with 10,001+ employees
SSIS is scalable.
View full review »LD
Letarik Terefe
IT Project Management /Research & Development Team Leader at Ethiopian Roads Administration
The solution is scalable. It's not a problem to expand.
Currently, we are using it in the development environment, so we have around five users.
Increasing usage depends on the structure that we have. Let's say if the organization plans to increase the structure and the developer number, we might increase usage a bit. For the time being, five is enough.
View full review »SB
Sipho Ngubonde
Admin at IEC (Electoral Commission of South Africa)
SSIS is scalable.
View full review »TY
TarekYehia
Technical Consultant at LinkDev
We can scale the solution just fine.
It is our plan to increase usage in the future.
We have ten users on the solution right now.
View full review »There are three to four people in my company who use SSIS, and around twenty to thirty people are dashboard users.
We have never faced any significant issues as long as your underlying hardware has a good amount of resources.
Scalability depends on the kind of workload and implementation you are giving to SSIS.
It is best suited for small and medium. However, for enterprises, it depends on the specific implementation they require. Real-time scenarios might not be the best fit, but for batch processing, it can still be suitable.
I rate the solution’s scalability an eight out of ten. It essentially gives most of the small and medium use cases, you will be easily able to implement and scale SSIS.
View full review »SSIS is moderately scalable.
The company is fairly substantial. They have approximately 400,000 people in the company, but I am not aware of how many are using this solution. It is quite a bit.
There are a lot of developers using it.
I am not aware if they plan to increase their usage, it is not within my decision.
In terms of my immediate surroundings, we intend to use cloud tools, Azure technologies, and Microsoft. First and foremost, Microsoft ADF. Azure Data Factory is the cloud's SSIS replacement.
YY
reviewer1436226
Manager, Data & Intelligence Group, Technical at a consultancy with 10,001+ employees
The solution could be more scalable.
View full review »EL
reviewer928125
BI Architect at a retailer with 10,001+ employees
There are limitations. I wouldn't say that it is easy to scale. You can scale it, but I wouldn't say it can easily be done.
We have eight people who use this solution in our company.
View full review »MB
reviewer1656567
Project Lead Performance Engineer & Automation at a insurance company with 10,001+ employees
The solution is scalable. With virtualization enabled we are able to scale horizontally.
We have approximately 2,000 users using this solution in our company.
View full review »AN
Alireza Nikseresht
CEO at Shiraz University
The solution is scalable.
View full review »The solution is very scalable. We have approximately 25-30 users for the on-premises version, and our cloud version has around 5,000 users.
View full review »SSIS is a scalable solution.
View full review »We have problems with the ports for the analysis services. If everything is deployed, you need to redeploy. It's hard to scale out. If you plan to scale up, you need to prepare everything correctly from the start. Everything needs to be properly configured and deployed.
View full review »MJ
Muhammad Arif Javed
Senior Manager Software Development at Techlogix
Yes. It's very much scalable, but it all depends on how you design your solution. SSIS provides you extensive features and toolkit to handle all sort of data problems.
View full review »MG
Prodown567
Technical Product Owner, Team Lead at ARCA
The scalability of SSIS is very good. Right now, only I am using the solution, but we plan to increase usage in the future.
View full review »BD
Brian Dandeneau
Business Process and Strategy Specialist Advisor at NTTData
SSIS is good for smaller shops that don't really have a high volume of data.
View full review »MP
reviewer1194996
Senior Analyst at a tech services company with 1,001-5,000 employees
Almost 10 percent of our users work with SSIS. It's more than a hundred.
View full review »IS
Igor Smirnov
Director at Netica d.o.o.
The solution is very scalable. The amount of people that use SSIS from our end depends on the project, so it varies. We increase the usage of this product based on the projects that we get. Basically, each project that we do, we use this solution for integration purposes.
View full review »In the catalog, it's supposed to be scalable. I think that it has support for an SQL cluster.
In my opinion, I think it's a bit more limited in terms of scalability, although it scales with the database. I would say that the scalability is intermediate in terms of being able to launch multiple instances, or it could do load balancing as well. I think that would be a bit more challenging.
View full review »CG
ChitraGovindasamy
BI Consultant at a tech services company with 201-500 employees
We typically implement the solution for enterprise-size companies.
View full review »In terms of scalability, we haven't tried big data because in our enterprise we have to use Informatica to connect to the dedupe. I can't say how well it reads with the file, but we've never had an issue. However, I can't speak to scalability because we're never really, really big data.
View full review »If you want to scale SSIS, you might face performance issues. I'm not sure SSIS has robust scalability.
View full review »AS
AhmedShaban
Database Consultant
The solution is very scalable. A client contacted me two months after deployment with a request to enlarge the services and add some more customization, which I managed to do easily. It's an enterprise-level solution, with the whole of Saudi Arabia using it for something called an E-Visa. People are applying for a visa to get into Saudi Arabia through this application. The number of users is quite high and worldwide.
View full review »SA
Sherif Abdelrehim
Data Architect and Modeler at a tech services company with 201-500 employees
This solution is scalable.
The number of people I have using this solution depends on the size of the project. Normally, I need three to five ETL developers. Sometimes, if the project is big enough, then I will need more.
View full review »The scalability is fairly good. I've used it from very, very small instances to two very large ones, where we're moving large quantities of data on a daily basis.
The actual tool itself, in a sense of transformations, your ability to pick and look up and do certain things is fairly good. Scalability, you can either have it on the same server as the database or you can move it onto its own server. It just depends on the situation.
If you've got a heavy load on the database during the day and you're doing SSIS then you have the option to separate them. But as in our case, which is a data warehouse, you can keep them on the same server because you're getting a lot of your batch processes overnight. So, most of the resources are being used by SSIS. Then during the day, you have the users using the database server for reporting or data capture or data inserts and data updates.
Our users for this solution are primarily BI developers, and we have twenty to twenty-five of them, mostly offshore.
If we grow here then we'll need more SSIS servers, or we'll get bigger boxes. At the moment, I think that we're where we need to be, and I don't have any plans moving forward at this stage.
View full review »We have four customers that are using this product.
View full review »The solution is scalable. In the current use case, we have about 25 users of the solution.
View full review »I have not been restricted by this solution.
View full review »RH
RajeshHegde
Assistant Manager at a tech services company with 10,001+ employees
There were no scalability issues.
View full review »KS
KirillSlivchikov
Owner at 7Spring Consult
Right now we're working with Azure, and it's scalable, but it's expensive to do so. If we had features to scale the software part of the solution, it would be great.
View full review »JF
BIConsule1f7
BI Consultant at a tech services company with 201-500 employees
From personal experience, I really can't comment on the scalability, but from what I've seen online, and what I heard from other people is that it scales quite nicely.
View full review »There are approximately 10 users. At this time, there are no plans to increase usage.
View full review »Scalability not on the same level as with IBM Datastage.
View full review »ST
DevoSft67
Software Developer at a transportation company with 1,001-5,000 employees
Compared to other solutions, this solution is scalable.
We only have three users using this solution.
View full review »Buyer's Guide
SSIS
March 2024
Learn what your peers think about SSIS. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,386 professionals have used our research since 2012.