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:
The Microsoft SQL Server BizApp