How to export Azure machine learning service results into Azure SQL DW? -


i have 3 problems relating azure machine learning service. appreciate if can give me directions or related reference.

(1) regarding result of computation of machine learning, can export sql data warehouse in azure ? format ? can join result existed table in sql db ? exact process ?

i have searched related information [deploy web-service], , found similar issue. however, little confused relationship between web-service , azure sql data warehouse.

[deploy web-service] https://azure.microsoft.com/en-us/documentation/articles/machine-learning-walkthrough-5-publish-web-service/

(2) if need result in machine learning outer sources (ex: outer lpo service), how connect outer source ?

(3) if need connect azure sql data warehouse outer sources, correct need set firewall , offer server address, id , pd , , can connect outer source ?

anticipating response , feedback.

let me try , answer questions.

(1) in order write machine learning output azure sql data warehouse, use 'export data' module (previously known 'writer' module). choose azure sql database option , enter connection string , credentials connect data warehouse. since sql data warehouse sql db underneath covers, both have same format connection string. caution write data data warehouse if you're performing batch execution. recommended approach not stream data azure sql data warehouse, since not transactional store, but, rather analytical store. so, write data data warehouse azureml if use batch execution scoring data. if you're using request/response method, encourage write data sql db , use azure data factory write data sql data warehouse (this lets pause warehouse when it's not in use, saving money).

(2) can please elaborate on this? trying here? if you're trying bring external data azure ml, there multiple ways of doing so.
       (a) azureml natively supports rss data feed , web url via http loads.
       (b) alternatively, use azure data factory or azure functions load data azure blob storage , import data azureml there (azureml natively supports connection blob storage)

(3) yes, if service isn't first-class support paas service in azure, need whitelist ip address of service before can communicate data warehouse (this done security reasons). in order programmatically this, first create service principle in azure active directory , use service principle credentials authenticate azure. here's link create service principle external application: https://azure.microsoft.com/en-us/documentation/articles/resource-group-create-service-principal-portal/.

once authenticated, can use link programmatically add ip address: https://azure.microsoft.com/en-us/documentation/articles/sql-database-firewall-configure/#programmatically-managing-firewall-rules there rest api documentation might started. in order keep database secure, give application static ip address , manually whitelist ip address, ensuring there isn't unauthorized access.

i hope helps! please let me know if have questions!


-

Comments

Post a Comment

Popular posts from this blog

PySide and Qt Properties: Connecting signals from Python to QML -

i trying run simple pyside appliccation design made in qml. call function in qml python in separated thread. i have following qml view: import qt 4.7 rectangle { visible: true width: 100; height: 100 color: "lightgrey" text { id: datestr objectname: "datestr" x: 10 y: 10 text: "init text" font.pixelsize: 12 function updatedata(text) { datestr.text = qstr(text) console.log("you said: " + text) } } } here application: some imports.... #!/usr/bin/python import sys import time pyside import qtdeclarative, qtcore pyside.qtgui import qapplication pyside.qtdeclarative import qdeclarativeview the qthread worker.... #worker thread class worker(qtcore.qthread): updateprogress = qtcore.signal(int) def __init__(self, child): qtcore.qthread.__init__(self) self.child = child def run(self):
Read more

c# - DevExpress.Wpf.Grid.InfiniteGridSizeException was unhandled -

Image
when using devexpress, see error: devexpress.wpf.grid.infinitegridsizeexception unhandled message="by default, infinite grid height not allowed since grid rows rendered , hence grid work slowly. fix issue, should place grid container give finite height grid, or should manually specify grid's height or maxheight. note can avoid exception setting gridcontrol.allowinfinitegridsize static property true, in case grid run slowly." the problem dxgrid has infinite height. to fix, set height non-infinite. snoop absolutely invaluable this: if "height" xaml element infinite (i.e. 0 or nan ), can set using one of following: option 1: height="{binding path=actualheight, relativesource={relativesource mode=findancestor, ancestortype=uielement}}" option 2: verticalalignment="stretch" option 3: height="auto" hint: use verticalalignment="stretch" if child of grid <rowdefinition height=
Read more

scala - 'wrong top statement declaration' when using slick in IntelliJ -

Image
i'm porting project scala 2.9 2.10, therefore have use slick instead of scalaquery. i'm using slick 2.1.0 since supports ms access. according this tutorial , upgrade guide changed robs object class , added val robs : why error message wrong top statement declaration , how rid of it? edit: i'm new scala... according this question seems can't put val outside of methods or classes, right? code above directly in packge. right approach slick then? should move code in class or trait? according this changed val robs = tablequery[robs] to object robs extends tablequery(new robs(_)) {} . no warnings or errors anymore. :)
Read more