Azure Synapse Analytics vs. Pipedrive

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.

Incentivized

Pipedrive is a fantastic tool to help monitor and track lead generation and referral sources. It helps maintain accountability with the sales team and helps ensure that we are doing appropriate marketing to maintain a steady influx of cases. The weekly and quarterly sales reports that it can generate are incredibly helpful and insightful. They help inform us of what we need to focus on each quarter/year.

Incentivized

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

Incentivized

• Great visual visibility of the funnel plus easy to drag the deals across the stages
• The email integration that collects all relevant communication (also through the possibility of adding a deal-specific Pipedrive address on BCC)
• The integration with Pandadoc, which we use a lot, so that Pipedrive keeps a really handy overview of the documents we have sent out / which have been signed

• 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

Incentivized

• Showing the customers name on the pipeline page. Right now I can only get it to show the brand name twice. I wish it would replace the second brand name with the main point of contact.
• Better reporting tools. Their reporting tools are not easy to pick up. I've spent time trying to figure it out and it isn't something I can pick up on quickly.
• Better training options. I wish I had a personal trainer to walk me through the best way to use Pipedrive so I can get the most out of it.

Incentivized

-2 for Its cost and +8 for the need of tracking of leads and monitoring of team.

Incentivized

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.

Incentivized

Pipedrive is easy to use and has a clean interface so we can follow up accurately. Its custom features help manage leads and evaluate team performance. It saves time and improves efficiency. Pipedrive is stable and supports integrations and automation.

Incentivized

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.

Incentivized

Between quick video tutorials and having very quick feedback from their support teams, it is one of the main reasons I would recommend Pipedrive. It is critical, especially when setting up the platform to meet your companies needs, that a solid support team like Pipedrive has is there to make the transition easier.

Incentivized

Experiment is the only way to start

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.

Incentivized

I much prefer the interface of Pipedive when compared to Zoho. Much more user friendly and the team is always readily available when we need them. Pipedrive allowed for many custom integrations to be added, as Zoho was a tad more complicated to manipulate. We would not go back to Zoho in any case.

Incentivized

Basically, the billing is predictable, and this all about it.

Incentivized

• 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

Incentivized

• Great on setup which made our work easier and less technically equipped people can manage a lot of things(compared to SalesForce where you need to hire a developer to set it up)
• We were able to integrate our calling system easily and get things going on the lead calling aspect.
• Great multipipeline option where we were able to manage both organisations under one roof.

Incentivized