Likelihood to Recommend - great when you need to integrate applications without any message lost or duplicated and when transnationality is important - if you need the highest throughput possible and not much (or not at all) mapping is required, a system like Kafka is more appropriate
Read full review 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 Just the ability to display and consume data through a single dashboard makes this a great application for our business purposes. With the ability to consume their exposed API, data validation and manipulation becomes a breeze. Read full review 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 The development and the transformation capability is not so great. I believe IBM is looking to incorporate some of features of IBM APP Connect into API Connect. The authentications features are no way close to CA API Management (f.k.a Laye r7). The development experience is not as good as Apigee's. The GUI should be improved. Maybe the product team should see the other API management tools in their offering. Read full review 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 It is the best on-premise application to cloud integration in the market. I guess IBM is planning to integrate IBM App Connect with the IBM API Connect solution.
Read full review 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 You can do some really powerful things with this system. The overall design is an attempt to make configurable some of the routine tasks/common functionality, but allow for development/customization of the core of the application.
Read full review 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 It worked as expected.
Read full review Support Rating Support is good, however it takes longer than expected to get responses. When bugs are reported they often seem to fall into a black hole.
Read full review 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 We did not select Cast Iron as our iPaaS solution, it was the weakest competitor in the field that we evaluated. Our experience was that it was not nearly as easy to learn, without in-depth training and guidance, and the developer UI was extremely buggy. We subjected each of the vendors to a battery of integrations, from simple to challenging, and it fell short on each one. One of the most simple integrations was grabbing a CSV file from an FTP source, parsing the data, doing a small amount of transformation, then inserting that data into an Azure MSSQL DB. After 2 hours on the phone with the Cast Iron support team, we were still unable to get this working.
Read full review 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 I don't see any negative Impact . I like using this tool to do my job. I am comfortable using this tool. Read full review 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