Skip to content

Instantly share code, notes, and snippets.

@cseidman
Last active January 24, 2018 14:57
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save cseidman/0403899cd81ad65c587d75b18e26bc56 to your computer and use it in GitHub Desktop.
Save cseidman/0403899cd81ad65c587d75b18e26bc56 to your computer and use it in GitHub Desktop.
registerSp.R
inputQry <- InputData("trainingDs",qry)
out <- OutputParameter("trained_model","raw")
sp <- StoredProcedure(
func=buildCustomerTree,
spName="buildCustomerTree",
dbName = "AdventureWorksDW2017",
InputData=inputQry,
OutputParameter=out
)
sqlServerConnString <- "Driver={SQL Server};SERVER=winrserver;DATABASE=AdventureWorksDW2017;UID=ruser;PWD=rpass"
isRegistered <- registerStoredProcedure(sp, sqlServerConnString)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment