Niels Thomsen
Articles
-
Using While-do loop from toolbox to import tables in parallel
This is an example of using the while-do task from the toolbox in ETL studio. The project loops through company table and for each entry in the table, the corresponding tables are loaded. (This is ...
-
Using the Enum task from the toolbox in ETL Studio
Example using the Enumeration Task to create meaningful text from numeric codes. The Enum Task is in the toolbox of ETL Studio and allows you to design and create lookup tables that makes codes (...
-
Retrieving information from REST Api with loop from input list
This script is a simple example of communication with a REST API using ETL studio. An input list is read - an for each entry the REST API is called and information retrieved - so the script contain...
-
Simple optimization for analysis based on Tabular database (disable totals and subtotals)
When building TARGIT data objects that query a Tabular Database (on-premise or Azure Analysis Services) excluding subtotals and totals can have a great impact on performance. A crosstable holding m...
-
Planning a TARGIT Portal - practical decisions
Most TARGIT customers build a "portal" where they make all the relevant data available to support decision making in the entire organization. The definition of a "TARGIT portal" here is: A set of ...
-
HTML Tables as a data source - basic guide
What is it? With this plugin you can "scrape" HTML tables from webpages (provided these are "old school" HTML tables, and auto-generated when you enter the page). How to connect through Data D...
-
Optimize your Search in TARGIT Community
When you search through the TARGIT Community, you can potentially get a lot of hits that are not relevant to you.There are a few ways of making your search more accurate and bring down the number o...
-
Windows Event Log as data source - basic guide
What is it? This plugin allows you to extract data from the Windows Event Log and follow the "health" of your server in TARGIT. How to connect through Data Discovery? The dialogue is very simple...
-
Weather as data source - basic guide
What is it? With the Weather plugin you can extract weather data from all around the world (current and back in time) with the granularity of zip-codes. You will get temperatures, windspeed, dew...
-
European Central Bank as a data source - basic guide
What is it? Using this plugin allows you to get exchange rates - both current and historic from a date span of your choice. You choose which currency should be the base rate, and then you pick t...