Test Automation for Salesforce | Provar Logo Test Automation for Salesforce | Provar Retina Logo
  • SOLUTIONS
    • SALESFORCE
    • SERVICEMAX
  • RESOURCES
    • RESOURCES
    • FAQS
  • COMPANY
    • COMPANY
    • EVENTS
    • CAREERS
    • PARTNERS
    • CONTACT US
  • SUPPORT
  • BLOG
  • REQUEST A DEMO
Database Testing Setup

Database Testing Setup

The first step in testing a database is to add a Database Connection.

Once created, these details will be saved in the Connections tab within Test Settings. Information in the database can be viewed and acted upon via the Org Browser. Refer to Database Operations for more information on the available actions.

Adding a Database Connection (Oracle, PostGreSQL, MySQL, SQL Server or DB2)

To add a new Database Connection, navigate to the Test Settings view and click the + () button to create a new Connection.

Enter a Connection Name and Description, then specify ‘Database’ as Connection Type. As a subtype, select ‘Oracle’, ‘PostGreSQL’, ‘MySQL’, ‘SQL Server’ or ‘DB2’. (Note that DB2 is available for Provar version 1.9.7 and later.)

Enter the other information as follows:

  • Host Name (e.g. localhost)
  • Port Number (e.g. 1433)
  • Database (Name), Service, SID or Database and Schema (depending on database type – see below for examples)
  • User
  • Password

Oracle example:

MySQL example:

SQL Server example:

Once the details have been entered, click the ‘Test Connection’ button to verify the details are correct:

Once the details have been verfied, click the ‘OK’ button.
Check that the Connection has been added to the Connections tab:

Database Browser View

Once you have created your Database connection, you can initiate testing from the Database Browser in the following ways:

  • Drag Database data rows into the Query window to generate SQL and execute
  • Drag Data or tables into the Test Case to generate Test Steps

Refer to Database Operations for more information on the available actions.

Share this:

  • Twitter
  • LinkedIn
vikas.wig 2019-02-19T17:13:43+00:00

Leave A Comment Cancel reply

  • Introduction
  • General Information
    • About Provar
    • System Requirements
    • Installing Provar
    • Granting Org Permissions to Provar
    • Updating Provar
    • Provar Support Process
  • Licensing Provar
    • License Types
    • License Activation
  • Tutorials
    • Start Here
    • Quickstart Guide
    • Quickstart Extension
    • Data Driven Testing
    • Testing with Different Profiles
    • Lightning Testing
  • Testing With Provar
    • Provar Desktop
    • Creating and Importing Projects
    • Adding a Connection
    • Creating Test Cases
    • Adding UI Test Steps
    • Using Functions
    • Managing Test Steps
    • API Testing
    • Using Test APIs
      • Test APIs Introduction
      • BDD APIs
      • Control APIs
      • Force.com APIs
        • Apex Bulk
        • Apex Execute
        • Extract Salesforce Layout
      • List Compare API
      • String APIs
      • UI Testing APIs
        • UI Action
        • UI Assert
        • UI Connect
        • UI Fill
        • UI Handle Alert
        • UI Navigate
        • UI On Screen
        • UI With Row
      • Custom APIs
        • Importing and Executing JAR Files
        • Creating Custom APIs
    • Environment Management
    • Debugging Tests
    • Running Tests
    • Test Cycles
    • Reporting
    • Exporting Test Cases
    • Exporting Projects
    • Callable Tests
      • Introduction to Callable Tests
      • Managing Parameters
      • Reusing a SFDC Connection
    • Data Driven Testing
      • DDT Introduction
      • Read Data From Excel
      • Write Data Into Excel
    • Tooltip Testing
    • Defining a Namespace Prefix on a Connection
    • Defining Proxy Settings
    • Namespace Org Testing
    • Searching Provar with Find Usages
    • Secrets Management and Encryption
    • Testing Browser Options
  • Salesforce Testing
    • Assert Page Error Messages on Add/Edit Product
    • Internationalization Support
    • Lightning Testing
    • List and Table Testing
    • Service Cloud Console Testing
    • Visualforce Testing
      • Introduction to Visualforce Testing
      • Introduction to XPaths
      • Maintaining Page Objects
      • Page Object Operations
      • Mapping Non-Salesforce Fields
      • Creating an XPath
  • Applications Testing
    • Database Testing
      • Database Testing Setup
      • Database Operations
    • Document Testing
    • Email Testing
      • Email Testing Setup
      • Email Testing Examples
    • Force.com Testing
    • Mobile Testing
      • Mobile Emulation
      • Mobile Testing with Appium
      • Perfecto mobile
      • ServiceMax FSA Mobile Testing
    • OrchestraCMS Testing
    • Salesforce CPQ Testing
    • ServiceMax Testing
    • Skuid Testing
    • Vlocity Testing
    • Webservices Testing
      • Web Services Introduction
      • Creating a Web Service Connection
      • Web Services Testing
  • DevOps
    • Introduction to Test Scheduling
    • Apache Ant, Java JDK and Environment Variables
    • Generating a Build File
    • ANT Task Parameters
    • ANT Licensing
    • Version Control and DevOps
    • Setting Up Continuous Integration
    • Masking Credentials in Jenkins
    • Running Provar on Linux
    • Salesforce DX
  • Version Control
    • Git
      • Introduction to Git Integration
      • Creating a Provar Repository
      • Git and Provar Projects
      • Working with Git
    • Team Foundation Server
  • Integration
    • Micro Focus (HP) ALM
    • Jira
    • Salesforce Test Integration Package
  • Best Practices
    • Supported Testing Phases
    • Automation Planning
    • Test Case Design
  • Troubleshooting
    • Add Floating License Firewall Exception
    • Add Gmail Firewall Exception
    • Add Permissions To Edit Provar.ini File
    • Common Install or Update Issues
    • Configure Provar UI in High Resolution
    • Enable Prompt To Choose Workspace
    • Increase System Memory For Provar
    • JavascriptException error via IE
    • Out of Memory error during CI Execution
    • Override Chrome Driver Version
    • Overriding the Chrome Install Location
    • Refreshing Org Cache Manually
    • Resolving Jenkins License Missing Error
    • Resolving Metadata Timeout Errors
    • Salesforce Connection Issues
    • Show Hidden Provar Files On Mac
    • Solving Administrator has Blocked Access to Client Errors
    • Test Builder Does Not Launch
    • Test Case Does Not Run on IE Browser
    • Test Case Steps Do Not Display
    • Test Execution Fails – Firefox Not Installed
  • FEATURES
  • RESOURCES
  • FAQs
  • BLOG
  • SUPPORT
  • HELP
  • CONTACT US
Copyright Provar 2019    |   All Rights Reserved
TwitterYouTubeLinkedinVimeo