Azure Databricks vs. OpenText Magellan

Suppose you have multiple data sources and you want to bring the data into one place, transform it and make it into a data model. Azure Databricks is a perfectly suited solution for this. Leverage spark JDBC or any external cloud based tool (ADG, AWS Glue) to bring the data into a cloud storage. From there, Azure Databricks can handle everything. The data can be ingested by Azure Databricks into a 3 Layer architecture based on the delta lake tables. The first layer, raw layer, has the raw as is data from source. The enrich layer, acts as the cleaning and filtering layer to clean the data at an individual table level. The gold layer, is the final layer responsible for a data model. This acts as the serving layer for BI For BI needs, if you need simple dashboards, you can leverage Azure Databricks BI to create them with a simple click! For complex dashboards, just like any sql db, you can hook it with a simple JDBC string to any external BI tool.

Incentivized

It depends on extensibility, set-up, access & style. Actuate performs fairly well, but has performance issues because it sits on top of eclipse, which sits on top of Java. Extensibility usually comes at that price. Set-up is fairly straightforward and it can be secured.

Incentivized

• Unity Catalog
• Data Federation in Lakehouse Architecture
• Integration of Mosaic AI in the SQL Layer

Incentivized

• Ability to connect to different kinds of sources, including web services, and customize those queries to the extend needed
• Provide tools to customize the look & feel of the reports as much as needed, even being able to choose different appearances for different outputs
• Allowing scripting in the reports extends the functionality available
• Allowing to embed reports without further licensing and maintaining all the functionality

Incentivized

• Their pipeline workflow orchestration is pretty primitive. Lacks some common features
• Workspace UI and navigation requires steep learning curve
• Personally, I am not fond of their autosave feature. Its dangerous for production level notebooks scripts

Incentivized

• Report rendering can take a long time for large reports (250,000+ pages) - we run these in batch over night
• The deployment of production code from development to test to production enviroments can be complex due to the number of components that must compile

Incentivized

I am no longer working for the company that was using Actuate but I believe they would continue to use it because the stitching costs would be to high. It would require a complete rewrite of the reports and the never version of Actuate (BIRT) even required an almost complete report rewrite

Incentivized

Great for what we use day to day and does what we need it to do. Cost management is not fully developed across the UX and gets expensive very quickly for developing projects. Integrated very well with our Microsoft stack and can be worked on collaboratively which works well for us.

Incentivized

It is quite intuitive to use. It is fit specifically for doing sentiment, emotion, and intention analysis as well as text classification and text summarization. I would have given 10 if it is fit for the purpose of doing image processing and analysis as well. There is a huge market to analyze video and image data.

Incentivized

Always there on the front and backend for us and the client.

I have found Azure Databricks to be much better than Snowflake for handling bigger, diverse data types. Snowflake is much simpler and better for smaller warehousing. The real time processing is much better in Azure Databricks and we have much more language options. Snowflake is more expensive but simpler to use. Both are great for different needs.

Incentivized

It is vastly superior to these in many ways, for complex reporting it is a much more sophisticated solution. Visualizations are very good. Javascript extensibility is very powerful, others don't support this or as well. Pentaho and MS are both OLAP oriented. Pentaho is moving more toward big data, which was not our primary focus. Others are stuck in the Crystal Reports Band metaphor.

• Helped reduce time for collecting data
• Reduced cost in maintaining multiple data sources
• Access for multiple users and management of users/data in a single platform

Incentivized

• Actuate can handle 50 to 60 sub reports inside a report very well.
• Dynamically creating the datasource, chart, graph, reports are the main advantages. We can do any level of drilling, and can create a performance matrix dashboard efficiently.