Create a destination connection

To set up a SQL Server destination connection you need the following setup parameters for the SQL Server database.

• Server
• Database
• Schema
• Role

Check out Retrieving the SQL Server database parameters.

Follow these steps to create the SQL Server destination connection.

1. Define a new connection of type SQL Server.
2. Enter a descriptive name for the destination connection. For example SQLServer_IM.
3. Configure the Settings to connect to your SQL Server database using the SQL Server database setup credentials retrieved
   note

   Server must be specified as <Server>,<Port>.

   note

   User / Password must be the SQL credentials of the user that has permissions to write into the database. Check out Setting up a SQL Server account for data upload using an extractor. Password may not contain a semicolon ;.

4. Create and test the connection.