Database 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.

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

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.

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.

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.

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.

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.

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

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=;

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

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.

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.

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'.