Sync data from Microsoft SQL Server to Marketo

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

Activate your data in 3 easy steps

Step 1

Connect your source and destination

Connect to 25+ data sources, like Microsoft SQL Server, and 200+ destinations, like Marketo.

Step 2

Define your model

Use SQL or select an existing dbt or Looker model.

Step 3

Sync your data

Map your fields, set your sync schedule, and hit “Go!”

Email

Email

Name

Name

Total_orders

All_orders

Last_login

Last_login

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.

  Hightouch docsMarketo API

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

  Hightouch docsMarketo API

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

  Hightouch docsMarketo API

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

  Hightouch docsMarketo API

• Campaigns

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

  Hightouch docsMarketo API

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

• dbt model selector

  

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

• SQL editor

  

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

• Table selector

  

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

• Customer Studio

  

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

FAQs