SQL Server

https://e.gitee.com/gudusoft/docs/1006527/file/2767137?sub_id=7687947

Please ensure you have the prerequisites and the package listed in this page before start creating the SQLFlow Job and connecting to the SQLFlow server.

This page provides detailed configuration steps to submit Job for SQL Server.

Command

Windows

submitter.bat -f <path_to_config_file>  
e.g.
    submitter.bat -f D:/mssql-winuser-config.json

Linux & Mac

bash submitter.sh -f <path_to_config_file>  

note: 
    path_to_config_file: the full path to the config file

e.g.
    bash submitter.sh -f /home/workspace/gudu_ingester/submitter_config.json

SQL Server Sample Config File

{
	"databaseServer":{
		"hostname":"DESKTOP-MLUR76N\\SQLEXPRESS",
		"port":"1443",
		"database":"master",
		"extractedDbsSchemas":"",
	        "excludedDbsSchemas":"",
	        "extractedStoredProcedures":"",
	        "extractedViews":"",
		"enableQueryHistory":false,
		"queryHistoryBlockOfTimeInMinutes":0,
		"sqlsourceTableName":"",
		"sqlsourceColumnQuerySource":"",
		"sqlsourceColumnQueryName":"",
		"authentication":"windowsuser" //this is for windows user only
	},
	"sqlFlowServer":{
		"server":"http://sqlflow.cn",
		"serverPort":"8081",
		"userId":"gudu|0123456789",
		"userSecret":"xxx"
	},
	"sqlScriptSource":"database",
	"lineageReturnFormat":"json",
	"lineageReturnOutputFile":"",
	"databaseType":"mssql",
	"taskName": "sumitterTest",
	"jobNameToId": 1,
	"jobType":"regular"
}

For the detailed field description, please refer to this page.