Connect to Oracle DB using ODBC and Data Source Name (DSN)

Visual Expert allows you to analyze PL/SQL code directly from your Oracle database. This guide explains how to configure the Visual Expert connection to your Oracle DB using ODBC and Data Source Name (DSN).

Case 1: Connect using ODBC

  1. Open Visual Expert, click [New] on the ribbon menu to open the "Create Project" wizard.
    Select [PL/SQL] in the next pop-up.
    Select PL/SQL
  2. Click on [Oracle Database] in the Oracle DB connection page.
    Click on Oracle DB
  3. Click on [ODBC] radio button.
    From the ODBC drivers dropdown, select the appropriate ODBC drivers for Oracle.
    Select ODBC Radio Button
  4. Enter Server Name, Authentication type, User ID and Password.
    Enter Server Credentials
  5. Click on [Test Connection].
    Once connected successfully, select a "Database Name" from the dropdown list to analyze.
    Click [Next] and follow the wizard to analyze the added source code.
    Select DB Name to proceed

Case 2: Connect using Data Source Name (DSN)

  1. You need to create a Data Source Name. Open the "ODBC Data Sources" on your PC.
    Open ODBC Data Sources
  2. The ODBC Data Source Administrator will open on your screen. Click on [Add].
    Add Oracle DSN Files
  3. Select the appropriate ODBC drivers for Oracle. Click on [Finish].
    Select Oracle ODBC Drivers
  4. Enter the Data Source Name, description, TNS Service Name and USer ID. Click on [Test Connection].
    Enter Oracle DSN Credentials
  5. Enter the password to check the connection. Once, tested successfully, click on [OK].
    Oracle ODBC Driver authentication
    Oracle ODBC Driver Connection Successful
  6. You will see that the new Oracle DSN is added to the Data Source Administrator.
    New Oracle DSN Added
  7. Open Visual Expert. Select the [Data Source Name] radio button as connection type.
    Enter the Data Source Name, User ID and Password. Click on [Test Connection].
    Once connected successfully, proceed with the project creation.
    Oracle DSN Authentication

More from VE Configuration

 

Visual Expert, Configuration, Oracle Database, ODBC, Data Source Name (DSN)