salesforce Dreamforce On-Demand
Contact Us 1-800-596-4880
  1. Homepage
  2. Data Gateway

  3. Creating and Configuring a Gateway

Creating and Configuring a Gateway

Support for Anypoint Data Gateway continues in accordance with MuleSoft Product Support and Maintenance Terms. However, this product is not available for new customers or upgrades.

Overview

To create and manage gateways follow the steps below. When using the Data Gateway through Salesforce access Anypoint Gateway Designer from your Salesforce account by clicking the MuleSoft tab. When using it through the Anypoint Platform, access it on the Data Gateway tab.

MS_tab-1.2

In Gateway Designer, you can perform actions such as:

  • View, add or modify gateways

  • Configure connections and VPC

  • Publish your connection to Salesforce

  • View gateway logs

gateways_list-1.2

Roles and permissions in Gateway Designer match those defined in Anypoint Platform. For details, see User Roles and Permissions in Managing Gateways.

Creating a New Gateway

To create a new gateway, click Create Gateway. The Anypoint platform takes you through the creation process via simple configuration screens, explained below.

If you’re using the Data Gateway through the Anypoint Platform, you must first click the Login with Salesforce button, select a Salesforce account to link to and provide the required credentials and allow the Anypoint Platform access to your Salesforce data.

Configuring Properties

The gateway creation wizard displays the New Gateway screen, shown below. Here you define the following parameters:

  • The connection to use. You can use the drop-down menu to select from existing connections, or click Create to create a new connection

  • A name for the gateway

  • A description for the gateway (optional)

  • Username and password for the gateway

  • Throttling (optional)

newgateway-1.2

Fill in the required parameters, and select whether to use an existing connection or create a new connection.

If you check Apply Throttling, the wizard prompts you for the throttling parameters:

throttle_params-1.2

Throttling

This optional setting limits the max. number of messages that an API can process per millisecond. Throttling is applied to all API calls, regardless of the source. Messages that exceed the established limit are queued for later processing. The available parameters are:

  • Delay Time in Milliseconds: The amount of time that responses are delayed after the SLA has been exceeded

  • DelayAttempts: Number of attempts to process the request before fully exhausted

  • Maximum Requests Per Period: Number of requests to allow per specified time period

When configuring throttling, you can click an input field to view its brief description:

throttle_desc-1.2

After filling in the required parameters, click Create Gateway. Gateway creation takes a few minutes, but you can immediately continue working if you click Return to Gateway list.

creating_gw-1.2

After gateway creation completes, you can Publishing Your Gateway your gateway.

The next section explains how to create a new connection for your gateway, during the process of creating a gateway.

Configuring a New Connection

As detailed above, when you create a new gateway you have the option to use an existing connection, or create a new connection. If you select to create a new connection, the wizard prompts you to select from the available connection types, as shown below.

create_conn-1.2

Click the desired connection type, then click Next. The wizard displays a connection parameters configuration window. The image below displays the configuration parameters for Oracle.

oracle.conn.param

Optionally, you can specify your connection information using a connection String by clicking in the Advanced tab:

oracle.conn.string
You can configure your Gateway using a connection String for any available external data sources, except for SAP.

After filling in the required parameters, click Next. The wizard displays a dialogue that allows you to test your connection, and also to specify whether your connection is behind a firewall.

configure_oracle_db-1.2

Click Test Connection to ensure connectivity before actually creating the connection.

If your data source is on a private network, click <Datasource name> datasource is behind a firewall.

In this case you can use a Virtual Private Cloud (VPC), a robust and secure IPsec or OpenSSL connection between your company’s network and Anypoint Platform. Setting up the VPC may require assistance from your company’s IT organization.

configure_oracle_db-1.2.b

Configuring a New Connection for SAP

There are a few requirements for connecting Data Gateway to SAP; these are described below.

SAP Libraries

When configuring a new SAP connection, you need to have the SAP library files available on your local machine. The connection configuration window prompts you to upload the libraries necessary for a SAP connection:

  • SAP IDoc JCo Library (sapidoc-x.jar)

  • SAP JCo Library (sapjco-x.jar)

  • SAP JCo Native Library (libsapjco-x.jar)

Download these SAP libraries from the official SAP download site. You need a SAP user ID to download.

For more information on SAP libraries, refer to SAP Java Connector in the SAP help site.

Required Function Module Z_AW_RFC_READ_TABLE

In order to deploy a gateway to an environment, function module Z_AW_RFC_READ_TABLE used by Data Gateway must exist in the SAP instance. If the module is present in the SAP instance, then no action is necessary.

Depending on the specific version of SAP, the function module may be called /BODS/RFC_READ_TABLE or /SAPDS/RFC_READ_TABLE. If the SAP instance contains one of these two modules, copy it into a new module named Z_AW_RFC_READ_TABLE.

If the SAP instance does not contain any of the above-listed function modules, then you must create function module Z_AW_RFC_READ_TABLE. Depending on the SAP solution and/or release, it may possible to install the module in accordance with SAP Note 1752954. If this SAP note is not applicable for your specific SAP solution and/or release, then you must implement the function module from the provided SAP transport (see files D900237.EH6 and K900237.EH6). See SAP Note 1802544 for a reference on how to deploy the SAP transport. If it is not possible to import the transport into the SAP instance, then create the function module manually from the provided source code (see file Z_AW_RFC_READ_TABLE.abap).

Note that in all cases the Z_AW_RFC_READ_TABLE module must be available on all SAP instances which can be accessed by Data Gateway.

The RFC transport is available for download.

Publishing Your Gateway

Once you’ve created your gateway, it appears on the list in the Gateways page. To publish it to Salesforce, you can either click the Salesforce tab on the left menu, or click the Edit button for the gateway, then select Publish.

publish-1.2

You will be directed to the Salesforce settings page. Here you can publish all of your gateways to a single Salesforce Connect connection, exposed together through a single endpoint. To do so, do the following:

  1. Check Publish to Salesforce

    publish 1

  2. Check which Gateways you want to publish to your endpoint on the Published Gateways menu

    publish 2

  3. Click Save

At this point, you have set up, created and published your gateway, and are ready to populate it with objects. To do this, you also use the Edit menu, which also allows you to stop, delete or modify a gateway. For details on these operations, see Managing Gateways.

In previous versions of the Data Gateway, each Gateway was mapped to a Salesforce Connect connection. Now, all of your Gateways are channeled to a single Salesforce Connect connection, exposed through the endpoint you see in this screen.

If you enter the settings of any individual gateway – by clicking Edit → Settings – you will see a different endpoint that exposes it. This endpoint is not valid for Salesforce connections, but still useful for connecting to other things.

See Also

  • Learn about defining connections and parameters, viewing and modifying existing gateways in Managing Gateways.