Scoring data in ADAPA via web services using SQL Server Integration Services (SSIS)

Data integration is a big part of putting predictive models to work. ADAPA on the Amazon Cloud allows for easy model deployment, but how can you actually move the data to the Cloud for scoring? One simple way is by using SQL Server Integration Services (SSIS).

Given that the Web Service Task available in SSIS has limitations (one needs to provide values for the input parameters through the task UI), we strongly recommend the use of a Script Component instead. We have put together a blog describing in 10 simple steps how to setup, write and execute a Script Component so that you can automatically send data records to ADAPA on the Cloud and get a result back for each record (without having to type the inputs in the UI every time - as required by the Web Service Task). Please follow the link below to find out more.

• How can I score data in ADAPA via web services? SQL Server Integration Services (SSIS) - using the Script Component.