In this exercise, we will create the various Connections needed across the remaining exercises of this Quick Start guide.
Primary Learning Objective
This exercise is designed to reinforce the concept of Connections.
Secondary Learning Objectives
A Workspace named Learning OneCloud with a DEV environment needs to exist. See the Learning OneCloud Quick Start Guide for more information.
Create a Connection to interface with a relational database. For this tutorial, we have created sample Oracle and SQL Server relational databases. If you are ready to get started using one of our sample databases, then follow the order of operations below:
📓 Note: If you'd prefer to use your own database, then you will most likely need to configure a GroundRunner to interface with your on-premise system.
Step 1: Create an Oracle or Microsoft SQL Server Database Connection
Navigate to the OneCloud Connection Manager and click the blue (+) circle to create a new Connection.
Under "BizApp Connection", select "Microsoft SQL Server".
Set the desired Runner(s). Here it's "Windows GroundRunner" and "CloudRunner".
Under "Basic Info", name the Connection.
🌟 Use unique names to distinguish the Connections from one another.
Under "Properties", establish a username, password, and connection url.
As the relational database username and password enter:
For the SQL Server JDBC String, enter the following JDBC URL:
Enable the Connection for the "DEV" and "PROD" Environments.
Save the Connection.
📚 Related Topics from this Section: