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

See 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. See also Setting up a SQL Server account for data upload using an extractor. Password may not contain a semicolon ;.
4. Create and test the connection.