December 28, 2017 at 9:12 am
Hallo
I would like to know if and how I could import into an Azure SQL Database pulling data from an on-premises SQL Server via a Microsoft Data Gateway.
Do I need to use something like Microsoft Flow or Azure Data Factory?
Thanks in advance
*UPDATE*
I'll need to feed the Azure Database from many different on-premises SQL Databases from different customers, whose IPs could possibly change over time and in non-predictable ways (switching over backup connections, changes of infrastructure, etc).
Hence in the Azure SQL Database configuration, I could not register all the possible IPs.
So I am looking for a solution to *pull* data more than to *push* it.
January 10, 2018 at 2:16 am
Have you tried using SSIS?
SSIS has a lot of Azure components and will do what you are asking quite easily.
Data Factory will as well, ,not sure about Flow as I have never used it.
You certainly have a choice
Natalie
January 10, 2018 at 2:35 am
LittleKitten - Wednesday, January 10, 2018 2:16 AMHave you tried using SSIS?
SSIS has a lot of Azure components and will do what you are asking quite easily.
Data Factory will as well, ,not sure about Flow as I have never used it.
You certainly have a choiceNatalie
Thank you LittleKitten, SSIS would have been my first choice, but I omitted that I was looking for something that didn't require to open many endpoints on the Azure SQL Database. I'm updating the original post.
January 10, 2018 at 4:54 am
Have you looked into resolving through DNS rather than IP? Azure DNS?
January 10, 2018 at 6:57 am
LittleKitten - Wednesday, January 10, 2018 4:54 AMHave you looked into resolving through DNS rather than IP? Azure DNS?
Hallo, these IPs don't have DNS entries and I cannot the customers to register DNS.
I am investigating into Data Factory
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy