CData Sync vs. IBM InfoSphere Information Server vs. SAS Data Management

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
CData Sync
Score 7.0 out of 10
N/A
CData's Sync is a data pipeline tool able to connect data sources to the user's database or data warehouse, supporting at present over 200 possible sources, and a range of destinations (e.g. Snowflake, S3, Redshift), connecting on-premise or SaaS sources and destinations.N/A
IBM InfoSphere Information Server
Score 8.0 out of 10
N/A
IBM InfoSphere Information Server is a data integration platform used to understand, cleanse, monitor and transform data. The offerings provide massively parallel processing (MPP) capabilities.N/A
SAS Data Management
Score 8.0 out of 10
N/A
A suite of solutions for data connectivity, enhanced transformations and robust governance. Solutions provide a unified view of data with access to data across databases, data warehouses and data lakes. Connects with cloud platforms, on-premises systems and multicloud data sources.N/A
Pricing
CData SyncIBM InfoSphere Information ServerSAS Data Management
Editions & Modules
No answers on this topic
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
CData SyncIBM InfoSphere Information ServerSAS Data Management
Free Trial
NoNoNo
Free/Freemium Version
NoNoNo
Premium Consulting/Integration Services
NoNoNo
Entry-level Setup FeeNo setup feeNo setup feeNo setup fee
Additional Details
More Pricing Information
Community Pulse
CData SyncIBM InfoSphere Information ServerSAS Data Management
Features
CData SyncIBM InfoSphere Information ServerSAS Data Management
Data Source Connection
Comparison of Data Source Connection features of Product A and Product B
CData Sync
8.0
1 Ratings
3% below category average
IBM InfoSphere Information Server
8.7
4 Ratings
5% above category average
SAS Data Management
8.3
10 Ratings
0% above category average
Connect to traditional data sources8.01 Ratings9.94 Ratings8.610 Ratings
Connecto to Big Data and NoSQL00 Ratings7.54 Ratings8.19 Ratings
Data Modeling
Comparison of Data Modeling features of Product A and Product B
CData Sync
7.5
1 Ratings
5% below category average
IBM InfoSphere Information Server
8.0
4 Ratings
2% above category average
SAS Data Management
6.7
8 Ratings
16% below category average
Collaboration8.01 Ratings8.04 Ratings7.07 Ratings
Testing and debugging7.01 Ratings7.14 Ratings6.17 Ratings
Data model creation00 Ratings8.72 Ratings5.56 Ratings
Metadata management00 Ratings7.74 Ratings7.47 Ratings
Business rules and workflow00 Ratings8.44 Ratings6.67 Ratings
Data Transformations
Comparison of Data Transformations features of Product A and Product B
CData Sync
-
Ratings
IBM InfoSphere Information Server
9.6
4 Ratings
16% above category average
SAS Data Management
6.7
8 Ratings
19% below category average
Simple transformations00 Ratings10.04 Ratings6.18 Ratings
Complex transformations00 Ratings9.24 Ratings7.48 Ratings
Data Governance
Comparison of Data Governance features of Product A and Product B
CData Sync
-
Ratings
IBM InfoSphere Information Server
9.7
4 Ratings
19% above category average
SAS Data Management
7.9
9 Ratings
1% below category average
Integration with data quality tools00 Ratings10.04 Ratings7.69 Ratings
Integration with MDM tools00 Ratings9.53 Ratings8.27 Ratings
Best Alternatives
CData SyncIBM InfoSphere Information ServerSAS Data Management
Small Businesses
Skyvia
Skyvia
Score 10.0 out of 10
Skyvia
Skyvia
Score 10.0 out of 10
Skyvia
Skyvia
Score 10.0 out of 10
Medium-sized Companies
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
dbt
dbt
Score 9.0 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
Enterprises
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
InterSystems IRIS
InterSystems IRIS
Score 8.0 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
All AlternativesView all alternativesView all alternativesView all alternatives
User Ratings
CData SyncIBM InfoSphere Information ServerSAS Data Management
Likelihood to Recommend
8.0
(1 ratings)
8.9
(5 ratings)
7.6
(11 ratings)
Likelihood to Renew
-
(0 ratings)
8.0
(1 ratings)
9.0
(2 ratings)
Usability
-
(0 ratings)
-
(0 ratings)
6.0
(2 ratings)
Performance
-
(0 ratings)
-
(0 ratings)
9.0
(1 ratings)
Support Rating
-
(0 ratings)
-
(0 ratings)
7.7
(6 ratings)
User Testimonials
CData SyncIBM InfoSphere Information ServerSAS Data Management
Likelihood to Recommend
CData Software
Evidently, CData Sync is an excellent middleware tool that is perfect for syncing data between systems. It is especially suitable and works well on SQL servers, DB2, MySQL, and Snowflake, and some of their brothering domains. However, it is a limitation in working with Sage 50 API. But if it is extracted with ODBC, it works well.
Read full review
IBM
Information Server is extremely useful to replace manual developments that require a lot of coding effort. It significantly increases the productivity of the initial development and the future maintenance of the processes since it has a visual development environment with self-documentation.
Read full review
SAS
When data is in a system that needs a complex transformation to be usable for an average user. Such tasks as data residing in systems that have very different connection speeds. It can be integrated and used together after passing through the SAS Data Integration Studio removing timing issues from the users' worries. A part that is perhaps less appropriate is getting users who are not familiar with the source data to set up the load processes.
Read full review
Pros
CData Software
  • UPSERT
  • Friendly interface
