Database connectors

With Biwee, you can connect to different databases. Here is a description of the configuration of the different connectors.

Microsoft SQL Server

To connect to SQL Server, here is the information you need to fill in.

• Connection name: Name that will be saved in your Biwee resources

• Server: Adress or name of the database server

• Authentication:

  • Select SQL Server Authentification or Windows Authentification

  • Username

  • Password

• Database:

  • Select the database name from the list box.

• Possibility to import an alias.
• Possibility to change the connection string.

Microsoft Access

To connect t o your Access database, here is the information you need to fill in:

• Connection name: Name that will be saved in your Biwee resources.

• Database: You can browse in your Windows explorer, select your Acess database or you can directly enter the location in the corresponding field.

• Authentication:

  • Username

  • Password

• Possibility to import an alias.
• Possibility to change the connection string.

Oracle SQL

To connect to your Oracle SQL database, here is the information you need to fill in:

• Connection name: Name that will be saved in your Biwee resources.

• Server: Address or name of the database server.

• Port

• Authentication:

  • Username

  • Password

• Database: Enter the name of your database.

• Possibility to import an alias.
• Possibility to change the connection string.

My SQL

To connect to your MySQL database, here is the information you need to fill in:

• Connection name: Name that will be saved in your Biwee resources.

• Server: Address or name of the database server.

• Port: Default value -> 3306

• Authentication:

  • Username

  • Password

• SSL: Secure information exchange. You can choose from: Prefer, Require or Disabled.

• Database: Select the name of the database in the list box.

• Possibility to import an alias.
• Possibility to change the connection string.

MongoDB

To connect to your mongoDB database, here is the information you need to fill in:

• Connection name: Name that will be saved in your Biwee resources.

• Connection string

• Password

• Database: Enter the name of your database.

Hyperfile SQL

Connect to a server

To connect to your Hyperfil SQL database, here is the information you need to fill in:

• Connection name: Name that will be saved in your Biwee resources.

• Server: Address or name of the database server.

• Port

• Authentication:

  • Username

  • Password

• Database: Select the database name from the list box.

Connect to a file

Enter the location of the database or select the database via Windows Explorer.

• Possibility to import an alias.

• Possibility to modify the connection string.

• A link to the driver is available if needed.

Firebird SQL

To connect to your Firebird SQL database, here is the information you need to fill in:

• Connection name: Name that will be saved in your Biwee resources.

• Server: Address or name of the database server.

• Port: Default value -> 3050

• Authentication:

  • Username

  • Password

• Database: Enter the location of your database.

• Possibility to import an alias.
• Possibility to change the connection string.

PostgreSQL

To connect to your PostgreSQL database, here is the information you need to fill in:

• Connection name: Name that will be saved in your Biwee resources.

• Server: Address or name of the database server.

• Port

• Authentication:

  • Username

  • Password

• SSL: Secure information exchange. You can choose from: Prefer, Require or Disabled.

• Database: Enter the location of your database.

• Possibility to import an alias.
• Possibility to modify the connection string.

SQLite

To connect to your SQLite database, here is the information you need to fill in:

• Connection name: Name that will be saved in your Biwee resources.

• Database: You can browse in your Windows explorer, and select your SQLite database file.

• Authentication:

  • Username

  • Password

• Possibility to import an alias.
• Possibility to modify the connection string.

Azure Table

To connect to your Azure Table database, here is the information you need to fill in:

• Connection name: Name that will be saved in your Biwee resources.

• Account name

• Table name

• Key: access key to connect to your Azure Table.

• Lines limit: The maximum number of lines in your query.

OLE DB

To connect to your OLE DB database, here is the information you need to fill in:

• Connection name: Name that will be saved in your Biwee resources.

• Connection string

The connection string is in the following form:

Provider='Your provider'; Data Source='Location of your database';User ID='Your login';Password='Your password'; Example: Provider=Microsoft.Jet.OLEDB.4.0; Data Source=d:\Northwind.mdb;User ID=Admin;Password=;

• Possibility to import an alias

ODBC

To connect to your ODBC database, here is the information to fill in:

• Connection name: Name that will be saved in your Biwee resources.

• Connectio string

• Possibility to import an alias.

IBM DB2

To connect to your IBM DB2 database, here is the information you need to fill in:

• Connection name: Name that will be saved in your Biwee resources.

• Server: Adress or name of the database server.

• Authentication:

  • Username

  • Password

• Database: Enter the name of your database.

• Possibility to import an alias.
• Possibility to modify the connection string.

Amazon Redshift

To connect to your Amazon Redshift database, here is the information you need to fill in:

• Connection name: Name that will be saved in your Biwee resources.

• Server: Address or name of the database server.

• Port

• Authentication

  • Username

  • Password

• SSL: Secure information exchange. You can choose from: Prefer, Require or Disabled.

• Database: Enter the name of your database.

• Possibility to import an alias.
• Possibility to modify the connection string.

Common features

SSL

SSL allows to protect data by encrypting them during their transfer between the database and Biwee. We offer 3 modes in Biwee:

DISABLED: SSL is not used and the connection is not encrypted.

PREFERRED: An encrypted connection is established if the database server supports it, otherwise a non-encrypted connection will be used.

REQUIRED: An encrypted connection is established. If the database server does not support it, the connection fails.

Importing an alias

It is possible to use aliases to temporarily rename a column or table in a query.

Example: A column that is normally called c_iso_3166 can be renamed "country_code" (cf. the ISO 3166 code corresponds to the country code), which is easier to understand in the rest of the code by a developer.

To import your alias, click on the "Import alias" button, select your alias as a .txt file in the Windows explorer and validate.

The format of the expected file is the following :

• A text file with the extension .txt, with 2 columns separated by a tab

• A header line with the title of the each of the 2 columns : column and alias for example

• One line for each column to rename containing its original name, and the alias, separated by a tab

Modify the connection string

For most of the connectors it is possible to directly modify the connection string.

It is of the following form:

Data Source='Address or name of your server' ;Initial Catalog='Name of your database' ;Integrated Security='True or False' ;User ID='Your login';Password='Your password'.