How to connect to the database provider

Database Management Help

Connection to Microsoft SQL Server, Oracle, MySQL Server

  1. Choose on the one of three first options on the Select data provider tabpage and click Next.
  2. Specify server name, username and password.

  3. From the dropdown list select database where the data will be extracted from.

  4. Preview tables from selected database.

  5. Type the name of the database connection and click on the Finish button.

Connection to Microsoft Access, DBASE file

  1. Choose on the "Microsoft Access" or "DBase file" option on the Select data provider tabpage and click the Next button.
  2. The next "Open dialog" will appear. Select database file you wish to load and click Open.

  3. In File name text box you can see the path of the selected database file. If you want to change the database file click on the ...button.

  4. Type the name of the database connection and click on the Finish button.

Connection to Other Data Source

  1. On the page of Databases Connection wizard choose last option.
  2. The next Data Link Properties wizard will appear. Select provider and click the Next button.

  3. On tab page Connection of Data Link Properties wizard, you can specify the database connection properties such as database server name, database name, user name, password and etc. It necessary to check option Allow saving password to open database.

    Click Test connection button to check if connection succeded. If the connection succeeds, click OK.

    On the Connection tab, click OK button to close the Data Link Properties window.