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 | |
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 |
|
Password |
|
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: