Example Stream: Deploy Model

Once you are satisfied with the accuracy of the model, you can deploy it for use with external applications or for publishing back to the database. In the final example stream, 5_deploy_model.str, data is read from the table CREDIT and then scored and published to the table CREDITSCORES using a Database Export node.

Running the stream generates the following SQL:

DROP TABLE CREDITSCORES

CREATE TABLE CREDITSCORES ( "field1" varchar(1),"field2" varchar(255),"field3" f
loat,"field4" varchar(1),"field5" varchar(2),"field6" varchar(2),"field7" varcha
r(2),"field8" float,"field9" varchar(1),"field10" varchar(1),"field11" int,"fiel
d12" varchar(1),"field13" varchar(1),"field14" int,"field15" int,"field16" varch
ar(1),"KEY" int,"$M-field16" varchar(9),"$MC-field16" float )

INSERT INTO CREDITSCORES ("field1","field2","field3","field4","field5","field6","field7","field8",
"field9","field10","field11","field12","field13","field14","field15","field16",
"KEY","$M-field16","$MC-field16") 
SELECT T0.C0 AS C0,T0.C1 AS C1,T0.C2 AS C2,T0.C3 AS C3,T0.C4 AS C4,T0.C5 AS C5,
	T0.C6 AS C6,T0.C7 AS C7,T0.C8 AS C8,T0.C9 AS C9,T0.C10 AS C10,
	T0.C11 AS C11,T0.C12 AS C12,T0.C13 AS C13,T0.C14 AS C14,
	T0.C15 AS C15,T0.C16 AS C16,T0.C17 AS C17,T0.C18 AS C18
FROM (
	SELECT CONVERT(NVARCHAR,[TA].[field1])  AS C0, CONVERT(NVARCHAR,[TA].[field2])  AS C1, 
		[TA].[field3] AS C2, CONVERT(NVARCHAR,[TA].[field4])  AS C3, 
		CONVERT(NVARCHAR,[TA].[field5])  AS C4, CONVERT(NVARCHAR,[TA].[field6]) AS C5,
		CONVERT(NVARCHAR,[TA].[field7])  AS C6, [TA].[field8] AS C7, 
		CONVERT(NVARCHAR,[TA].[field9])  AS C8, CONVERT(NVARCHAR,[TA].[field10])  AS C9, 
		[TA].[field11] AS C10, CONVERT(NVARCHAR,[TA].[field12])  AS C11, 
		CONVERT(NVARCHAR,[TA].[field13])  AS C12, [TA].[field14] AS C13, 
		[TA].[field15] AS C14, CONVERT(NVARCHAR,[TA].[field16])  AS C15, 
		[TA].[KEY] AS C16, CONVERT(NVARCHAR,[TA].[$M-field16])  AS C17, 
		[TA].[$MC-field16] AS C18 
	FROM openrowset('MSOLAP',
		'Datasource=localhost;Initial catalog=FoodMart 2000',
		'SELECT [T].[C0] AS [field1],[T].[C1] AS [field2],[T].[C2] AS [field3],
			[T].[C3] AS [field4],[T].[C4] AS [field5],[T].[C5] AS [field6],
			[T].[C6] AS [field7],[T].[C7] AS [field8],[T].[C8] AS [field9],
			[T].[C9] AS [field10],[T].[C10] AS [field11],[T].[C11] AS [field12],
			[T].[C12] AS [field13],[T].[C13] AS [field14],[T].[C14] AS [field15],
			[T].[C15] AS [field16],[T].[C16] AS [KEY],[CREDIT1].[field16] AS [$M-field16],
			PredictProbability([CREDIT1].[field16]) AS [$MC-field16] 
		FROM [CREDIT1] PREDICTION JOIN  
			openrowset(''MSDASQL'',
			''Dsn=LocalServer;Uid=;pwd='',''SELECT T0."field1" AS C0,T0."field2" AS C1,
			T0."field3" AS C2,T0."field4" AS C3,T0."field5" AS C4,T0."field6" AS C5,
			T0."field7" AS C6,T0."field8" AS C7,T0."field9" AS C8,T0."field10" AS C9,
			T0."field11" AS C10,T0."field12" AS C11,T0."field13" AS C12,
			T0."field14" AS C13,T0."field15" AS C14,T0."field16" AS C15,
			T0."KEY" AS C16 FROM "dbo".CREDITDATA T0'') AS [T] 
		ON [T].[C2] = [CREDIT1].[field3] and [T].[C7] = [CREDIT1].[field8] 
			and [T].[C8] = [CREDIT1].[field9] and [T].[C9] = [CREDIT1].[field10] 
			and [T].[C10] = [CREDIT1].[field11] and [T].[C11] = [CREDIT1].[field12] 
			and [T].[C14] = [CREDIT1].[field15]') AS [TA] 
)  T0