Ole Dyring
Articles
-
InMemory ETL task: Add column
This task can help you to add a new column to an existing table. CREATE TABLE [NewTable] (CountField int, DateField datetime)ALTER TABLE [NewTable] ADD COLUMN NewField = {NULL}SAVE Note: The scri...
-
InMemory ETL task: Insert Into
The 'Insert Into' task can be used to insert values in existing tables. The insert method for the value can be one of three types: Variable. With the 'Variable' option, you can insert values from...
-
InMemory ETL task: Union
The 'Union' task is a container type task that will perform a UNION ALL to combine the result sets of two or more SELECT statements that have been added to the Union container. IMPORT [CSV_A] = [...
-
InMemory ETL task: While
The 'While' task is a container that will execute the contained tasks in a loop as long as the criteria for looping is fulfilled. The While task's properties can work with two condition types: ...
-
InMemory ETL task: Slurp
The 'Slurp' task will import all data from all tables from the designated data source. E.g., you may have an SQL Server data source connected to a specific database like this: The 'Data Source' p...
-
Copy paste documents between client and file system
[Cloud release: 2024.05.01][On-prem release: 2024 April][On-prem build: 24.05.03003] It is possible to copy and paste dashboards, reports and other document and file types between the TARGIT Design...
-
Data Discovery Online Data Providers
TARGIT Data Discovery and TARGIT InMemory shares a number of Online Data Providers. An Online Data Provider is a provider that is centrally managed by TARGIT. If access to the data source is change...
-
Online Data Provider: Generic REST API
[Cloud release: 2024.04.22][On-prem release: 2024 April][On-prem build: 24.05.03003] If you know how to create and work with APIs with the Postman platform, then it should be quite easy for you to ...
-
Behave as member property
[Cloud release: 2024.04.08][On-prem release: 2024 April][On-prem build: 24.05.03003] In BI terminology, a 'Member Property' can be defined as any additional piece of information that can be added t...
-
TARGIT InMemory database in Cloud
[Cloud release date: 2024.04.01][On-prem release: 2024 April][On-prem build: 24.05.03003] Your TARGIT InMemory database may be hosted in the Cloud. Note: You should contact your TARGIT account mana...