Search documentation...

K

SQL Server

Power internal tools, in-app experiences, and more

Setup

There are two available options to connect to your SQL server database when creating the destination.

Required Permissions

Both setup options require:

  • Server name (IP address or Azure hostname)
  • Port number (1433 by default)
  • Database name
  • SQL Server Username
  • SQL Server Password

Your credentials must be able to:

  • Add/update/delete rows in your sync's table.
  • View these tables: (*These are used for gathering metadata to set up the sync.)
    • INFORMATION_SCHEMA.COLUMNS
    • INFORMATION_SCHEMA.TABLE_CONSTRAINTS
    • INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE
    • SYS.COLUMNS

To ensure your credentials are correct, click "Test connection". This will confirm if Hightouch is able to properly connect to your database by running a simple SELECT query.

Password Form

Connection String

Connection string must be in this format: Server=server;Database=database;User Id=username;Password=password;Encrypt=boolean

If you see the following error message, you need to update your firewall settings in your Azure Console.

Syncing

Hightouch supports Upsert mode with the option to delete removed rows.

Select the schema and table you want to sync to. A common schema to use is the database's default, dbo.

Record Matching

Records can be matched from your source to your database table by any primary key or unique columns shown in the dropdown.

Note: We do not display identity columns as those cannot be edited or set when inserting.

Field Mapping

Select the fields from your source that you want to sync to Sql Server.

Make sure you account for column types and columns that are non-nullable. If you upsert any row with the wrong column type or set a null value for a non-nullable column, the entire batch with that row (up to 1k rows) will fail.

    Need help?

    Our team is relentlessly focused on your success. We're ready to jump on a call to help unblock you.

    • Connection issues with your data warehouse?
    • Confusing API responses from destination systems?
    • Unsupported destination objects or modes?
    • Help with complex SQL queries?

    Feature Requests?

    If you see something that's missing from our app, let us know and we'll work with you to build it!

    We want to hear your suggestions for new sources, destinations, and other features that would help you activate your data.

On this page

SetupRequired PermissionsPassword FormConnection StringSyncingRecord MatchingField Mapping

Was this page helpful?