Creating New Oracle Connections

The following steps demonstrate how to create new Oracle DB data connections.

1. On the main navigation bar, click Data.

   The Data view appears, open on the Datasets tab.

2. In the side bar, click New Connection.

   The Create New Data Connection modal window appears.

3. In the Create New Data Connection modal window, under Connection type, select Oracle.
4. Under Connection name, specify the name of the new connection. Here, we use OracleConnection.

5. Under Hostname or IP address, specify the name of your database host, or its IP address; use localhost when the data source is local.

6. Under Port #, enter the port number. The default port # for Oracle connections is 1521.

7. At the bottom of the modal, click Test.

   

8. If the connection is valid, the system returns a 'Connection Verified' message.

   

9. Click Connect.

After this operation succeeds, the new connection name appears on the side navigation bar.