SQL Server

Configuration

You may need to whitelist the Dataimporter IP Addresses

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.

Last updated