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