Overview

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

None

Prerequisites

A Workspace named Learning OneCloud with a DEV environment needs to exist. See the Learning OneCloud Quick Start Guide for more information.

Supporting Template

N/A


Create a Connection to interface with a relational database. For this tutorial, we have created sample Oracle and SQL Server relational databases.

📓 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.

If you are ready to get started using one of our sample databases, then follow the order of operations below:

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".

  • Under "Properties", establish a username, password, and connection url.

    • As the relational database username and password enter:

      Username: RO_SAMPLE_DB
      Password: testdata1!
    • For the SQL Server JDBC String, enter the following JDBC URL:
      jdbc:sqlserver://oc-demo.database.windows.net:1433;database=sample_db

  • Enable the connection for the "DEV" and "PROD" Environments.

  • Save the Connection.


📚 Related Topics from this Section:

GroundRunner Configuration

The Microsoft SQL Server BizApp


Did this answer your question?