Data Gateway Overview

What is it?

The Data Gateway is a tool that offers a way of reaching multiple on-premise resources from a TARGIT Cloud Solution.

The Data Gateway does this without requiring users to open ports in their firewalls.

The Data Gateway serves multiple purposes.
Some of the tasks the Data Gateway covers can also be covered in other ways, while other jobs require using the Data Gateway.

  • You can use the Data Gateway to connect to On-Premise data sources.

    • Data Sources that can be connected through TARGIT Management and used directly for reporting

    • Data Sources that can be connected through ETL Studio and used in one or more ETL jobs

      In both cases, you set up the connection on-premise using the Data Gateway, and then you can refer to that connection when utilizing the data in TARGIT Cloud.

      This task can also be done by adjusting the firewall settings on the server where your on-premise data sources are located.
      This is an alternative to using the Data Gateway for this purpose, described in detail here.


      Directing queries through an additional component (the Data Gateway) always incurs an overhead.
      Through testing, we have seen no noticeable overhead on smaller queries and up to 40% overhead on larger queries

  • You can use the Data Gateway to set up export folders that can be utilized in scheduled jobs in a TARGIT Cloud solution that delivers PDFs, snapshots, and excel/CSV files in an on-premise folder.

    You can theoretically do this in other ways, but currently, this is the recommended way of setting up a connection to on-premise export folders in TARGIT Cloud.

  • You can use the Data Gateway to set up on-premise folders that Data Discovery uses for data sources when using TARGIT Cloud.

    You can theoretically do this in other ways, but currently, this is the recommended way of setting up on-premise folders used for Data Discovery in your TARGIT Cloud solution.


Where can I get it?

When you log on to your TARGIT Cloud Control Panel (see here for more info on this), you have three links at the bottom - one of them being Download:


By clicking this, you get access to (among other links) the gateway (Gateway Connections):



When clicking the Gateway connections, a download will automatically begin - once it is done, you can double-click this file to start the installation:


If you get this - click More info:


And Run Anyway:


Now agree to the license conditions and click Install:


Now the Gateway installs.

How to use it

Connect to on-premise data sources

The Data Gateway runs as a service - just like the TARGIT server in an on-premise solution:


The account that runs this service (in the example above, Local System) needs read rights to every data source you wish to access through the Data Gateway.


Now start the Data Gateway with this short-cut:



The main dialogue looks like this:



The name field could be kept as the server name

The Data Gateway Connection string needs to be copied from your Cloud Control Panel, which is how your Data Gateway connects to your cloud environment.

Example of a connection string from Cloud Control Panel:



The three tabs - databases, shared folders, and shared files represent the functionality covered by the Data Gateway.

1. tab Databases... where you make a connection to your on-premise databases, relational or analytical databases. If needed, you can also install drivers for your database connections

Here you can connect a connection to a database -like this example:



Now you can use TARGIT Management - and refer to the connection mentioned above - connecting through the Data Gateway:


This connection can also be utilized from ETL Studio - when you create a Data Source; you have a field called Gateway connection string:
This is where you paste your connection string copied from your Cloud Control Panel. (see more here on the Cloud Control Pane.).

2. tab Shared Folders... where you set up folders that can be used for export from scheduled jobs or/and used as input for your Data Discovery in the Cloud Environment.

Here you can add new local export folders meant to be used in your cloud implementation of TARGIT:


When you open TARGIT Management and pick the export folder tab, you can now add an entry that refers to your Data Gateway setup:


Now, this export folder is available in the Windows Client for scheduled export jobs.


3. tab Shared Files... where you set up access to files that are used as input in the Data Discovery running in your Cloud Environment

The technical stuff

The Gateway effectively creates an isolated area where the Data Gateway client and TARGIT Cloud/ETL Studio can communicate. 
Note: This means that you won't have to open any of the ports mentioned below manually

The current version of TARGIT Data Gateway (as of September 2022) uses Azure Service Bus to communicate between various peers.
Azure Service Bus is a message broker that is available in Microsoft Azure.

When the Gateway Client service starts, it connects to the TARGIT Cloud Control panel API via HTTPS port 443 to get access to the Azure Service bus. It uses the key specified in the connection string to authenticate with the Cloud Control panel API. The Control panel API verifies that the key is correct and issues two temporary access tokens for the Azure Service Bus that can only access resources in your TARGIT Cloud tenant.

When the Data Gateway client receives the access tokens, it uses these to directly connect to the Azure Service Bus using AQMP protocol on ports 5671 and 5672. It will start receiving packets and respond to any incoming requests.
The response is divided into smaller chunks and sent as packets over Azure Service Bus.








Was this article helpful?
0 out of 0 found this helpful



Please sign in to leave a comment.