How to use a web data provider in TX

Author: Thomas Hjermitslev Last updated: July 14, 2017 22:57
howto sql_server updated_20140328 data_source ssis web_service

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

Create a SSIS package that reveives data from a webservice and stores the data in a SQL Server table.
Use the SQL Server Table populated by the SSIS package as a data source in your TX project.
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.

1 Comments

Date Votes

1

Kurt Denolf April 04, 2014 06:57

One of the strengths of TX is that all Bi setup can be centralized in TX. With this setup you need to do some setup in another environment for which you need to have specific technical knowledge . therefore I would suggest that TX looks into the possibilities to connect directly to webservices data in future releases.

Please sign in to leave a comment.