Microsoft SQL Server


Microsoft SQL Server is a relational database management system developed by Microsoft. Its primary function is storing and retrieving data as requested by other software applications.

Reference: .

Connection String

To Connect to Microsoft SQL server, set the Server and Database Properties. Additionally, set the Integrated Security Property.

Connection String Parameter

Parameter Description
Data Source Set this to the hostname of the Server of the Microsoft SQL server.
Initial Catalog Set this to the database Name in the specified Microsoft SQL server.
Integrated Security Set this to authenticate with Using Windows authentication.

Connecting to Microsoft SQL Server

  1. Set the hostname of the server as the ‘Data Source’ parameter on your connection string. If the server is on premise server, it will just be a server label.

  2. Next is the ‘Initial Catalog’ parameter. This narrows down the connection to a single database in the server. In SQL Server Management Studio, your options will be contained in the ‘databases’ directory.

  3. Set the Integrated Security property to SSPI. We want an encrypted connection over the network. If there is a security breach, the loss will not include your authentication credentials. Set the ‘Encrypt’ parameter to ‘True’.

  4. Set the login credentials for the server. Set the UserName and Password.

Data Migrations

To Check for the data migrations:

  1. Add a new connection in Loome Integrate as shown.

    • Go to tasks and click on Connections.

    • Add a new connection Using Add New Connection Option.

    • Choose Microsoft SQL Connector from the available Connector Options.




  5. Choose a Data Migration Task.


