DOH!
I thought this was the first i tried. Try the following:
import groovy.sql.Sql
def authorStep = testRunner.testCase.getTestStepByName( "GetData" )
def resultStep = testRunner.testCase.getTestStepByName( "ResultProperties" )
AuthorName = authorStep.getPropertyValue( "Author" )
ResultCount = resultStep.getPropertyValue( "TotalResults" )
sql = Sql.newInstance("jdbc:sqlserver://localhost:1898;
databaseName=eviware_demo_datainsert;user=eviware;password=eviware;")
sql.execute("insert into dbo.eviware_tb_datainsert (Author, NumberOfBooks) values (${AuthorName}, ${ResultCount})")
What I've corrected is the connection string to be exactly like the one in the datasource tutorial.
/niclas