Click on Connections from within the dropdown menu in the top-right corner.
Once on the Connections page, click Add Connection.
Loome Integrate can connect to a number of cloud and on-premises data sources. You can filter this extensive list by typing the connection name you are looking for in the filter field. In this example, we will be connecting to a Microsoft SQL Server database.
To connect, Loome Integrate requires a connection string from the user. Strings can vary depending on connection type, but all share a similar structure. Loome Integrate has connection templates automatically generated for your source type.
You will need to update the template by replacing fields with any required information.
For example for a Microsoft SQL Server connection, the following standard template only requires your server address and your database name, as shown below.
Depending on the connector type, you may need to provide Loome Integrate your credentials in order to validate your connection.
Provide your credentials in the user name and password fields.
For example, in the case of Dynamics 365, the username is an email with its associated password. This would be the same credentials you use to log into Dynamics 365. (Dynamics 365 may also require additional security configuration details that are provided upon selecting the connection type.)
You can choose to provide your credentials via the connection string or the username and password fields.
You can then click Submit.
You can now create and run a task, such as a Data Migration task, using this connection.