How to Create and Connect to an Oracle Connection in VDM

Trouble Viewing Images? Right-click on any image and select "Open in new tab" to view a larger version. You can also zoom in using Ctrl + Mouse Wheel for easier readability.

Article Goal

To walk users through the process of creating a new Oracle connection profile in VDM so they can access Oracle data sources natively for querying, reporting, and data integration.

What Is an Oracle Connection in VDM?

An Oracle Connection in VDM allows users to connect directly to an Oracle database. It provides native access to Oracle tables, views, and schemas through a dedicated connection profile.

Video Tutorial:

Not yet available.

Steps To Create an Oracle Connection Profile.

1: Launch VDM: Open the VDM application on your local machine.

2: Start the New Connection Wizard: Click on Database > New from the ribbon menu at the top of the screen.

💡 This launches the connection profile wizard where you’ll set up database credentials.

3: Choose Oracle as the Connection Type: In the Connection Type drop-down menu:

• Select Oracle

• Ensure Prefix TO/Schema Name is checked

4: Enter Your Oracle Credentials: Enter the Username and Password.

🔐 Ensure the credentials are correct before proceeding to avoid connection errors.

5.Paste in the Data Source: Locate your Oracle ADB connection string

• Go to your Oracle ADB DB Connection Page

• Click Copy next to the desired data source string

• Paste the string into the Data Source field in VDM

📝 This string identifies the Oracle instance VDM will connect to.

6: Test the Connection: Click Test Connection.

• If the test is successful, click OK

• If unsuccessful, double-check your credentials and data source

✅ A successful test confirms VDM can communicate with the Oracle database.

7. Select Owners/Schemas: Select the owners/schemas you want to access within VDM.

📁 These define what Oracle tables and views will be available for querying.

8. Save the Connection Profile: Enter a Connection Name (e.g., Oracle_ADB_Prod) and click Save to store the profile.

💡 Choose a clear, descriptive name for easy identification later.

9. Load the Connection: Click Load All from either the Database ribbon bar menu, or the bottom-left corner of the VDM interface. Your Oracle connection will now appear in the list of available connections.

✅ VDM’s built-in Oracle support means no ODBC driver or Wallet is required.

Article Summary

This article explains how to create and connect to an Oracle database within VDM using the native connection profile wizard. It includes entering your login credentials, pasting the Oracle ADB data source string, selecting schemas, and confirming connectivity—all without needing external drivers or Oracle Wallet files.