Sync data from Azure Synapse to CitrusAd

Trusted by

Use Cases

Send new or update existing audiences in CitrusAd to run ads based on certain attributes within your database, such as people who have visited your site
Continuously fuel your CitrusAd custom audiences with live data so that data never goes stale‍
Build hyper-personalized campaigns based on the holistic view of your customers or leads in your data warehouse

How our customers activate their data

Don’t just keep your data locked in dashboards. Send your valuable data models like LTV, ARR & more to the tools your teams live in day-to-day so that together you can grow your business.

Step By Step Guide

Select the data you need from Azure Synapse
Write SQL directly, define the data you need in our Visual Audience Builder or import from existing tables and dbt models.
Choose CitrusAd from our catalog
Connect to CitrusAd with your credentials.
Manage Mappings
Configure the mappings that define how fields from your query should map to fields in the destination.
Set up a schedule and begin syncing data
Multiple basic and advanced scheduling options are available. Set up one of these and watch as data begins syncing!

By data teams, for data teams

No scripts. No APIs. Just SQL.

Don’t waste your time building custom integrations with each SaaS tool. Focus on building data models instead.

Leverage the Modern Stack

Use your existing dbt and Looker models. Trigger syncs with Airflow, dbt Cloud, Dagster, or by hitting our API.

Learn more

Observability and Alerting

Get alerted when syncs fail in Datadog, Pagerduty, & Slack. Then, use our live debugger which records all responses from API requests to fix errors.

Learn more

Version control with Git

Hightouch encourages engineering best practices by bi-directionally syncing all configuration changes with git.

Learn about Git Sync

Turn your warehouse into your CDP

Don't wait 6 months to implement a CDP. Hightouch turns your warehouse into a CDP so you can activate your data now and use flexible data models

Learn more

Learn more about our data engineering features

Why Hightouch

No Scripts. No APIs. No CSVs. Just SQL
Don’t waste your time building custom integrations for each of your SaaS tools. Activate your data instantly across all of your business tools.
Flexible Data Models
Build your data models once and reuse them anywhere. Leverage your data models in the warehouse, write SQL statements, or take advantage of your existing BI tools.
Self-Serve Audiences
Enable business teams to build custom audiences without SQL using a simple drag and drop interface leveraging the data models your team has already set in place.
Scale
Sync hundreds, thousands, or millions of rows from your warehouse without worrying about API failures or rate limits.
Deep Observability
Track changes using Git for version control and monitor your syncs in real-time using our debugger and alerts

About
Azure Synapse

Azure Synapse is an analytics database developed and marketed by Microsoft as part of its Azure cloud computing platform.

Learn more about Azure Synapse

About
CitrusAd

Learn more about CitrusAd

“Salesforce wasn’t built for product-led growth companies. The key to finding qualified leads across Zeplin’s millions of users is looking at product usage metrics. Without Hightouch, our account team is running blind.”

Andrew YipSales Operations @ Zeplin

“With Hightouch, we have confidence that we can get the data we need into HubSpot to run campaigns with fresh data to add that personal touch”

Jake LevingerMarketing Operations @ Retool

“The value is being able to pull in Salesforce, Marketo, Asana, NetSuite and Lever, and blend the data from historically separate departments together for analysis. With Hightouch we can then push it out to make sure that everyone's looking at the same metrics.”