TARGIT Server as a data source - ETL InMemory

[Cloud release: 2025.11.26]
[On-prem release: 2026 January]
[On-prem build: 26.01.21003]

The TARGIT Server can be used as a data source for designing new data warehouses and new cubes. Benefits include:

• All data centered around one data source: The TARGIT Server.
• The TARGIT server may already be connected to multiple data warehouses from different source systems. Using these connections as data sources for a new data model, you can analyze the data in new unified and mashed up relations.
• Data from existing TARGIT connections are already well-structured and consistent due to the Data Model layer, allowing for immediate reuse in new connections.

The ETL Data Source

In the TARGIT InMemory ETL Studio you can add the TARGIT Server as a new data source:

As a minimum requirement, you should provide the server name and the authentication method.

You may furthermore click the 'Fetch connections' to select a specific TARGIT Server connection for this data source.

• Connection name: First, click 'Fetch connections', then select a database from the connected TARGIT server.
• Load as string: Will prevent data type auto-detection and instead import all fields as strings.
• Simplify column names: Will try to reduce the length of imported field names by removing duplicate dimension/hierarchy/level strings in the name. E.g., "Company.Company.Company" is simplified to "Company".

Now, when adding an Import task to your ETL workflow, you can select the 'TARGIT Server' as a data source:

The 'Predefined' Query type

The Predefined queries is a collection of system queries that extracts meta data with information about the connections, the cubes, the dimensions, the measures, etc.

Note: For these predefined queries, it might be helpful to right click the Import task to preview the result of the query.

Help

The predefined 'Help' query gives you an overview of all the other predefined queries - including descriptions, parameters, and examples.

Connections

Will give you an overview of all data warehouse connections (databases) from the TARGIT Server data source.

Parameter: None

Cubes

Will give you an overview of all cubes in the selected connection from the TARGIT Server data source.

Parameter: Connection (database). If no connection (database) was specified in the TARGIT Server data source, or if you want to look up cubes in a different data source from the same TARGIT Server, click the "three dots button" to select the database parameter.

Columns

Will retrieve a list of all columns (measures and dimensions) - including ColumnType, EntityType, etc. - from the selected cube.

Parameters: Connection, Cube.

Measures

Will retrieve a list of all Measures - including DataType, FormatString, etc. - from the selected cube.

Parameters: Connection, Cube.

Dimensions

Will retrieve a list of all Dimensions from the selected cube.

Parameters: Connection, Cube.

Hierarchies

Will retrieve a list of all Hierarchies (attributes, single-level hierarchies, multi-level hierarchies) from the selected dimension.

Parameters: Connection, Cube, Dimension.

Levels

Will retrieve a list of all Levels from the selected hierarchy.

Parameters: Connection, Cube, Dimension, Hierarchy.

Members

Will retrieve a list of all Members (member properties, attribute relationships) from the selected hierarchy.

Parameters: Connection, Cube, Dimension, Hierarchy.

The 'Designer' Query type

With the Designer query type you will be able to use an interface to select data - dimensions and measures - to include in your Import task.

The interface is very similar to the interface in the TARGIT Designer client when defining data content of objects.

Furthermore, you may apply filters to these queries.

So, with the Designer query type you will be able to extract data (dimension members and measure values) from your existing TARGIT Server connections. 

In this example, two dimensions and two measures have been selected with the Designer interface. Furthermore, a filter, Year = 2024, has been applied.

The 'Query' query type

The 'Query' query type is an option for you to write your own SQL query - potentially using more advanced SQL scripts than you will be able to produce from the Designer query option.

Tip: When you use the Designer queries, the resulting SQL script can be seen and copied from the Script window in the ETL project.

To enter your custom SQL query, click the three buttons after having selected the 'Query' query type: