How to use a web data provider in TX

Introduction

In some cases, it can be useful to retrieve data from a web service. For instance, you could retrieve current or historic exchange rates for converting currencies in your project. While you cannot simply point TX to a web service and fetch data, it is fairly straightforward to get web data into your project.

Step by step

1. Create a SSIS package that reveives data from a webservice and stores the data in a SQL Server table.
2. Use the SQL Server Table populated by the SSIS package as a data source in your TX project.
3. Optional: Set the SSIS package up to be executed from the TX Execution package.

This article applies to: timeXtender 4.5, tX2012, TX2014. Last updated: 2014-03-28.