Microsoft's Azure Data Factory is a service built for all data integration needs and skill levels. It is designed to allow the user to easily construct ETL and ELT processes code-free within the intuitive visual environment, or write one's own code. Visually integrate data sources using more than 80 natively built and maintenance-free connectors at no added cost. Focus on data—the serverless integration service does the rest.
N/A
Tricentis Tosca
Score 8.8 out of 10
N/A
Tricentis Tosca provides an approach to test
automation that is AI-powered, codeless, and end-to-end so it can test
everything in a complex IT landscape, to ensure business processes
work flawlessly no matter where changes occurs.
Its 160+ technology support helps users test everything at
the UI, API and data layer, including virtually any enterprise, custom,
homegrown and mobile application.
With its model-based approach, Tosca enables business,
QA and IT teams to…
Best scenario is for ETL process. The flexibility and connectivity is outstanding. For our environment, SAP data connectivity with Azure Data Factory offers very limited features compared to SAP Data Sphere. Due to the limited modelling capacity of the tool, we use Databricks for data modelling and cleaning. Usage of multiple tools could have been avoided if adf has modelling capabilities.
For projects having huge set of test cases to be automated can be accommodated by Tricentis Tosca with proper folder structure and best practices implementations. Tosca will be less appropriate for organizations where the number of automation scripts are limited with hardly any scope of increasing the script count or the cost of automation will be more than the cost of having manual resources as Tosca is a licensed tool.
Granularity of Errors: Sometimes, Azure Data Factory provides error messages that are too generic or vague for us, making it challenging to pinpoint the exact cause of a pipeline failure. Enhanced error messages with more actionable details would greatly assist us as users in debugging their pipelines.
Pipeline Design UI: In my experience, the visual interface for designing pipelines, especially when dealing with complex workflows or numerous activities, can become cluttered. I think a more intuitive and scalable design interface would improve usability. In my opinion, features like zoom, better alignment tools, or grouping capabilities could make managing intricate designs more manageable.
Native Support: While Azure Data Factory does support incremental data loads, in my experience, the setup can be somewhat manual and complex. I think native and more straightforward support for Change Data Capture, especially from popular databases, would simplify the process of capturing and processing only the changed data, making regular data updates more efficient
Documentation - struggled multiple times with features not explained very well, or not explained at all
The only support is on Tricentis Forums, where, sometimes, based on 'luck' - you will open a support case, and wait few days until you get the chance to speak with someone from Tricentis and show case your issue
We aim to renew Tosca for our organization. What we lose in license cost is gained by having employee that do not need programming background. We also recoup a lot of the cost on the rapidity of automation. Only the support we might not use as much. I believe Tosca is here to stay at our organization
So far product has performed as expected. We were noticing some performance issues, but they were largely Synapse related. This has led to a shift from Synapse to Databricks. Overall this has delayed our analytic platform. Once databricks becomes fully operational, Azure Data Factory will be critical to our environment and future success.
It can be a challenge for new users who have never used an automation tool. For example, it is hard to understand the layout of the screen and where to find how to update the data. The interface can be overwhelming at first.
We have not had need to engage with Microsoft much on Azure Data Factory, but they have been responsive and helpful when needed. This being said, we have not had a major emergency or outage requiring their intervention. The score of seven is a representation that they have done well for now, but have not proved out their support for a significant issue
Tricentis team was very supportive. Support is expensive but they helped us at many level. Setting up timeline, implementation, precise questions on automation challenges. We had an account manager and technical people we could as to talk to. Support was generally timely and helping. They often proposed to come on site to help us which would cost more but could be helpful
It would be better if the support is betterIt would be better if the support is betterIt would be better if the support is betterIt would be better if the support is betterIt would be better if the support is betterIt would be better if the support is betterIt would be better if the support is betterIt would be better if the support is betterIt would be better if the support is betterif the support is betterIt would be better if the support is betterIt would be better if the support is betterif the support is betterIt would be better if the support is betterIt would be better if the support is betterif the support is betterIt would be better if the support is betterIt would be better if the support is betterif the support is betterIt would be better if the support is betterIt would be better if the support is betterif the support is betterIt would be better if the support is betterIt would be better if the support is betterif the support is betterIt would be better if the support is betterIt would be better if the support is betterif the support is betterIt would be better if the support is betterIt would be better if the support is betterif the support is betterIt would be better if the support is betterIt would be better if the support is betterif the support is betterIt would be better if the support is betterIt would be better if the support is betterif the support is betterIt would be better if the support is betterIt would be better if the support is betterif the support is betterIt would be better if the support is betterIt would be better if the support is betterif the support is betterIt would be better if the support is betterIt would be better if the support is betterif the support is betterIt would be better if the support is betterIt would be better if the support is betterif the support is betterIt would be better if the support is betterIt would be better if the support is betterif the support is betterIt would be better if the support is betterIt would be better if the support is betterif the support is betterIt would be better if the support is betterIt would be better if the support is betterif the support is betterIt would be better if the support is betterIt would be better if the support is betterif the support is betterIt would be better if the support is betterIt would be better if the support is betterif the support is betterIt would be better if the support is betterIt would be better if the support is better
okIt would be better if the support is betterIt would be better if the support is betterIt would be better if the support is betterIt would be better if the support is betterIt would be better if the support is betterIt would be better if the support is betterIt would be better if the support is betterIt would be better if the support is betterIt would be better if the support is betterIt would be better if the support is better
Azure Data Factory helps us automate to schedule jobs as per customer demands to make ETL triggers when the need arises. Anyone can define the workflow with the Azure Data Factory UI designer tool and easily test the systems. It helped us automate the same workflow with programming languages like Python or automation tools like ansible. Numerous options for connectivity be it a database or storage account helps us move data transfer to the cloud or on-premise systems.
Tricentis Tosca is codeless and therefore easier to use. It's a great tool for people that would start doing automation and have no coding background. It seems like it has the same capabilities as other test automation suites but I felt it lacked a bit of capabilities on the test management suite such as defects test suites organizations etc
It really had a very good impact on our ROI. We were able to automate most of the apps and layers with in it and get a very short execution time which led to increased releases with in short span of time.
Time to market really improved and efficiency of developing scripts was not too bad.
With built in test dashboards, it was easy to pull metrics and share the insights with management.
