Azure Synapse Analytics is described as the former Azure SQL Data Warehouse, evolved, and as a limitless analytics service that brings together enterprise data warehousing and Big Data analytics. It gives users the freedom to query data using either serverless or provisioned resources, at scale. Azure Synapse brings these two worlds together with a unified experience to ingest, prepare, manage, and serve data for immediate BI and machine learning needs.
$4,700
per month 5000 Synapse Commit Units (SCUs)
HubSpot CRM
Score 8.3 out of 10
N/A
HubSpot’s CRM enables growth-minded businesses to optimize their relationships with leads and customers. Through harnessing the power of carefully crafted sales, marketing, customer service, content management, and operations tools, the software aims to make it easy to unify team strategy and drive conversion. Additionally, the software allows users to connect with over 875 integration apps, APIs, and solutions partners to create a customizable user experience that suits the way teams work.…
It's well suited for large, fastly growing, and frequently changing data warehouses (e.g., in startups). It's also suited for companies that want a single, relatively easy-to-use, centralized cloud service for all their data needs. Larger, more structured organizations could still benefit from this service by using Synapse Dedicated SQL Pools, knowing that costs will be much higher than other solutions. I think this product is not suited for smaller, simpler workloads (where an Azure SQL Database and a Data Factory could be enough) or very large scenarios, where it may be better to build custom infrastructure.
I am giving it a 9 rating out of 10 because it has saved my job and helped my team to cracks very big deals. Last year, we were supposed to give a presentation to a client as we were about to sign him for a project. The client asked for our numbers in a real meeting, but we hadn't prepared them for our presentation. I logged in to HubSpot CRM and created a small report that included the relevant numbers. This turned out to be a very good decision for our company, as we subsequently signed that client.
Quick to return data. Queries in a SQL data warehouse architecture tend to return data much more quickly than a OLTP setup. Especially with columnar indexes.
Ability to manage extremely large SQL tables. Our databases contain billions of records. This would be unwieldy without a proper SQL datawarehouse
Backup and replication. Because we're already using SQL, moving the data to a datawarehouse makes it easier to manage as our users are already familiar with SQL.
Timeline view and conversation log is extremely helpful and an underrated feature; this is in addition to the entire user profile view.
Task management is simple but effective.
Deal and company tracking with stakeholder management inside companies / deals is very handy; we know what is happening even though we might not be directly working on it.
Gmail integration is quite smooth along with email tracking.
With Azure, it's always the same issue, too many moving parts doing similar things with no specialisation. ADF, Fabric Data Factory and Synapse pipeline serve the same purpose. Same goes for Fabric Warehouse and Synapse SQL pools.
Could do better with serverless workloads considering the competition from databricks and its own fabric warehouse
Synapse pipelines is a replica of Azure Data Factory with no tight integration with Synapse and to a surprise, with missing features from ADF. Integration of warehouse can be improved with in environment ETl tools
More of an integration issue I think than a problem with HubSpot CRM, but we have AirCall integrated for direct phone lines and synching with individual users for outbound calls. Opening Aircall to make an outbound call automatically generates a new client - unattached to a company record as an orphan.
Historical records with activities is awesome but when creating a deal it isn't always a choice to capture last 30 days of history. When it is an option and you click to add that to a deal you can see all the activity items and people who have done anything with the "file".
I would like to see more native options for automation.
Thus far, our company has found HubSpot CRM to be a reliable service that serves its purpose well: a centralized business contacts database, accessible remotely, with a simple and visually-pleasing interface. Issues are non-existent or resolved quickly, and when the service is experiencing interruptions, notifications and/or updates are sent regularly.
The data warehouse portion is very much like old style on-prem SQL server, so most SQL skills one has mastered carry over easily. Azure Data Factory has an easy drag and drop system which allows quick building of pipelines with minimal coding. The Spark portion is the only really complex portion, but if there's an in-house python expert, then the Spark portion is also quiet useable.
I am giving it this rating because it has helped us keep track of leads, it saved us a lot of time by automating tasks, and it makes it easy for different teams to work together. It is user-friendly and has improved our approach to communicating with customers and closing deals.
Microsoft does its best to support Synapse. More and more articles are being added to the documentation, providing more useful information on best utilizing its features. The examples provided work well for basic knowledge, but more complex examples should be added to further assist in discovering the vast abilities that the system has.
Because when I needed help HubSpot responded immediately and provided me with the information I needed which enabled me to realize that HubSpot was even more customizable and easier to use than I thought! And I already thought HubSpot was very user friendly and easy to use, and then Support showed me how to manipulate the settings, columns and the appearance of the tool.
If you've had any prior experience with cloud based marketing automation or group communication tools, you can do the implementation without paid outside support. Though getting to a SLA (service level agreement) would be best achieved with the help of a third party who can facilitate
In comparing Azure Synapse to the Google BigQuery - the biggest highlight that I'd like to bring forward is Azure Synapse SQL leverages a scale-out architecture in order to distribute computational processing of data across multiple nodes whereas Google BigQuery only takes into account computation and storage.
We've been using Hubspot for years and don't foresee making any changes away from it. It has been fully integrated into how our business operates. We ultimately selected HubSpot CRM because it had all the features and functions that our marketing, sales, and operations teams wanted. And it offered those features and functions at the right price point for our organization.
Licensing fees is replaced with Azure subscription fee. No big saving there
More visibility into the Azure usage and cost
It can be used a hot storage and old data can be archived to data lake. Real time data integration is possible via external tables and Microsoft Power BI
