SAS Data Management Review

For the amount of features that we use, the licensing is expensive.


Valuable Features

The main purpose for buying this product was to give our business users that have technical skills a tool where they can easily build jobs/queries against our DWH. The interface for building these jobs is very user friendly and the learning curve for using it is very good.

Improvements to My Organization

By having our business users using this product, they became more independent and the amount of requests that they issue for the technical team is considerably lower.

Room for Improvement

For the amount of features that we use, the licensing is expensive.

Although the interface is very user friendly, there are a few options that are hidden inside the jobs properties and the users have difficulty understanding and finding them. The user guide doesn’t provide all the information needed.

Another point is regarding the database connections. These connections must be independently set in each client and server. This type of definition should be centralized.

Use of Solution

DataFlux dfPower Studio 8.2

DataFlux Data Integration Server 8.2

Deployment Issues

Deployment was very smooth. The only issue encountered was regarding the email configuration. The installation guide didn’t have much information and our firewall was blocking the mails.

Stability Issues

No. After deploying the product and after an initial period of testing to find the correct configuration properties, everything runs smoothly.

Scalability Issues

  • In the server, from time to time, depending of the type of job the users submit to the server, we have to increase the amount of memory in the server. However, we have a limited number of users that can deploy jobs to the server.
  • The desktop client, when running a job, consumes resources of the client machine and of the database being accessed. This being said, the scalability depends of the user machine and database where the information is stored.
  • Like many others tools that provide the same functionality, in order to perform the required analysis, the data must be transferred to the product and this step consumes time (network) and resources (memory and cpu). When the amount of data is very large (millions) the amount of time and resources is considerable high so the way to go is to analyze data samples and extrapolate from there.

Customer Service and Technical Support

Customer Service: After becoming a SAS Company the customer service has improved.Technical Support: From our experience, the technical support has room for improvement. There aren’t many experts using this tool and the knowledge base that we find online and in the SAS forums is very small.

Previous Solutions

Previously our business users would have to write complex SQL or issue requests to the technical team in order to get the information needed. They find it much easier using the Dataflux product to access the information stored in the database for the type of analyses they have to do on day to day basis.

Initial Setup

The installation is very straightforward. Installing is not complex but the initial setup could take some time. There aren’t any guidelines or wizards that we can follow in order to find the best configuration based on infrastructure.

Implementation Team

It was in-house. The vendor team was a proxy for getting support from DataFlux company.

ROI

SAS Integration and explore the standardization capabilities.

Other Advice

If they are looking for a profiling and data quality tool you should consider Dataflux. However you should do a trial first to understand which features are useful and if those compensate the costly licensing.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Add a Comment
Guest
Sign Up with Email