Connecting to Microsoft SQL Database

Automation Cloud Community
#1 
<?xml version="1.0" encoding="UTF-8"?>
<config charset="UTF-8"
	xmlns="http://web-harvest.sourceforge.net/schema/1.0/config"
	scriptlang="groovy">

	<script><![CDATA[
		import groovy.sql.Sql
 
url = 'jdbc:sqlserver://serverurl:1433;DatabaseName=workfusiontest'
user = 'username'
password = 'password'
driver = 'com.microsoft.sqlserver.jdbc.SQLServerDriver'
sql = Sql.newInstance(url, user, password, driver);

demo = sql.execute'SELECT * FROM workfusion_table'
println(demo)
		
	]]></script>
	 
	 <export include-original-data="true">
	</export>
	

	
</config>
1 Like
#2