I have 2-3 source systems which are on-prem databases. I am planning to use Logic Apps to connect to these source systems. As per the Azure documentation we need to install a On-Prem Gateway on a local computer. I am skeptical of this methodology as it demands dedicated system, so not sure if this works in actual production scenario. Please can you suggest what is the right way to do it.
On-prem SQL Server to Azure
115 Views Asked by user15364835 At
1
There are 1 best solutions below
Related Questions in AZURE-LOGIC-APPS
- Logic Apps and long running Azure Function (Powershell)
- logiapp teams api connection terraform user sign in
- Logic App Function App reading and writing Binary Files
- String to Array via expressions
- How to set up the link for the paginated files in the Get Rows(V2) Logic App connector and pass it via Azure API call?
- How to prevent o365 API connection from becoming invalidated from expired access token when using azure logic apps send email action
- Logic App to check the Azure blob container for new files and send email notification
- Logic app to list the subscriptions under my management group and list them one per row, with tag values as columns
- How to read agent application data to azure sql using apim and logic apps
- Liquid Template - How to map JSON object as a string to output field
- Automate file uploading from Sharepoint to Azure Storage Container
- Enabling minimum apiVersion to 2021-08-01 in Azure API Management causing saving issues or deployment errors for existing logic apps
- Logic app blob trigger retry policy not working for 503 error
- Logic Apps: selecting the first element of an array
- How to extract all the Document Libraries and Page libraries from a SharePoint site with logic App
Related Questions in ONPREMISES-GATEWAY
- On premises gateway PowerBI Service
- On-premises data gateway - Power BI
- Power Automate SQL Server Email
- use on premise gateway to connect to local file system. gateway doesnt appears in creating connection
- Bad Gateway - Azure Logic App - Invoke an Http Request
- How do I access on-prem sql server from Azure Logic App (using on-prem data gateway) and a Gmsa?
- PowerApps Unable to save data to table
- AWS springboot application endpoints not accessible
- Configuring Power BI dataset connection to Cloud PostgreSQL database
- How to connect ODBC source to on-premises data gateway in power bi server?
- how to create a window service using java?
- How to use Active Directory based authentication in Power BI Service to query data as per user's entitlements from AWS Athena
- Power BI scheduled update to AWS RDS
- Rename a Power BI On Prem Data Gateway
- PowerBi Gateway Issues
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Here is how to connect to on-premise data sources:
If the services are accessible over the internet then you call service endpoint over HTTP or HTTPS from azure logic apps. This article will help you with details steps to be followed: https://learn.microsoft.com/en-us/azure/connectors/connectors-native-http
If it is not accessible over the internet then this article will help with step by step process: https://learn.microsoft.com/en-us/azure/logic-apps/logic-apps-gateway-connection
Before you can access data sources on premises from your logic apps, you need to create an Azure resource after you install the on-premises data gateway on a local computer. Your logic apps then use this Azure gateway resource in the triggers and actions provided by the on-premises connectors that are available for Azure Logic Apps.
Also check this for reference.
You may also want to consider the costs.