Skip to main content
Log inGet a demo

Sync data from Microsoft SQL Server to Marketo

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

Get started

Your favorite companies use Hightouch to sync data securely at scale.Our customers

Spotify.
NBA.
PetSmart.
Weight Watchers.
Ramp.
Calendly.
GitLab.
Grammarly.
Spotify.
Betterment.
NBA.
PetSmart.
Tripadvisor.
GameStop.
Cars.com.
Weight Watchers.
Iterable.
Ramp.
Plaid.
Calendly.
GitLab.
Malwarebytes.
Greenhouse.
Grammarly.

Activate your data in 3 easy steps

Logos of sources connecting to destination logos.

Use cases

Sync data from Microsoft 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.

    Hightouch docsMarketo API
  • 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 Microsoft SQL Server data?

  • dbt model selector

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

    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 Microsoft SQL Server.

  • Table selector

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

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

  • Customer Studio

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

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

FAQs

Other Microsoft SQL Server integrations

Microsoft SQL Server to Acoustic

Other Marketo integrations

Activate your data in less than 5 minutes