Help Center
  • Home
  • Getting Started
    • Register with oAuth
    • Register with Email + Password
  • Formulas
    • Formulas
  • Migration Templates
    • Migration Templates
    • Setting up the Template
    • Magic ID
    • Running the Template
  • seeding
    • Summary
    • Data Types
    • Configuration
  • Jobs
    • Job Management
    • Migrate
    • Multi-Object
    • Upload
    • Mapping
    • Query
    • Preview
    • History
    • Retry
    • Rollback
    • Run Remaining
    • Wildcard Names
  • Formatting
    • Dataimporter Formatting
    • Replace Null Values
    • Deduplicate
    • Filter Data
    • Sample Data
    • Automation Control
  • Schedule
    • Schedule
    • Hour
    • Day
    • Month
    • Flow
  • Integrations
    • View Integrations
    • Database
      • Azure SQL Database
      • Heroku Postgres
      • MySQL
      • PostgreSQL
      • SQL Server
    • Storage
      • Dropbox
      • Google Drive
      • Google Sheets
      • OneDrive
      • S3
      • SFTP
      • SharePoint
  • Account Management
    • Billing
    • Access
    • Teams
    • Notifications
  • Security
    • Dataimporter Security
    • IP Addresses
    • Data Storage
    • Customer Managed Storage
    • Single Sign-On with Azure AD
    • Single Sign-On with Okta
    • Bring your own Key
  • Changelog
Powered by GitBook
On this page
  • Configuration
  • Import
  • Filtering
  1. Integrations
  2. Database

SQL Server

PreviousPostgreSQLNextStorage

Last updated 2 years ago

Configuration

You may need to whitelist the Dataimporter

You will need to enter the following information to create a MySQL Integration:

Name Host Port Username Password Database

Please ensure that these are all entered correctly when creating a connection.

Import

On the Upload screen, you will select which Table you want to Extract, and which Salesforce Object you want to Import into.

Filtering

On the Clean screen, you will be able to add an SQL Filter, to only Select the records you need as part of the Extraction.

Column names should be in double quotes, and text values should be in single quotes.

IP Addresses