# SQL Server

### Configuration

{% hint style="info" %}
You may need to whitelist the Dataimporter [IP Addresses](https://help.dataimporter.io/security/ip-addresses)
{% endhint %}

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

**Name**\
**Host**\
**Port**\
**Username**\
**Password**\
**Database**

![](https://2845823711-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FtvRVifvxmkDBmPKpGlr2%2Fuploads%2Fth4UOdHsvAR48sY930A9%2FNew%20Postgres.PNG?alt=media\&token=4920aabe-ddff-4c32-af5b-2ffea2cc4fef)

{% hint style="info" %}
Please ensure that these are all entered correctly when creating a connection.
{% endhint %}

### Import

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

<figure><img src="https://2845823711-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FtvRVifvxmkDBmPKpGlr2%2Fuploads%2FR5K48H96UmVbb3sm7sGr%2Fsql%20server%20upload.PNG?alt=media&#x26;token=3d902bbb-9bd7-4deb-8e67-947dfa0d48e4" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://2845823711-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FtvRVifvxmkDBmPKpGlr2%2Fuploads%2FlsExFaafkuCNTj6p787Q%2Fsql%20filter.PNG?alt=media&#x26;token=4d4c56d4-7434-4b84-9857-002b1056b51f" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
Column names should be in double quotes, and text values should be in single quotes.
{% endhint %}