Read full review
IBM
  • IIS best for ETL ,not ELT , and many and diffrent source systems.
  • It also can process big data , unstuctured data
  • It is not only DWH , you can use infosphere for analys and see the bigger architecture of your OLTP systems
Read full review
SAS
  • SAS/Access is great for manipulating large and complex databases.
  • SAS/Access makes it easy to format reports and graphics from your data.
  • Data Management and data storage using the Hadoop environment in SAS/Access allows for rapid analysis and simple programming language for all your data needs.
Read full review
Cons
CData Software
  • Although efficient for SQL servers and MySQL, as well as Snowflake. It is not strong for other database engines, and an upgrade on this would do a lot.
  • The installation process is manual as opposed to the cloud installation it should be.
  • A feature of syncing auto increment ID key, that will help in existing data management.
Read full review
IBM
  • I would be nice to have a new web development environment for DataStage.
  • Connectivity Packs such as Pack for SAP Application are a little pricey.
  • It is confusing for new developers the possibility of developing jobs using different execution engines such as Parallel or Server.
Read full review
SAS
  • Requires third-party drivers to connect to common data sources like SFDC, MS SQL, Postgres.
  • Debugging errors from the logs is a complicated process.
  • E-mail alert system is very primitive and needs customization to make it more modern,
  • Cannot send SMS alerts for jobs.
Read full review
Likelihood to Renew
CData Software
No answers on this topic
IBM
  • Scale of implementation
  • IBM techsupport
Read full review
SAS
We are happy with the software and its functionality. As a SAS-shop, DataFlux is a logical choice for complex data integration.
Read full review
Usability
CData Software
It is easy to setup and use
Read full review
IBM
No answers on this topic
SAS
The main negative point is the use of a non-standard language for customizations, as well as the poor integration with non-SAS systems. However, there is no doubt that it is a high-performance and powerful product capable of responding optimally to certain requirements.
Read full review
Performance
CData Software
No answers on this topic
IBM
No answers on this topic
SAS
It worked as expected.
Read full review
Support Rating
CData Software
No answers on this topic
IBM
No answers on this topic
SAS
With SAS, you pay a license fee annually to use this product. Support is incredible. You get what you pay for, whether it's SAS forums on the SAS support site, technical support tickets via email or phone calls, or example documentation. It's not open source. It's documented thoroughly, and it works.
Read full review
Alternatives Considered
CData Software
Tableau is another similar software tool, unlike CData Sync, rather transforms data into actionable insights. While CData Sync works with automation, Tableau uses a drag box on its AVA, which in turn slows the work speed on the syncing of data. Over the years, I enjoyed the friendly and customizable option of CData Sync over Tableau's.
Read full review
IBM
DataStage is more robust and stable than ODI The ability to perform complex transformations or implement business rules is much more developed in DS
Read full review
SAS
Because of ease of using SAS DI and data processing speed. There were lots of issues with AWS Redshift on cloud environment in terms of making connections with the data sources and while fetching the data we need to write complex queries.
Read full review
Return on Investment
CData Software
  • Positive: Easy way to bring data for our DWH
  • Negative: Frequent issue in CData Sync Server
Read full review
IBM
  • Productivity of the development of integration processes.
  • Better documentation and governance.
  • Reduce training costs of various technologies.
Read full review
SAS
  • We have more users who can connect to the many different data sources.
  • Our users do have existing SAS programming knowledge and that can carry over.
  • Business functions are starting to rely on SAS Data Integration Studio work product shortly after introduction.
Read full review
ScreenShots