Skip to main content

Sync data from SQL Server to Marketo

Connect your data from SQL Server to Marketo with Hightouch. No APIs, no months-long implementations, and no CSV files. Just your data synced forever.

Get started

The world’s most innovative companies choose Hightouch as their Composable CDP

Spotify.
Warner Music Group.
PetSmart.
WeightWatchers.
Ramp.
Calendly.
GitLab.
Grammarly.
Spotify.
Aritzia.
Warner Music Group.
PetSmart.
Tripadvisor.
GameStop.
Cars.com.
WeightWatchers.
Iterable.
Ramp.
Plaid.
Calendly.
GitLab.
Malwarebytes.
Greenhouse.
Grammarly.

Activate your data in 3 easy steps

An illustration showing logos of various sources connecting to destination logos.

Connect to 35+ data sources, like SQL Server, and 200+ destinations, like Marketo.
An illustration showing logos of various sources connecting to destination logos.

Use cases

Sync data from SQL Server to Marketo

  • Sync data about users and accounts into Marketo to build hyper-personalized campaigns
  • Keep your Marketo account updated with fresh data from your warehouse
  • Deliver a unified experience by bringing in data from other customer touchpoints into Marketo
Hightouch Audiences user interface.

What Marketo objects can you sync to?

  • Leads

    The Marketo Lead’s API provides a large set of capabilities for simple CRUD applications against lead records, as well as the ability to modify a lead’s membership in static lists and programs, and initiate Smart Campaign processing for leads.

  • Companies

    Companies represent the organization to which lead records belong. Leads are added to a Company by populating their corresponding externalCompanyId field using Sync Leads or Bulk Lead Import endpoints.

  • Opportunities

    Marketo exposes APIs for reading, writing, creating and updating opportunity records. In Marketo, opportunity records are linked to lead and contact records through the intermediate Opportunity Role object, so an opportunity may be linked to many individual leads.

  • Custom Activities

    Custom activities help you track an activity that isn’t related to a Marketo form, email, or landing page. Want to track when someone deposits a check? Use a custom activity. Want to keep tabs on when someone attends a webinar? Use a custom activity.

  • Static lists

    Static lists are one of the most simple and useful features of Marketo. They are simply a list of names from your Database. You will find plenty of reasons to use them.

  • Campaigns

    Hightouch allows you to trigger campaigns through Marketo Campaign API with records in your model.

What methods can I use to model my SQL Server data?

  • Semi-opaque, open dropdown with three example dbt model names such as 'dbt.model.name.1'.

    dbt model selector

    Sync directly with your dbt models saved in a git repository.

  • SQL editor.

    SQL editor

    Create and Edit SQL from your browser. Hightouch supports SQL native to SQL Server.

  • Semi-opaque open dropdown with three example table names such as 'schema.table.name.1'.

    Table selector

    Select available tables and sheets from SQL Server and sync using existing views without having to write SQL.

  • Visual query builder reading 'All rows that...' with a button labeled 'select a property'.

    Customer Studio

    For less technical users, pass traits and audiences from SQL Server using our visual segmentation builder.

FAQs

Other SQL Server integrations

Other Marketo integrations