Transformations Quick-Start: Configure Connections

In this exercise, the various Connections needed to complete the remaining exercises of the Transformations Quick-Start Guide will be created.

Experienced users of Integration Studio should have no difficulty configuring a Connection. If you're comfortable doing this on your own, include the following Connections in your tenant before advancing to the next tutorial:

• File Utilities

• HTTP

• Handlebars

• JSON

• SFTP

• Tabular Transformation

• XML

Experienced users likely already have these Connections established. Be sure to activate them for the Workspace Environments being used for this guide.

📓 The example starts from an existing OneCloud tenant. The sample screenshots and videos may deviate from what is seen in a user's tenant. Some of the aforementioned Connections have already been established.

Step 1: Add an SFTP Connection

Add a new SFTP Connection that will interact with an SFTP server.

• From the left-side navigation panel select Connections.

• Click on the blue plus (+) button in the lower, right-hand corner.

• From the Select a BizApp dropdown, select the SFTP Connector.

• Select the appropriate Runner(s).

• Configure the Connection with the following:

  🌟 Give your Connections unique names, as BizApps may be used multiple times.

• Enable the Connection for the DEV and PROD Environments of the Sample Workspace for Transformations Workspace.

• Save the Connection.

Step 2: Add Additional Connections

If they do not already exist, add/enable Connections for the File Utilities, HTTP, Handlebars, JSON, Tabular Transformation and XML BizApps.

• Add a Connection for the File Utilities BizApp.

• Add a Connection for the HTTP BizApp.

• Add a Connection for the Handlebars BizApp.

• Add a Connection for the JSON BizApp.

• Add a Connection for the Tabular Transformation BizApp.

• Add a Connection for the XML BizApp.

The aforementioned BizApps have no specific parameters as the SFTP BizApp requires. Simply make sure the Connection name is updated and that the Connection is enabled for the Workspace (Sample Workspace for Transformations) and its respective Environments.

If you need to create the Connection:

• Click on the blue plus (+) button in the lower, right-hand corner.

• From the Select a BizApp dropdown, select the desired BizApp

• Select the appropriate Runner(s).

• Scroll down to enable the Environments.

• Save the changes.

📚 Topics covered in this exercise:

Workspaces

Connections

File Utilities

HTTP

Handlebars

JSON

SFTP Connector

Tabular Transformation

XML