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

Primary Learning Objective

To reinforce the concept of Connections.

Secondary Learning Objectives

--

Prerequisites

Workspace Configuration exercise

Supporting Template

N/A

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.

Name

SFTP (Transformation QS)

Host

sftp.onecloud-demo.com

Port

22

Username

ro_sample_lnx

Password

testdata1!

Private Key

<leave blank>

Private Key Password

<leave blank>

Connection Timeout

30

  • 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


Did this answer your question?