Data sources

The menu option [Resources > Data sources] is used to integrate the Web Server with other applications and databases. This screen is also found in the Berkeley Runner.

The Berkeley Web Server and Berkeley Studio can make a connection with Interbase databases, Oracle databases, MySQL databases, XML files and can send emails. Also, Fixed Connections can be created. These are custom connections which are customized to your needs. Therefore, we recommend contacting Berkeley Bridge if you are interested in using any of these functions.

That being said, below is a quick overview of all the options with short descriptions of the required parameters. Just select the type of connection you want on the left side of the screen. The [New] button will display the type you have selected.

New datasource
New datasource

If you press the [New] button, a new data source will be created. You can rename the data source by selecting the data source in the tree on the left and pressing [F2], or right mouse click and selecting Rename. It is also possible to connect with SOAP, but the definition of a SOAP connection is done with the use of a separate XML-file.

In the screen Data sources you can see the description of the SOAP connection but you cannot edit it.

Example of an Oracle data source
Example of an Oracle data source

Interbase

An Interbase-/Firebird connection needs the following parameters:

  1. Servername : URL to the database server
  2. Database file: file name of the database, with the path relative to the server (this has to be a local path)
  3. Username: username for the database
  4. Password: password for the database
  5. Role: database role in Firebird or Interbase
  6. Charset : the character set of the database
  7. Use unicode : if wanted, unicode can be used

With the button Test connection you can check if the settings are correct.

Oracle

An Oracle connection needs the following parameters:

  1. Servername : URL to the database server
  2. SID: the databases’ SID
  3. Username: username for the database
  4. Password: password for the database
  5. Charset : the character set of the database
  6. Use unicode : if wanted, unicode can be used

MySQL

A MySQL connection needs the following parameters:

  1. Servername : URL to the database server
  2. Database file: file name of the database, with the path relative to the server (this has to be a local path)
  3. Username: username for the database
  4. Password: password for the database
  5. Charset : the character set of the database
  6. Use unicode : if wanted, unicode can be used

XML

An XML connection needs the following parameters:

  1. Filename : the full local path to the XML file and the filename (NOTE: absolutely no spaces allowed).

Email

For a tutorial on how to send an e-mail, see our tutorial on sending mail. An Email connection needs the following parameters:

  1. Servername: SMTP serveraddress
  2. Serverport: SMTP serverport (default 25)
  3. Username: user name (optional, depending on the server settings)
  4. Password: password (optional, depending on the server settings)
  5. Security:
    • No security (information is not protected on the internet)
    • Implicit SSL (information is a little protected on the internet)
    • Explicit SSL (information is quite good protected on the internet)

SOAP

A SOAP connection is defined as an XML file where the question and answer are defined. For more information you can contact Berkeley Bridge.