Integrating SharePoint with outside data sources can be a difficult task. In the past I have had to build data connections in SharePoint Designer, build SQL Server Integration Services packages or custom .Net code. In my experience those solutions were difficult and time consuming to say the least.
Importing data using the Infowise Smart Import Pro tool takes that complexity out of importing data. With a connection string and some default fields you fill out a single page of configurations and you can pull data in from a wide variety of sources.
In this video I go through a step by step process of building a custom list and connecting it to a Microsoft Azure Cloud MSSQL database. I dive into structuring the custom list, what fields are required to make it work and how to validate your import is working correctly.