Domo vs. SQL Server Integration Services

Domo is great when you want to see lots of values historically or see data you can see natively in a platform. As I mentioned earlier, Domo is the only way our Marketing and Sales teams can see when their emails were opened and compare the send time - this is an example of data I can't see natively.

Incentivized

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.

Incentivized

• Provides data acquisition, transformation and visualization all administered from one cloud-based tool. No switching between tools or cobbling different products together.
• Provides GUI and MySQL interfaces for data manipulation for both entry-level and advanced users.
• Huge amount of data connectors out of the box, plus you can easily create your own custom connectors.

Incentivized

• SSIS works very well pulling well-defined data into SQL Server from a wide variety of data sources.
• It comes free with the SQL Server so it is hard not to consider using it providing you have a team who is trained and experienced using SSIS.
• When SSIS doesn't have exactly what you need you can use C# or VBA to extend its functionality.

Incentivized

• When changing cards from one dataset to another any beast modes are not carried over, it would often make life easier if there was an easier way to copy beast mode calculations from one dataset to another.
• Domo documentation, university and Dojo are extremely helpful when we run into problems. However, when support beyond that is needed their help desk seems to have a hefty backlog - the amount of time to resolve tickets is frustrating sometimes.

Incentivized

• SSIS memory usage can be quite high particularly when SSI and SQL server are on the same machine
• SSIS is not available on any environment other than Microsoft Windows
• SSIS does not function with any database engine back-end other than Microsoft SQL Server

Incentivized

Domo is a great up-and-coming product. There are many fantastic features that are extremely compelling to our end users, which makes Domo a great fit for our organization. As with many BI tools, there are items on the wish list that could make implementation, administration and usage easier, but I believe these will be addressed over time as the product matures and evolves. The overall concept and approach of this solution has definitely raised the bar in this area of expertise and I would like to see things advance in giving the enterprise tools that will make decision making easier and more robust in the future.

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.

Incentivized

A business management platform has to be flexible to provide solutions for customers from any business environment, but that flexibility has to be delivered without requiring complex business process re-engineering and massive data conversion efforts. Domo’s web-based architecture and wealth of connectivity options allow rapid setup for any business. If your marketing company is wrestling with channel return on investment or your educational organization is drowning in data, Domo has the tools and capability to use your data and turn it into something useful for you

Incentivized

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).

Incentivized

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.

Incentivized

Pretty responsive. It took a while to get a response in selecting data points for our particular cards. Might have taken about a month? I am not sure if this was something on our end or Domo's end. But haven't had any other issues yet that required additional support from Domo.

Incentivized

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.

Incentivized

It is a true web-based application so implementation is much easier and smoother compared to other non-web based BI solutions. Also, they offered consulting services during the implementation process, which was helpful. Also, they provided lots of on-demand training courses and videos, which I liked.

Incentivized

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

Incentivized

Domo is by far the industry leader. Other tools/platforms have unique strengths, but from an overall perspective, Domo is the most versatile and does an exceptional job in all areas. This is critical when it comes to "scale". A BI project may start with a siloed scope, but as the project bares fruit, others begin to ask how they can participate/leverage the tool/platform for their own projects - because of this, Domo's versatility is incredibly important

Incentivized

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

Incentivized

• Domo has allowed us to see much more clearly what is working for students on our programs, and what is not. This enables us to consolidate success and further develop where there are areas of concern.
• The verbatim comments in Domo makes the reports especially attractive to staff, since they are able to engage directly with students' personal opinions and not just with rating scales.

Incentivized

• 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.

Incentivized