Integrate.io’s platform allows organizations to integrate, process, and prepare data for analytics on the cloud. By providing a coding and jargon-free environment, Integrate.io’s scalable platform ensures businesses can benefit from the opportunities offered by big data without having to invest in hardware, software, or related personnel. With Integrate.io, every company can have immediate connectivity to a variety of data stores and out-of-the-box data transformation components.
N/A
SSIS
Score 6.5 out of 10
N/A
Microsoft's SQL Server Integration Services (SSIS) is a data integration solution.
N/A
Pricing
Integrate.io
SQL Server Integration Services
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
Integrate.io
SSIS
Free Trial
No
No
Free/Freemium Version
No
No
Premium Consulting/Integration Services
No
No
Entry-level Setup Fee
No setup fee
No setup fee
Additional Details
—
—
More Pricing Information
Community Pulse
Integrate.io
SQL Server Integration Services
Features
Integrate.io
SQL Server Integration Services
Data Source Connection
Comparison of Data Source Connection features of Product A and Product B
Integrate.io
8.2
Ratings
2% below category average
SQL Server Integration Services
7.5
Ratings
11% below category average
Connect to traditional data sources
8.50 Ratings
8.80 Ratings
Connecto to Big Data and NoSQL
8.00 Ratings
6.20 Ratings
Data Transformations
Comparison of Data Transformations features of Product A and Product B
Integrate.io
8.8
Ratings
8% above category average
SQL Server Integration Services
8.1
Ratings
1% below category average
Simple transformations
9.50 Ratings
8.50 Ratings
Complex transformations
8.00 Ratings
7.70 Ratings
Data Modeling
Comparison of Data Modeling features of Product A and Product B
Integrate.io
9.0
Ratings
12% above category average
SQL Server Integration Services
7.4
Ratings
7% below category average
Data model creation
9.50 Ratings
8.60 Ratings
Metadata management
8.00 Ratings
7.10 Ratings
Business rules and workflow
9.00 Ratings
8.20 Ratings
Collaboration
9.00 Ratings
7.30 Ratings
Testing and debugging
9.50 Ratings
6.10 Ratings
Data Governance
Comparison of Data Governance features of Product A and Product B
Xplenty is really well suited to gather information from many different sources. So if you are in an envitoment with lots of different IT-systems and you want to get an overview and collect data Xplenty can do this really well. It’s required for you to have some technical knowledge about setting up the software.
Ideal for daily standard ETL use cases whether the data is sourced from / transferred to the native connectors (like SQL Server) or FTP. Best if the company uses MS suite of tools. There are better options in the market for chaining tasks where you want a custom flow of executions depending on the outcome of each process or if you want advanced functionality like API connections, etc.
SSIS is responsible for running core business processed managing core business data. It can be managed, improved and expanded using minimal internal resources. It is also able to support all of our current data infrastructure. Replacing SSIS would be time consuming and costly with no apparent ROI.
SSIS has a drag and drop based developer interface, so it is relatively straight forward to get started. You can start to get into the weeds pretty quickly as your solution becomes more complex. However, most of the base functions are right in front of you for a developer. You can also set project and solution level parameters, so when you deploy to new environments, you don't have to jump into each package to change your variables and settings. (For example, default directory to ingest flat files).
Raw performance is great. At times, depending on the machine you are using for development, the IDE can have issues. Deploying projects is very easy and the tool set they give you to monitor jobs out of the box is decent. If you do very much with it you will have to write into your projects performance tracking though.
The support, when necessary, is excellent. But beyond that, it is very rarely necessary because the user community is so large, vibrant and knowledgable, a simple Google query or forum question can answer almost everything you want to know. You can also get prewritten script tasks with a variety of functionality that saves a lot of time.
The implementation may be different in each case, it is important to properly analyze all the existing infrastructure to understand the kind of work needed, the type of software used and the compatibility between these, the features that you want to exploit, to understand what is possible and which ones require integration with third-party tools
Integrate.io is the first platform with a complete set of tools and connectors for data-driven decision making. In addition, it connects the web apps use every day to save time, automate tasks, and focus on what matters most. In just a few minutes, you can set up automated workflows using thousands of the most popular web apps—no code required.
I think SQL Server Integration Services is better suited for on-premises data movement and ADF is more suited for the cloud. Though ADF has more connectors, SQL Server Integration Services is more robust and has better functionality just because it has been around much longer
Without this, we would have to manually update a spreadsheet of our SQL Server inventory
We would also have poor alerting; if an instance was down we wouldn't know until it was reported by a user
We only have one other person who uses SQL Server Integration Services , he's the expert. It would fall to me without him and I would not enjoy being responsible for it.
