On-premises data in the cloud without migration the database

In this session I will build a secure link between a on-premises SQL Server and Azure, without migrating the database. Azure has a solution for sharing data from on-premises data sources to the cloud: the on-premises data gateway, in short OPDG, but what is it? The OPDG acts as a bridge between data that isn’t in the cloud and several Microsoft cloud services. The data will be available in Azure via an Azure data service (Table Storage, Azure Cosmos DB, Azure SQL). Besides the OPDG, this session will cover the configuration of an Azure Logic App (integration platform as a service (iPaaS)) for connecting the OPDG data to the Azure Data Service. Topics: - Introduction OPDG The OPDG acts as a bridge between data that isn’t in the cloud and several Microsoft cloud services. With this gateway, you can keep using the local SQL Server database while the data is securely available in the Azure cloud. - Cost and availability of the ODPG - Setting up an OPDG in Azure - Configuring a OPDG on the on-premises network and computer - Azure Logic App (store) With Azure Logic Apps we can create a workflow to process the data available through the ODPG into an Azure data source BONUS - Azure Logic App (consume) Storing the data in the cloud is only one part, now we have to make it available for others to use it. Creating a simple REST API service by using only the Azure portal.