How to Connect to the Database Provider

← Database Management Help

Available Database Providers

Database Connection Wizard

Connection to Microsoft SQL Server, Oracle, MySQL Server

  1. Select one of the first three options on the Select Data Provider page and click Next.
  2. Enter server name, username, and password.
    SQL/Oracle/MySQL Server Connection
  3. From the dropdown list, select the database you want to extract data from.
    Select Database
  4. Preview tables from the selected database.
    Select Table from Database
  5. Type a name for the database connection and click Finish.
    Name the Database Connection

Connection to Microsoft Access or DBASE File

  1. Select Microsoft Access or DBase file option on the Select Data Provider page and click Next.
  2. In the file dialog, choose the database file you wish to load and click Open.
    Access/DBASE Connection