Data Gateway Overview

What is it?

The Data Gateway serves multiple purposes. Some of the tasks that are covered by the Data Gateway can also be covered in other ways, while other tasks require the use of the Data Gateway.

  • You can use the Data Gateway to connect to On-Premise data sources. Once you've set up the connection to a data source, you can then refer to that connection in TARGIT Management and reach a data source that is on-premise, while you are using our cloud software
    This task can also be done by adjusting the firewall settings on the server where your on-premise data sources are located. Currently this is actually the recommended way of setting up a permanent connection to an on-premise data source

  • You can use the Data Gateway to set up export folders that can be utilized in scheduled jobs that deliver PDFs, snapshots, 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 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 you are using TARGIT Cloud.
    You can do this in others ways - but currently this is the recommended way of setting up on-premise folders that are used for Data Discovery in your TARGIT Cloud solution.

 

Where can I get it?

When you log on to your TARGIT Cloud Control Panel, you have 3 links in the bottom - one of them being Download:

control_panel.png

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

download_links.png

 

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

mceclip4.png

If you get this - just click more info:

mceclip5.png

and Run Anyway:

mceclip6.png

Now agree to the license condidtions and click Install:

mceclip7.png

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:

mceclip0.png

The account that runs this services (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:

mceclip1.png

 

The main dialogue looks like this:

mceclip2.png

 

The name field could be kept as server name 

The Data Gateway Connection string needs to be copied from your Cloud Control Panel - and this is how you Data Gateway connects to your cloud environment.

Example of connection string from Cloud Control Panel:

mceclip3.png

 

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

1. tab Databases...

...is 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:

mceclip5.png

 

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

mceclip6.png

 

2. tab Shared Folders...

...is where you setup 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:
mceclip0.png

 

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

 

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

 

3. tab Shared Files...

...is where you setup access to files that are used as input in the Data Discovery running in your Cloud Environment

 

 

 

 

 

 

 

 

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

Comments

0 comments

Please sign in to leave a comment.