<?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