SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SFTP File Import To SQL Azure DB


SFTP File Import To SQL Azure DB

Author
Message
pmcpherson
pmcpherson
SSC Veteran
SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)

Group: General Forum Members
Points: 249 Visits: 479
Hi and thanks for helping.
I have a database in the Azure Cloud, it is a SQL database as a service (PaaS).
I have a client that stores files that I have to collect daily, on their premises, via SFTP.
In an on-premise solution, I would store encrypted connection information in a table, query it to create batch files in secured NTFS folders, execute the batch files to get the .csv files local, then delete the batch files, and update log tables.
Then I would use T SQL commands to bulk insert the contents of the files to their respective tables.
It is not the best solution, but it gets the job done.

How do I change this flow to work with SQL Azure (PaaS)?
Since it is PaaS, I don't have the SQL Agent or Jobs.
I found Azure Automation which I can use to get info from our Azure FTP server, but not one with a different Active Directory service (unless I am reading the documentation wrong).

Surely somebody else has done this already!
Please, help.
Also, I am new to Azure period, and will likely need click though examples of how to setup any middle pieces.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search