Connect to on-premise data

Create a data gateway

  1. On the model resource screen, click Settings > Features > Data Gateways.

    Connect to on-premise data_Create a data gateway_1.png

  2. Click +Add gateway.

    Connect to on-premise data_Create a data gateway_2.png

Optional:

Rename the gateway using the Gateway field.

Install a data gateway

  1. Click Download installer on the gateway you wish to download. A download will start called Data Gateway Installer <gateway_name> installer.exe.

    Connect to on-premise data_Install a data gateway_3.png

  2. Run the installer on the target host machine with access to your data sources.

    Connect to on-premise data_Install a data gateway_1.png

  3. Click Next and follow the prompt steps to install the gateway.

    Connect_to_on-premise_data_Install_a_data_gateway_2.png

  4. Click Next and follow the prompt steps to install the gateway.

  5. Click Save.

Remove or uninstall a data gateway

Remove a gateway

  1. On the model screen, click Settings > Features > Data Gateways.

  2. Right-click any white space in the Data Gateway row that you want to remove. Click Remove Gateway.

    Connect to on-premise data_uninstall a data gateway_1.png

  3. Click Save.

Note

If a pop-up indicates that the gateway is already in use, click Remove Gateway to remove the gateway from the model.

Uninstall a gateway

  1. On the model resource screen, click Settings > Features > Data Gateways.

    Connect_to_on-premise_data_uninstall_a_data_gateway_1.png

  2. Click Download installer on the relevant data gateway to download the Data Hub Gateway Installer<gateway_name> installer.exe.

  3. Run the installer on the host machine where it is installed.

    Connect_to_on-premise_data_uninstall_a_data_gateway_2.png

  4. Click Next on the Welcome to the Data Gateway - <gateway_name> Setup Wizard screen.

  5. On the Change, Repair, or Remove Installation screen, click Remove, then click Remove on the following screen.

    Connect_to_on-premise_data_uninstall_a_data_gateway_3.png

  6. If a Files in Use screen appears, review the list of programs in the text box provided.

    1. If the only program present is Data Gateway - <gateway_name> Service, select Close the applications and attempt to restart them.

    2. If additional programs are listed, select Do not close applications. A reboot will be required. The gateway will be uninstalled next time the machine is restarted.

    Connect_to_on-premise_data_uninstall_a_data_gateway_4.png

  7. Click OK to complete the uninstall.

Assign a data source to a gateway

  1. On the model resource screen, click Settings > Features > Data Gateways.

    • No data gateway required.

    • The data gateway assigned to the Data Source.

  2. Expand all sections to locate a data source (grouped by Data Model). The data source will be listed under either of the following:

  3. Click the vertical ellipsis ( ⁝ ) in the Actions column.

  4. From the menu, select the target Data Gateway.

    Connect to on-premise data_Assign a data source to a gateway_2.png

  • No data gateway required.

  • The data gateway assigned to the Data Source.

Migrate a gateway to another server

To migrate a data gateway from its current host to another host machine, follow the steps for the following:

  1. Uninstall a Data Gateway

  2. Install a Data Gateway.

In this section: