Workiva Quick Start: Configure Relational Connections

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:

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:

Back	Next
Create a Source Data Connection	Load to Wdesk with a Chain